Under Codeigniter, is it possible to see mysql_error()?

Question

I have an Codeigniter app (latest version of CI) 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 myslq error message?

Answer 1

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

http://codeigniter.com/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://codeigniter.com/user_guide/database/configuration.html

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

Answer 2

Yes, this is the mysql_error() wrapper.

$this->db->_error_message();

And the mysql_errno wrapper is:

$this->db->_error_number();