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 3rd, 2007, 06:34 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Aug 2006
Posts: 44
SQL error in pp_inc line 2892?

After a hard disc crash my host transferred my site to another server. After that I receive the following message when I scan the database via the admin control. Also my users get the same warning when they try to upload a photo....the upload is succesfull, so no problem there, but how do I get rid of the error message?

Quote:
Preparing to update categories with photo and posts information...

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

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/joosenr/public_html/pp-inc.php on line 2893
This is the text in pp_inc on line 2893
Quote:
$lastc = ppmysql_query($query2, $link);
$catposts = mysql_num_rows($lastc);
list( $lastpostby, $lastpostbyid, $lastposttime, $lastpostlink ) = mysql_fetch_row($lastc);
wfcmod is offline   Reply With Quote
Old May 3rd, 2007, 09:15 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,806
Thats a valid line and query you sure your categories table is not corrupt?

Try doing a repair of the database via phpmyadmin in your sites control panel

You must have an older version cause thats not the line I get when I look at pp-inc.php
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   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
SQL Error [efs]ChAoS Photopost Pro How Do I...? 3 May 9th, 2006 11:33 AM
SQL Error cbr929rrerion Installs and Upgrade - vBulletin 3.5.X 3 March 3rd, 2006 03:56 PM
SQL Error digitalpoint Bugs - vBulletin 3.5.X 2 July 24th, 2005 10:21 PM
pp 5.1.1 sql error Fenriz Photopost Pro Bug Reports 5 June 11th, 2005 12:36 PM
SQL Error iphoto Photopost Pro Installation & Upgrades 1 November 12th, 2004 08:49 PM


All times are GMT -5. The time now is 03:03 PM.

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