I always end up with errors in my CodeIgniter log such as
ERROR - 2011-04-12 00:06:44 --> Query error: Duplicate entry '1391280167' for key 1
But it's not much help without context. Is there any way to record the query as well that caused this error?
I just took a quick peek inside the system/database/DB_Driver.php (line 323) file and it doesn't log the SQL query with any settings you choose. It should however print these messages to the screen if you are in db_debug mode.
If you don't mind messing with the files in the CI system folder, you could get the sql statement in your log file by changing system/database/DB_Driver.php (line 323, for CI 2.0.1) to:
log_message('error', 'Query error: '.$error_msg. ' - '. $sql);
As a start, you can get the last query that was run using $this->db->last_query()
So we could get the query as a string with the following snippet:
// strip out line returns, new lines and tabs
$query = str_replace( array("\r", "\n", "\t"), '', trim($this->db->last_query()) );
Once you have a string, we can log to the error log:
error_log( "Last database query: " . $query );
Note: Depending on your application logic and traffic, this could add tons of extra bloat to the error log over time, so I would recommend this is only used as a temporary troubleshooting tool.
Hope that helps.
Check if you have defined Auto Increment for the Primary Key, in the table in which you insert.
