RE: [PEAR] MDB: executeQuery() - Error Handling Bug?

Lukas Smith schrieb in php.pear.general: >> when $mdb->executeQuery() produce an error, the error object don't >> contains a callback so a defined >> $mdb->setErrorHandler('handle_error'); is not called. >> >> There is no problem with error handling using other methods like >> execute() or queryAll(). I use MDB 1.1.1. >> >> Here is an error object produced by executeQuery(): >> >> mdb_error Object >> ( >> [error_message_prefix] => >> [mode] => >> [level] => >> [code] => -20 >> [message] => MDB Error: insufficient data supplied >> [userinfo] => Execute query: it was not defined query argument 1 >> [callback] => >> ) > > Hi, > > thx for your report. > I dont quite understand the issue you are talking about here (I don't > use the setErrorHandler() method). Could you explain in a bit more > detail what is happening or not happening. And what needs to happen > instead. $mdb = &MDB::connect($dsn); $mdb->setErrorHandler('handle_error'); Now the 'handle_error'-function is automaticly called, if an MDB method produces an error. I use this: function handle_error($error_obj) { global $show_debug; if ($show_debug) { $error_msg = '<span class="error"><pre><b>MDB-Error</b><br />' . $error_obj->getMessage() . '<br />' . 'DebugInfo: ' . $error_obj->getDebugInfo() . '<br /></pre></span>'; print $error_msg; } else { $error_msg = '<p><b>Database Error!</b><br />' . 'Please contact the administrator</p>'; die($error_msg); } } This works always as expected and the $error_obj from a MDB method contains usually [callback] => handle_error. Only the method $mdb->executeQuery() generate an error_obj with an empty [callback] as shown in the first posting. I think, that is the reason why handle_error() is not called when $mdb->executeQuery($stmt); produces an error. > Also what DB driver are you using. MySQL Thomas. -- http://4bconsult.de