| mysql_fetch error in photopost
Within the last few days, our users haven't been able to post comments on uploaded pictures. After submitting the comment, the following errors flash on the screen for a few seconds.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0202/do8/s33/b02a1aof/www/domain/gallery/pp-inc.php on line 2809
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0202/do8/s33/b02a1aof/www/domain/gallery/pp-inc.php on line 2574
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0202/do8/s33/b02a1aof/www/domain/gallery/pp-inc.php on line 1162
Line 2809 in the pp-inc.php file is
while ( list( $id, $catname, $catdesc, $order, $catparent, $subalbum, $catthumbs, $children, $cattype, $albums ) = mysql_fetch_row($boards) )
Line 2574 in the pp-inc.php file is
while( list ( $checkrating ) = mysql_fetch_row($resultb) )
Line 1162 in the pp-inc.php file is
while ( $category = mysql_fetch_row($boards) )
If I run a repair on the comments table through phpMyAdmin and then try to submit the comment again it goes through with no problems
If I try to submit another comment on the same image or even a different image, the same three errors appear again and the comment doesn't get posted
Run the repair again and then I can post the comment
If I upload a new image, I can submit a comment successfully, even after receiving the errors above on a different image and not running a repair.
As soon as I try to submit a second comment on the newly uploaded image, the errors appear.
I'm hoping someone will have some insight into these errors, it's very frustrating at the moment.
Currently using PhotoPost 562 integrated with PHPBB version 2.0.22
Everything else seems to be functioning normally
Thanks in advance!
Gary
|