Question

This question already has answers here:

CodeIgniter - how to catch DB errors? (12 answers)

Closed 11 months ago.

I have an Codeigniter app (using version 2.1.0) that is writing a transaction to a mysql database. I m fairly sure that I ve got a foreign key constraint error occurring, but I can find no way to make CI tell me the specific error. mysql_error() comes back empty.

Can anyone tell me how to get Codeigniter to tell me the mysql error message?

Answer 1

Yes, this is the mysql_error() wrapper.

$this->db->_error_message();

And the mysql_errno wrapper is:

$this->db->_error_number();

Answer 2

You may be able to use call_function in the db class to access mysql_error:

http://ellislab.com/codeigniter/user-guide/database/call_function.html

Of course, you could also just turn on the debug flag in the DB config, to tell CI to display db errors:

http://ellislab.com/codeigniter/user-guide/database/configuration.html

db_debug - TRUE/FALSE (boolean) - Whether database errors should be displayed.

友情链接