• Welcome to Valhalla Legends Archive.
 

[PHP] Weirdest Error?

Started by AC_Drkan, January 03, 2006, 09:31 PM

Previous topic - Next topic
Print
|
Go Down Pages1
User actions

AC_Drkan

January 03, 2006, 09:31 PM
Code Select
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

Im lost, looked it up on php.net and discovered it frees up memory from large queries to the SQL databse. Its located inside a footer from some scripts. Anyone wanna help a brother out on this one? I have never in my life, found this error.
"The Arguments of Today Result in the Wars of Tomorrow" - Quote By Muah.
Code Select
<@Logan> I spent a minute looking at my own code by accident.
<@Logan> I was thinking "What the hell is this guy doing?"
Code Select
<kow`> "There are 10 types of people in the world... those who understand binary and those who don't."
<SpaceRain> That's only 2 types of people, kow.
<SpaceRain> STUPID

Code Select
<[TN]FBMachine> i got kicked out of barnes and noble once for moving all the bibles into the fiction section

God i love Bash.org.

Akamas

#1
January 03, 2006, 11:45 PM
I haven't encountered an error like that either, but I would suggest that you go in phpmyadmin and select all tables and hit REPAIR, it might help.
Quote from: Arta[vL] on August 14, 2006, 04:57 PM
Well, I want some too. Greedy Yoni should stop hogging it.

AC_Drkan

#2
January 04, 2006, 12:42 PM
Tried it, it still does it.

Anyone else have any ideas?
"The Arguments of Today Result in the Wars of Tomorrow" - Quote By Muah.
Code Select
<@Logan> I spent a minute looking at my own code by accident.
<@Logan> I was thinking "What the hell is this guy doing?"
Code Select
<kow`> "There are 10 types of people in the world... those who understand binary and those who don't."
<SpaceRain> That's only 2 types of people, kow.
<SpaceRain> STUPID

Code Select
<[TN]FBMachine> i got kicked out of barnes and noble once for moving all the bibles into the fiction section

God i love Bash.org.

rabbit

#3
January 04, 2006, 08:12 PM
IIRC, that has to do with either a) the result of the query is far too large (IE: a few gigs), or b) your MySQL server is extremely busy and can't store all the data it needs to in memory.

Try talking to your host, or, if you host yourself, get more RAM.
Grif: Yeah, and the people in the red states are mad because the people in the blue states are mean to them and want them to pay money for roads and schools instead of cool things like NASCAR and shotguns.  Also, there's something about ketchup in there.

AC_Drkan

#4
January 04, 2006, 09:25 PM
Quote from: rabbit on January 04, 2006, 08:12 PM
IIRC, that has to do with either a) the result of the query is far too large (IE: a few gigs), or b) your MySQL server is extremely busy and can't store all the data it needs to in memory.

Try talking to your host, or, if you host yourself, get more RAM.

I thought that i might be too large but its only selecting 1 thing from the footer and thats only like 20 KB.  The SQL server i know isn't busy because im the only one using it. I have plenty of RAM to cover a 1 GIG SQL query, and have the CPU power to do it to.
"The Arguments of Today Result in the Wars of Tomorrow" - Quote By Muah.
Code Select
<@Logan> I spent a minute looking at my own code by accident.
<@Logan> I was thinking "What the hell is this guy doing?"
Code Select
<kow`> "There are 10 types of people in the world... those who understand binary and those who don't."
<SpaceRain> That's only 2 types of people, kow.
<SpaceRain> STUPID

Code Select
<[TN]FBMachine> i got kicked out of barnes and noble once for moving all the bibles into the fiction section

God i love Bash.org.

rabbit

#5
January 05, 2006, 10:09 PM
Hrm.  Then you'll probably want to take this to the MySQL forums.  Sorry I didn't help :\
Grif: Yeah, and the people in the red states are mad because the people in the blue states are mean to them and want them to pay money for roads and schools instead of cool things like NASCAR and shotguns.  Also, there's something about ketchup in there.
Print
|
Go Up Pages1
User actions