Do I need to upgrade?

[flyaddict]

I came home this week to find a few errors. I am running 6.1 still and I have made no changes at all. Must I upgrade to make this go away?

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/gallery/adm-misc.php on line 1117

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/gallery/pp-inc.php on line 1289

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/gallery/inc_photopost.php on line 128

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/gallery/inc_photopost.php on line 143

[Chuck S]

where is this error at? I mean inc_photopost.php is an old modification file and never called directly in our program so not sure why you would be recieving that error in conjunction with all those others.

[Chuck S]

have you checked your database to make sure everything is there and nothing has crashed?

[flyaddict]

That is showing on my VB home page.

I turned off the plug-in on my VB page and the error is gone.

The others remain on my photopost page

[Chuck S]

Can you tell me what those lines are in those respective files? We dont have 6.1 lieing around so that I can see what those lines are.

I would suspect though if I had to venture a guess one of your mysql tables is crashed and needs to be repaired in mysql like I posted above.

[flyaddict]

pp-inc.php line 1289

while ( $category = mysql_fetch_row($boards) )

pp-inc.php line 5058

list( $cache['stats']['posttotal'] ) = mysql_fetch_row($totalv);


This is 2 lines anyway.



when I enter the admin panel I get this one.

adm-misc.php on line 1117

list( $posttotal ) = mysql_fetch_row($totalc);

No idea what happened. I never touched anything.

[Chuck S]

well maybe possibly based on those errors your categories table is crashed in mysql? Can you use phpmyadmin to check?

REPAIR TABLE pp_categories;

[flyaddict]

Ran a query and it says status OK. Doesn't seem to do anything.

How do I know if it has crashed? Thanks for your help by the way.

[Chuck S]

If your using phpmyadmin you should see if any tables are crashed.

You can repair all tables also.

[flyaddict]

I repaired all and nothing changed.

[Chuck S]

If you set the debug option to 2 in the pp_settings table and view your photopost what error is displayed?

This is what we really need to know is the real error.

[flyaddict]

Am I supposed to change settings from 0 to 2 or optionorder from 27 to 2?

you just said option. This is table 174?


If it was the first one this came up.

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

Script:

Query: SELECT c.id, c.description, c.catorder, c.photos, c.posts, c.catdepth, p.id, p.bigimage, p.cat, p.approved, p.user, p.userid, p.date, p.width, p.height, p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.width, p2.height, com.username, com.id, com.date, com.photo FROM pp_categories c LEFT JOIN pp_photos p ON c.lastphoto=p.id LEFT JOIN pp_photos p2 ON c.thumbnail=p2.id LEFT JOIN pp_comments com ON com.id=c.lastpost ORDER BY c.catorder ASC

Result: Table 'XXXXX_XX.pp_comments' doesn't exist

Database handle: Resource id #22

[Chuck S]

Okay well there is most definately your first step to your issue.

Your comments table is either corrupt or just plain missing. Do you have your 6.1 download code just try simply doing an install into the same database and table prefix photopost is already installed in and see if this gets your running.

[flyaddict]

Thanks so much Chuck! You rock!

That was it. I looked in my database and the comments table just got up and vanished. How does that happen? Anyway. All square now. I got my renewal also... Thx so much.

[Chuck S]

glad to assist happy new year