ansaurus

Question

Answer 1

+1 A:

I have tried running an error query on purpose, but it logs as a normal query and doesn't report it with error. Any ideas?

so, you did it wrong. No other idea without the code.

in PHP I'm doing it this way (assume you're using mysql driver):

$res=mysql_query($sql) or trigger_error(mysql_error().$sql);

it will log all erroneous queries if you have log_errors setting on (and you have to)

EDIT: I see now, you want global level logging,m not application level. But may be application level will suit you as well?

Col. Shrapnel 2010-04-17 14:00:21

I input sql through phpmyadmin 3.3.2 are they doing it wrong?

Kaizoku 2010-04-17 14:11:22

@user phpmyadmin is single-user application, thus it don't need any logging.

Col. Shrapnel 2010-04-17 14:27:17

I see now, edited my answer

Col. Shrapnel 2010-04-17 14:30:03

Does trigger_error write to mysql log or php log? Because I got shell scripts that use mysql as well.

Kaizoku 2010-04-17 14:41:11

@user that's php directive. It's writing into standard PHP error log.

Col. Shrapnel 2010-04-17 14:44:30

thanks for answer, but does not solve my problem, this is php dependent.

Kaizoku 2010-04-17 14:49:47

How to log error queries in mysql?