View Full Version : HELP! Warning: mysql_fetch_row Error!
June 9th, 2008, 10:55 AM
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?
June 9th, 2008, 10:58 AM
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.
June 9th, 2008, 11:03 AM
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.
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
June 9th, 2008, 11:05 AM
In your Admin => Sidebar Settings set a limit number on the number of popular images to pull. It can not be left blank.
June 9th, 2008, 11:12 AM
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!
June 9th, 2008, 11:16 AM
Not a problem glad to assist let us know if there is anything else we can assist with.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.