Bug (closed)

MySQL-Error: result set(s) not freed

Summary

closed
Oct 18, 2006
100%
Oct 18, 2006 / pixtur
Jan 2, 2007 / pixtur
 

Attached files

Summary
db_settings.php
511 bytes / ID 2588 / Oct 18, 2006
Show Details
error.log
96119 bytes / ID 2589 / Oct 18, 2006
Show Details
errors.log.php
6858 bytes / ID 2590 / Oct 18, 2006
Show Details
php.ini
42813 bytes / ID 2591 / Oct 18, 2006
Show Details
phpinfo().htm
49211 bytes / ID 2592 / Oct 18, 2006
Show Details
 
This bug was reported by Thomas Rueger.

pixtur: I never heard about those result sets before ;-)

The problem seems to be, that there somehow is a request for a project without valid id (where project=''). So this could be a messed up installation...

Any idea?

without any project...
Error 20061018110358 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110358    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php
Error 20061018110358 
Log 20061018110405 usertime offset = 7200 sec
Log 20061018110405 'admin' logged in from 127.0.0.1

Error 20061018110406 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110406    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php
Error 20061018110406 

after creating project and loggin out...

Error 20061018110358 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110358    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php
Error 20061018110358 
Log 20061018110405 usertime offset = 7200 sec
Log 20061018110405 'admin' logged in from 127.0.0.1

Error 20061018110406 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110406    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php
Error 20061018110406 

Error 20061018110446 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110446    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php?go=projList
Error 20061018110446 

Error 20061018110448 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110448    v0.07rc1, from 127.0.0.1,  uri:/streber/index.php?go=projNew&from=1d70b439ed4225c80c14b9167720af3f
Error 20061018110448 

Error 20061018110456 WARNING:              Unknown :   0 Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()
Error 20061018110456    v0.07rc1, projEditSubmit, from 127.0.0.1,  uri:/streber/index.php
Error 20061018110456 

Error 20061018110509 WARNING: dbdb_mysql_class.php : 117 mysql_query() [<a href='http://www.mysql.com/doc'>http://www.mysql.com/doc</a>]: Out of range value adjusted for column 'project' at row 1
Error 20061018110509                 dbdb.inc.php : 248 -> sql_class::execute("UPDATE item SET id='1', type='")
Error 20061018110509            dbdb_item.inc.php :1048 -> DB_MysqlStatement::execute("", int1)
Error 20061018110509           pageslogin.inc.php : 252 -> DbProjectItem::update()
Error 20061018110509 stdclass_pagehandler.inc.php : 664 -> logout()
Error 20061018110509                     index.php : 339 -> PageHandler::show("logout")
Error 20061018110509 
Error 20061018110509      Variables in execute():
Error 20061018110509                     tmp_query = UPDATE item SET id='1', type='3', created_by='1', created='0000-00-00 00:00:00', modified_by='1', modified='2006-10-18 11:05:09', deleted_by='0', deleted='0000-00-00 00:00:00', pub_level='4', state='1', project='' WHERE id=1
Error 20061018110509    v0.07rc1, logout, from 127.0.0.1,  uri:/streber/index.php?go=logout
Error 20061018110509 

Error 20061018110509 ERROR:        dbdb.inc.php :  38 Database exception. Please read <a href=http://streber.pixtur.de/index.php?go=taskView&tsk=1272'> next steps on database errors.</a>
Error 20061018110509                 dbdb.inc.php : 249 -> MysqlException::__construct("Querry=UPDATE item SET id='1',")
Error 20061018110509            dbdb_item.inc.php :1048 -> DB_MysqlStatement::execute("", int1)
Error 20061018110509           pageslogin.inc.php : 252 -> DbProjectItem::update()
Error 20061018110509 stdclass_pagehandler.inc.php : 664 -> logout()
Error 20061018110509                     index.php : 339 -> PageHandler::show("logout")
Error 20061018110509 
Error 20061018110509      Variables in __construct():
Error 20061018110509                       message = Querry=UPDATE item SET id='1', type='3', created_by='1', created='0000-00-00 00:00:00', modified_by='1', modified='2006-10-18 11:05:09', deleted_by='0', deleted='0000-00-00 00:00:00', pub_level='4', state='1', project='' WHERE id=1
Error 20061018110509 
Error 20061018110509                          code = NULL
Error 20061018110509                       sql_obj = Object id #21
Error 20061018110509                   mysql_error = Out of range value adjusted for column 'project' at row 1
Error 20061018110509    v0.07rc1, logout, from 127.0.0.1,  uri:/streber/index.php?go=logout
Error 20061018110509 

maybe this line from error.log has also some importance:
[Wed Oct 18 11:16:45 2006] [error] [client 127.0.0.1] PHP Warning:  PHP Startup: Unable to load dynamic library './php_mysql.dll' - Die angegebene Prozedur wurde nicht gefunden.n
[Wed Oct 18 11:16:45 2006] [error] [client 127.0.0.1]  in Unknown on line 0n


Interesting is the fact, that mysqli extension is not loaded in the php.ini but nevertheless used for the install procedure and in the db_settings.inc.php. Obviously this is a bug.

Issue report

Minor
Have not tried
 

10 Comments

r.rueger:result set(s) not freed - More infos

11 years ago

Checked a little bit and found following:
-- Making a resultset needs also mysql_free_resultset

But it should only rembember you. So, if you make the following:

mysql.trace_mode in php.ini

you should not get the warning ...

But my test system crash with or without that warning ..


pixtur:Did you test earlier versions (e.g. v0.068) with the same setup?

11 years ago


r.rueger:Reply to Did you test earlier versions (e.g. v0.068) with the same setup?

11 years ago

No

r.rueger:Reply to Did you test earlier versions (e.g. v0.068) with the same setup?

11 years ago

No

pixtur:Please adjust db_settings.inc.php

11 years ago

Please change mysqli to mysql and try again.


r.rueger:New Comment

11 years ago

Done, same error :-(

pixtur:Please attach your MySQL settings file

11 years ago

It should be called my.ini and is probably located under c:/windows.

Can you also try to use mysqladmin to "repair tables"?



pixtur:r.rueger...

11 years ago

I invested some hours in trying to reconstruct this bug with my own setup but I couldn't...

So I moved this issue to the next milestone.

pixtur:Removed from milestone...

11 years ago

removed from

guest:Plz help me!!!!!!!!!!

10 years ago -

Warning: Unknown: 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