mysql log of failed inserts?

[id10t]

Using debian stable...

Is there a log somewhere of failed mysql commands? These would have been generated by some bad php scripting... looking to find failed inserts.

Thanks

[Ben]

Maybe this helps you a bit: http://dev.mysql.com/doc/refman/5.1/...r_log_warnings

But afaik you can not log mysql-errors caused by any script or whatsoever. So it's part of the script itself to do the errorhandling and logging.