• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Friends website...

H

HelioX

Gawd
Joined
Jun 11, 2010
Messages
705
Anyone have any idea as to what this error message means?


Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/content/f/u/l/fuleinc/html/_lib/class/mysql.php on line 57
SELECT * FROM facts_posts WHERE (1=1) ORDER BY date DESC;MySQL client ran out of memory
 
did he run a repair on the mysql database itself?

I mean this is usually an issue with the actual installation of MySQL
 
edit - oops i thought it said WHILE but it says WHERE. let me read throgh it again lol.
 
Last edited:
Perhaps this is a very large table, and the website is failing to select all of it (you are selecting every row) due to set php memory limitations?
 
Oneos said:
Perhaps this is a very large table, and the website is failing to select all of it (you are selecting every row) due to set php memory limitations?
Click to expand...

^ Most likely this. Add some pagination to whatever page it is you are selecting everything from.
 
caniba said:
That 1=1 doesn't make any sense.
Click to expand...
I've seen and used this for a variety of reasons. One common reason is so that you can dynamically build out your parameterized SQL statement with less work by simply appending "AND..." statements.
 
Also possible that this is on a cheapo shared hosting or low memory VPS plan and the account is simply out of memory even if the table isn't that large. Need more info than just the error message. Where is it hosted, what else is running, database stats, etc.
 
The condition where 1=1 is just a condition that is always true, so that query is going to select everything from that table, if it's a particularly large table and the web server doesn't have a lot of resources (memory) then you may get out of memory errors like that.

A quick test to see if it's a resource problem would be to limit the number of results returned, change the query to:

SELECT * FROM facts_posts WHERE (1=1) ORDER BY date DESC LIMIT 0,10

This will just return the first 10 results instead of everything.

In the long run you need to decide if every record really needs to be selected from that specific table, if it does then paginating results returned would keep the query size down, or adding some sensible conditions to decrease the number of results.
 
You must log in or register to reply here.
Back
Top