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

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old January 23rd, 2012, 04:05 PM   #1 (permalink)
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 387
Exclamation Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given ERROR

Hi,

For past few days I am getting this error:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/USER/public_html/pictures/showphoto.php on line 1614

On SHOWPHOTO Pages only. NOTHING changed as far as photopost is concerned, or showphoto.php file or its line 1614.

Only thing that happened was that "USER" ran out of available disk space (quota reached) and saw that error after the issue with "USER" was fixed.

Whats happening here?

I sent email about it (AFTER paying for renewal, expected a reply back at least) over the weekend but i guess no body replies to those anymore...

Anyway, if i can get some help with this error please that would be great!
DefenceTalk.com is offline   Reply With Quote
Old January 23rd, 2012, 04:23 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
We have no open helpdesk tickets so either your email was not received or we commented and you did not see a reply.

I do not specifically remember your site but there is no query at line 1614 of showphoto.php so your using an older modified version of the software from what I am seeing.

If you set the debug value to display errors in global options in admin and view that page as admin what is the error?
__________________
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 January 23rd, 2012, 04:56 PM   #3 (permalink)
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 387
This is the error:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT userid,date,photo FROM pics_ipcache WHERE ipaddr='IP_address' AND type='view' AND photo=46845 LIMIT 1

Result: Table './database_name/pics_ipcache' is marked as crashed and should be repaired

Database handle: Resource id #31
DefenceTalk.com is offline   Reply With Quote
Old January 23rd, 2012, 05:08 PM   #4 (permalink)
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 387
Never mind. Fixed it by repairing the table ipcache through phpmyadmin...

Cost me $39.00!!!!!!!!!!!!!!!!!
DefenceTalk.com is offline   Reply With Quote
Old January 23rd, 2012, 05:24 PM   #5 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
Yes a crashed table needs to be repaired. For future reference you know that if you have a mysql issue like that with the debug option on and logged in as admin you should be able to see the real error.

As noted yes you would need to renew your members access to post for product support based off your license agreement. A license comes with one year code updates and product support.

Your version has to be fairly older it looks like you will eventually need to update and should look at PP8.
__________________
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 January 23rd, 2012, 05:29 PM   #6 (permalink)
Member
Verified Customer
 
Join Date: Feb 2005
Posts: 387
I am using 7.02... I've done a lot of template changes, customization, etc. so i will need next Christmas holiday to make the switch over.

Thanks Chuck!
DefenceTalk.com is offline   Reply With Quote
Old January 23rd, 2012, 06:21 PM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,689
Hear I hear ya. I am just saying you might want to try it. Alot of customers are liking the changes.
__________________
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
mysql_num_rows(): supplied argument is not a valid DefenceTalk.com Photopost Pro Bug Reports 11 July 27th, 2010 06:33 PM
6.1 Upgrade - Error mysql_num_rows(): lucybb Photopost Pro Installation & Upgrades 3 June 30th, 2008 09:32 AM
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in sinjix Photopost Pro Bug Reports 5 July 26th, 2007 09:39 PM
Member Galleries - Warning: mysql_num_rows JoeWho Photopost Pro Installation & Upgrades 4 February 2nd, 2007 10:08 AM
MySQL error - Database handle: Resource id #8 Andy R Photopost Pro Installation & Upgrades 2 July 21st, 2004 03:51 PM


All times are GMT -5. The time now is 04:59 AM.

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