Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.
astions wrote:Try setting mysql.trace_mode to off in php.ini.
I researched this issue on google, None of the people having this problem that I found were able to fix it. They were able to supress the errors by turning off mysql.trace_mode.
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)
Why your server has that enabled is a mystery since it is normally turned off. About the only reason to enable that flag in php is to try and track down queries performing table scans and result sets that aren't being freed by the script before execution ends. Basically a way to help tidy up your mysql queries. It shouldn't be enabled except for testing purposes.
If you are using PHP5 just edit the class and add a destructor that calls mysql_free_result() and it will work on all the files using that class. If not, then switch, because its better
Edit: Oh, was this solved already? Didn't notice the replies on page 2 >_<