MySQL warning: 1 result set not freed

notgoddess
notgoddess's picture

Joined: 2005-04-03
Posts: 178
Posted: Sun, 2005-07-17 19:47

Greetings,

Warning: (null)(): 1 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 know that's completely unhelpful when debugging, but if it helps I do get it on all Gallery2 pages and when installing.

NotGoddess

----

Gallery URL (optional): local machine/server, sorry :(
Gallery version: Gallery2 cvs 2005-07-17 (1pm cst)
Webserver (with version): Apache/1.3.33
Datatabase (with version): MySQL 4.1
PHP version (eg 4.2.1): 4.3.12
Graphics Toolkit(s): GD2
Operating system: Win98 (I know-feel free to buy me a new computer :)
Web browser/version: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
G1 version (for migration bugs): n/a
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Sun, 2005-07-17 20:42

thanks for reporting. but yes, it's rather unhelpful :/

can you activate immedate debug mode in config.php and then post the complete debug output here when you browse to main.php and it displays this warning somewhere?
 
notgoddess
notgoddess's picture

Joined: 2005-04-03
Posts: 178
Posted: Mon, 2005-07-18 09:55

I've attached the three following files:
debugscrape.txt : The full screen copy direct from the browser.
debuglog.txt: the debug log created by setting debug to 'logged'
debugsmart.txt: the info from the smarty debug console

I hope these will help. Nothing immediate popped out at me.

Ng
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2005-07-18 10:15

notgoddess, thanks. maybe there's a bug in g2 and the debugscrape.txt could help finding it. maybe it's a win98/mysql/php issue. who knows.

so, this may never get fixed (either because we can't find the "bug" or because it's considered too low priority as win 98 is not a supported platform). fixing something without being able to reproduce it is sometimes pretty difficult.

bug tracker:
http://sourceforge.net/tracker/index.php?func=detail&aid=1240154&group_id=7130&atid=107130
 
notgoddess
notgoddess's picture

Joined: 2005-04-03
Posts: 178
Posted: Mon, 2005-07-18 10:44

I've inserted a few debugs of my own to try to track down the error.
If I have any luck, I'll let you know.
 
jano73

Joined: 2007-08-04
Posts: 4
Posted: Fri, 2008-01-25 06:03

I get the same error when upgrading from 2.2.2 to 2.2.4. I am using windows XP.
Upgrade displays this error and gets stuck.