mysql_free_result() Warning

[frank454]

A couple of other people have experienced the same problem i'm having. At the bottom of some pages, namely in the admin area I get the following message at the bottom of the page:

 

 

Warning: (null)(): 4 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0

 

I've tried the recommendation found here and other places, to use the following ini_set("mysql.trace_mode","Off"); in the application_top.php. I've tried placing that in other files, turning off error reporting and changing the value of define('STORE_SESSIONS', 'mysql');, but still nothing. Any suggestions?

 

Thanks

[kdjakovic]

Hello Pete,

 

the same thing happens to me. This message Warning: (null)(): 4 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0 comes with every php file. Only the number of results sets which are not free changes.

 

It seems that the PHP virtual machine does not free memory after using it for storing sql query results. It's a memory leak, but I don't know wheather it can be fixed via the php configuration or ini files.

 

Kata

[leschnei]

Hi,

This is more for a record than to help anyone... I also enabled sql error reporting at one point and get those pesky: "Warning: Unknown: 11 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0". Being embedded sw developer - my heart always stops for a second when I see "leak" mention. So, I looked up this explanation from

http://www.php.net/manual/en/function.mysql-free-result.php

"

mysql_free_result() only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. All associated result memory is automatically freed at the end of the script's execution.

"

 

So, it seems to be relatively benign, so I will switch this off...