HELP! Warning: mysql_fetch_row Error!

[billy]

Just upload a heap of photos via Zip Upload and got this frustrating error message which wont go away when viewing photos:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/rudephot/public_html/pp-inc.php on line 5028

Any suggestions how to fix it?

[Chuck S]

What version of the software are you running? That line is a blank line for me in that file.

You can set in Admin => Global Options the debug setting to DISPLAY ERRORS when logged in as admin this will give you the true error and assist us in helping you know whats going on.

[billy]

Thanks Chuck for your quick reply... as requested:

Current Version 6.0

I set the DISPLAY ERRORS and it says as follows:

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

Script: showphoto

Query: SELECT count(*) AS vcount,avg(c.rating) AS avgr,p.cat,p.id,p.title,p.rating AS avgr FROM comments c LEFT JOIN photos p ON p.id=c.photo WHERE p.numcom > 1 GROUP BY c.photo ORDER BY avgr desc,vcount desc LIMIT

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

Database handle: Resource id #6

[Chuck S]

In your Admin => Sidebar Settings set a limit number on the number of popular images to pull. It can not be left blank.

[billy]

Chuck, all I can say is you are an absolute champion! Thanks so much, your always around to help when I need you! Thanks Mate, problem fixed!

[Chuck S]

Not a problem glad to assist let us know if there is anything else we can assist with.