MySQL error logging

[Syngin]

Does anyone know where the setting is for log locations for MySQL? I've got a query erroring out with little to no info and the mysql logs on the server are empty except for a list of queries.

I've looked through /etc/mysql/my.cnf but am unable to find specific settings related to error log settings or location. (there's one reference to /var/log/mysql/mysql.log but this contains no errors)

/var/log/mysql.err and /var/log/mysql.log are both empty.

There is a directory /var/log/mysql too but the main file in there (mysql.log also) is only listing queries, no errors. Nothing in syslog either.

This is a Debian Sarge server.

Does anyone know how I can bump up the level of error reporting on either the MySQL or PHP side of things? I make use of mysql_error command but all it kicks back is:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This line # seems ambiguous too as the error has to be occuring on another line that it doesn't seem to want to report.

I get this on all 3 of the pages I'm having issues with.

Also, having looked at the Server Variables area in PHPMyAdmin, the 'log error' variable is blank.

Thanks guys.

[je_fro]

What about permissions on those logfiles?

ls -l /var/log/mysql/
ls -l /var/log/mysql.*