Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given ERROR

[DefenceTalk.com]

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!

[Chuck S]

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?

[DefenceTalk.com]

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]

Never mind. Fixed it by repairing the table ipcache through phpmyadmin...

Cost me $39.00!!!!!!!!!!!!!!!!!

[Chuck S]

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.

[DefenceTalk.com]

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!

[Chuck S]

Hear I hear ya. I am just saying you might want to try it. Alot of customers are liking the changes.