|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
  [2005-05-24 09:08 UTC] stephaneey at hotmail dot com
 Description:
------------
Hello,
sqlite_last_error() is supposed to return the error code from SQLite when a SQL statement fails. In case of error, this function returns always 1. So if you do
echo sqlite_error_string(sqlite_last_error()); you always get the same error message description which is:
SQL logic error or missing database. The method "lastError()" of the super class SQLiteDatabase behaves the same way!
This is very annoying because you're warned about the error but you cannot log it correctly in a log file for example nor applying a specific treatment to a specific error
Reproduce code:
---------------
<?
/* Using procedural functions */
$db=sqlite_open('testdb.db');
sqlite_exec('CREATE TABLE a_table(a_col);');
//Creation of a faulty statement
sqlite_exec($db,'INSERT INTO invalid_table VALUES(\'a_value\');') or showError(sqlite_last_error($db));
/*This should return:
no such table : invalid_table...
*/
/*Generation of another error*/
sqlite_query($db,'SELECT b_col FROM a_table;') or showError(sqlite_last_error($db));
/* This should return 
no such column: b_column...
*/
function showError($err_code)
{
 echo sqlite_error_string($err_code);
 //Will always result in "SQL logic error or missing..."
}
?>
Expected result:
----------------
As mentionned in the code itself, I'd expect to get an appropriate error code in order to :
- Log the errors correctly in an error file
- In case of exceptions handling, take the appropriate action according to the last error
Actual result:
--------------
Bad error code returned since it's always the same no matter of what the real error is!
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits             | |||||||||||||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 01:00:01 2025 UTC | 
Hello, Indeed, that's actually right. It's a pity that SQLite doesn't return an error code corresponding to the warnings it generates. Just this example: $db->queryExec('INSERT INTO unknown_table VALUES...') will generate a warning of type "no such table unknown_table..." but PHP will get the error code 1 corresponding to "SQL logic error or missing database" which is really a pity since all the wrong SQL statements will end up with such error code!