{"id":1500,"date":"2022-08-30T15:17:03","date_gmt":"2022-08-30T15:17:03","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/23\/fatal-error-uncaught-exception-mysqli_sql_exception-with-message-no-index-used-in-query-prepared-statement-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:17:03","modified_gmt":"2022-08-30T15:17:03","slug":"fatal-error-uncaught-exception-mysqli_sql_exception-with-message-no-index-used-in-query-prepared-statement-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/fatal-error-uncaught-exception-mysqli_sql_exception-with-message-no-index-used-in-query-prepared-statement-collection-of-common-programming-errors\/","title":{"rendered":"Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'No index used in query\/prepared statement'-Collection of common programming errors"},"content":{"rendered":"

When I run the following code, I get the error saying<\/p>\n

\n

Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query\/prepared statement’<\/p>\n<\/blockquote>\n

$mysql = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was a problem connecting to the database');\n        if (mysqli_connect_errno()) {\n            printf(\"DB error: %s\", mysqli_connect_error());\n            exit();\n        }\n\n    $get_emp_list = $mysql->prepare(\"SELECT id, name FROM calc\");\n    if(!$get_emp_list){\n        echo \"prepare failed\\n\";\n        echo \"error: \", $mysql->error, \"\\n\";\n        return;\n    }\n    $get_emp_list->execute();\n    $get_emp_list->bind_result($id, $emp_list);\n<\/code><\/pre>\n
And this is the able schema —<\/p>\n
--\n-- Table structure for table `calc`\n--\n\nCREATE TABLE IF NOT EXISTS `calc` (\n  `id` int(12) NOT NULL,\n  `yr` year(4) NOT NULL,\n  `mnth` varchar(12) NOT NULL,\n  `name` varchar(256) NOT NULL,\n  `paidleave` int(12) NOT NULL,\n  `balanceleave` int(12) NOT NULL,\n  `unpaidleave` int(12) NOT NULL,\n  `basesalary` int(12) NOT NULL,\n  `deductions` int(12) NOT NULL,\n  `tds` int(12) NOT NULL,\n  `pf` int(12) NOT NULL,\n  `finalsalary` int(12) NOT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\n<\/code><\/pre>\n
    \n
  1. \n
    Take a look at this bug-report : #35450<\/code><\/strong> mysqli extension reports too many warnings<\/p>\n
    Quoting a few sentences of a note :<\/p>\n
    \n
    Mysqli extension throws too many warnings.
    \nFor example, “SELECT * FROM table” results in a warning: “Warning: mysqli::query(): No index used in query\/prepared statement SELECT * FROM table …”<\/p>\n<\/blockquote>\n
    And, quoting another note, which seems interesting :<\/p>\n
    \n
    Use mysqli_report()<\/code> to disable that.<\/p>\n<\/blockquote>\n
    Humph, unfortunately, that function is deprecated…<\/p>\n<\/li>\n
  2. \n
    The fatal error is not in MySQL; the missing index notification is a relatively low-severity warning.<\/p>\n
    The fatal<\/em> error is in your PHP code, because of the following three conditions:<\/p>\n
      \n
    • mysqli reports a lot<\/em> of warnings, even for relatively harmless conditions.<\/li>\n
    • You’re throwing mysqli_sql_exception<\/code> for all errors and<\/em> warnings due to your mysqli_report(MYSQLI_REPORT_ALL);<\/code> line.<\/li>\n
    • Your PHP code is not catching that exception (i.e. it’s not in a try{}<\/code> block with an appropriate catch(){}<\/code> block), and uncaught exceptions are fatal.<\/li>\n<\/ul>\n
      You can’t do much about the first one, as mentioned in the other answer. So, you can fix it either by changing your mysqli_report(...)<\/code> setting to MYSQLI_REPORT_STRICT<\/code> or MYSQLI_REPORT_OFF<\/code> (or indeed anything other than MYSQLI_REPORT_ALL<\/code>), or in combination with this, by properly by using try{}<\/code> and catch(){}<\/code> appropriately within your code.<\/p>\n<\/li>\n<\/ol>\n
      Originally posted 2013-11-23 19:34:06. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
      When I run the following code, I get the error saying Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query\/prepared statement’ $mysql = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die(‘There was a problem connecting to the database’); if (mysqli_connect_errno()) { printf(“DB error: %s”, mysqli_connect_error()); exit(); } $get_emp_list = $mysql->prepare(“SELECT id, name FROM […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1500","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1500"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1500\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}