Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’

by

The fatal error is not in MySQL; the missing index notification is a relatively low-severity warning.

The fatal error is in your PHP code, because of the following three conditions:

  • mysqli reports a lot of warnings, even for relatively harmless conditions.
  • You’re throwing mysqli_sql_exception for all errors and warnings due to your mysqli_report(MYSQLI_REPORT_ALL); line.
  • Your PHP code is not catching that exception (i.e. it’s not in a try{} block with an appropriate catch(){} block), and uncaught exceptions are fatal.

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(...) setting to MYSQLI_REPORT_STRICT or MYSQLI_REPORT_OFF, or indeed anything other than MYSQLI_REPORT_ALL.

(edit: w3d’s comment below gives a good explanation why, and suggests you could use mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT) as a good alternative)

For best practices, and in combination with this, you should fix it properly by using try{} and catch(){} appropriately within your code.

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Commands out of sync; you can’t run this command now
  3. SELECT COUNT(*) AS count – How to use this count
  4. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  5. Order results from two queries based on time in second query [closed]
  6. Query database then email posts from where user is subbed to
  7. inserting information and image in php and mysql
  8. mysqli or die, does it have to die?
  9. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  10. How can I do ‘insert if not exists’ in MySQL?
  11. MySQL vs MySQLi when using PHP [closed]
  12. Getting raw SQL query string from PDO prepared statements
  13. How to get count of rows in MySQL table using PHP?
  14. MySQL Prepared statements with a variable size variable list
  15. How can I enable the MySQLi extension in PHP 7?
  16. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  17. Advantages Of MySQLi over MySQL [closed]
  18. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  19. Doing a while / loop to get 10 random results
  20. check if the query results empty row mysqli [duplicate]
  21. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  22. Is mysql_real_escape_string() necessary when using prepared statements?
  23. Updating from MYSQL to MYSQLI [duplicate]
  24. php password_verify() hash and pass won’t match
  25. Get number of rows matched by UPDATE query with PHP mysqli
  26. PHP to MySQL SSL Connections
  27. how do I get month from date in mysql
  28. php/mysql zip code proximity search
  29. Strange problem with the length of the field gotten from database [duplicate]
  30. Aggregated query without GROUP BY

Leave a Comment