[SOLVED] mysql.trace_mode does not give any output

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

[SOLVED] mysql.trace_mode does not give any output

Post by Weirdan »

Do you have any ideas why setting the mysql.trace_mode option to 'On' in php.ini does not force the php to complain about sql syntax errors?
php manual wrote: mysql.trace_mode boolean

Trace mode. When mysql.trace_mode is enabled, warnings for table/index scans, non free result sets, and SQL-Errors will be displayed. (Introduced in PHP 4.3.0)
yet it does not show any sql-errors nor log it to the apache logfile.

Here's some info about my test system:

Code: Select all

PHP Version 4.3.4/WinXP
Server API 	Apache
display_errors	On
error_reporting	2047 (E_ALL)
log_errors	On

MySQL Support	enabled
Client API version 	3.23.49
mysql.trace_mode	On
[edit]
It turned out to be a php bug: http://bugs.php.net/bug.php?id=28087
[/edit]
Post Reply