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 July 3rd, 2004, 08:20 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Mar 2004
Posts: 152
Question strange sql errors out of the blue, for no reason?

PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/showphoto.php on line 446
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/showphoto.php on line 142
PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/pp-inc.php on line 1562
PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/pp-inc.php on line 1555
PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/showphoto.php on line 446
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/showphoto.php on line 142
PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/pp-inc.php on line 1562
PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apug002/public_html/gallery/pp-inc.php on line 1555


I tried doing a db repair with no luck. am not very computer savvy so talk to me in kindergarden terms plz. thanks!
sross is offline   Reply With Quote
Old July 3rd, 2004, 08:50 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,938
The only thing that comes back lately about this is a failed kernel on the server machine.

Here is a quote from rbl. You can contact him further on the exact nature of his issue but this is the only thing I can recall with that error.

Quote:
Sorry for the delay on this one but it was a very nasty bug to solve.
After a few tries, we have isolated this to a kernel problem. Took a lot of time because the logs were clean: no clues, no traces... nothing.

The problem was constant lost connections to the mysql server. These caused the mysql_num_rows errors in every file that used them. I've kept my changes for the times mysql_num_rows was used to count rows. The COUNT(*) function is better.

As soon as I know anything else about this particular kernel issue, I'll post here. Maybe it would be helpfull for someone.

Anyway, my apologies and thanks to everyone that lost time with this issue but unfortunately this was beyhond my control =(

Ricardo

PS: almost forgot! PP is running on php 4.3.7 with no problem whatsoever =)

You state you have tried running a database repair. HMM how is your space on the account? Have you tried a server restart?
__________________
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 August 23rd, 2004, 10:13 PM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2004
Posts: 5
I too am getting masses of mysql_fetch_array() error messages but only when I try to do a MYSQLDump to my backup directory which because of the error it never actually does.
andy7498 is offline   Reply With Quote
Old August 24th, 2004, 08:19 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,938
Totally unrelated.

Check to see your backup directory exists and the path to mysqldump is correct
__________________
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
getting strange errors DefenceTalk.com Photopost Pro Installation & Upgrades 14 October 17th, 2005 01:56 PM
SQL errors rogerl Photopost Pro Bug Reports 3 September 13th, 2005 03:31 PM
SQL errors during initial installation sbtiti Classifieds Installation & Upgrades 11 August 25th, 2004 08:12 PM


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

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