PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Bug Reports

Photopost Pro Bug Reports Post post installation PhotoPost Pro problems here.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old May 9th, 2007, 11:54 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2007
Posts: 6
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
katana is offline   Reply With Quote
Old May 10th, 2007, 08:58 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,788
I would suggest trying to repair your entire database and if your database keeps corrupting you need to ask your host about this
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is this Cron error (not a photopost error) JakeC Photopost Pro Bug Reports 4 January 22nd, 2007 02:10 PM
PhotoPost 5.3 Error ClaytonR Photopost Pro Installation & Upgrades 4 March 24th, 2006 06:58 PM
New to photoPost - Got an error I can't figure out Quarterbore Photopost Pro Installation & Upgrades 0 February 10th, 2006 04:44 PM
Error to photopost iloco Photopost Pro Installation & Upgrades 6 December 23rd, 2004 10:19 AM


All times are GMT -5. The time now is 07:22 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0