Clicking on "Recent Photos: all" generates error

[kwrd]

When we click on the the "Recent Photos" links, they all work fine except for the "all" option.
When we click that, we get this error at the very top of the page:

Warning: mysql_query(): Unable to save result set in /home/digital/public_html/gallery/pp-inc.php on line 285


and then below that is a Gallery Message:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,storecat,date,title,description,keywords,bigimage,width,height,
filesize,views,medwidth,medheight,medsize,approved,rating,allowprint,numcom,
lastposter FROM photos WHERE approved < 2 ORDER BY date DESC

Result: MySQL client run out of memory

Database handle: Resource id #24


Any ideas on what's going on? We're using Photopost Pro 5.3. And I'm not sure for how long this has been happening.

[Chuck S]

Your mysql server is running out of memory and you might need to confer with your host to tweak there servers. This is a server related error and not one of the program code.

[kwrd]

Any suggestions on what needs to be tweaked? They've tried a bunch of things but nothing has fixed it so far.

[Chuck S]

yes your server needs more memory and you need to optimize the server and mysql databases