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 Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old March 9th, 2007, 01:09 AM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2004
Posts: 10
Getting a few errors out of the blue

Photopost has been working great but then all of sudden I get these two errors at the top, cant figure out what it is. I dont have forum integration.

http://www.mustangphotos.com/photopost/

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mrigney/www/photopost/forums/photopost.php on line 373

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mrigney/www/photopost/forums/photopost.php on line 332

Any help is great...

Last edited by theocshow; March 9th, 2007 at 01:32 AM.
theocshow is offline   Reply With Quote
Old March 9th, 2007, 07:49 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
I can not suggest what your problem might be because I do not know what lines 332 and 373 are in your file. Our Photopost.php file only has 296 lines so you must be using a way old Photopost.

I can take a guess here and suggest maybe you try repairing your iponline table and usergroups table in the Photopost database via say phpmyadmin

Let me know what those lines are so I can help you.
__________________
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
Old March 9th, 2007, 05:01 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2004
Posts: 10
Line 332-335 reads:

while ( list($ouser, $odate) = mysql_fetch_row($oqueryz)) {
$onumfound++;
if ( $ouser != "" && $ouser != "Unregistered" ) {
array_push($online_array, "$ouser");

Lines 373-375 read:

while ( list( $item, $itemonline ) = mysql_fetch_row($eachonline) ) {
if ( $item > 0 )
$catonline[$item] = $itemonline;

Code goes to line 449 in photopost.php

Do you think upgrading to latest version might help because in the admin area I am also getting another error, just noticed it.

It reads:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mrigney/www/photopost/adm-misc.php on line 981

Last edited by theocshow; March 9th, 2007 at 05:06 PM. Reason: need to add info
theocshow is offline   Reply With Quote
Old March 9th, 2007, 05:36 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
REPAIR TABLE pp_iponline

You need to run that in phpmyadmin your table is corrupt
__________________
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
Old March 9th, 2007, 10:51 PM   #5 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2004
Posts: 10
Chuck,

Never done it before, so all I do is in phpmyadmin just check that table iponline and go down to the drop down menu box near the bottom and select repair table and click go.

if thats all let me know

thanks,
theocshow is offline   Reply With Quote
Old March 10th, 2007, 12:24 PM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,940
yes that works as well
__________________
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
Old March 10th, 2007, 03:29 PM   #7 (permalink)
Junior Member
Verified Customer
 
Join Date: Feb 2004
Posts: 10
That fixed it up, thanks chuck
theocshow 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
Upload errors (out of the blue) aquariumpros Photopost Pro How Do I...? 2 November 12th, 2006 10:59 AM
Help with errors. flowrider Photopost Pro Installation & Upgrades 10 February 2nd, 2006 09:26 AM
What are these errors? gholsie Photopost Pro Installation & Upgrades 3 April 10th, 2005 10:05 AM
strange sql errors out of the blue, for no reason? sross Photopost Pro Installation & Upgrades 3 August 24th, 2004 08:19 AM


All times are GMT -5. The time now is 06:34 AM.

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