Photopost error 145 table corrupt

mitchjaz2 · March 2nd, 2006, 10:16 AM

Overnight my Photopost gallery died (white page). After investigating a bit it looks like my pp_cache is corrupted. mysql generates this:

SQL query: Edit

SHOW KEYS FROM `pp_cache` ;

MySQL said: Documentation
#1016 - Can't open file: 'pp_cache.MYI' (errno: 145)

Can anyone help with a query to repair the table? Thanks.

Chuck S · March 2nd, 2006, 10:41 AM

REPAIR TABLE pp_cache

mitchjaz2 · March 2nd, 2006, 10:50 AM

Thanks. Now my Photopost index is messed up. www.dphoto.us/forumphotos. A warning now shows up in mysql:

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 Edit Drop id
id INDEX None Edit Drop id
Warning PRIMARY and INDEX keys should not both be set for column `id`
Create an index on columns

Thanks for your help.

Chuck S · March 2nd, 2006, 11:03 AM

You need to repopulate the cache table. Turn off the cachetimeout in admin and then view your index. You can then go turn it back on.

mitchjaz2 · March 2nd, 2006, 11:13 AM

I turned off the cache timeout, with the same result. Also, I just noticed this error at the top of the page: Warning: Invalid argument supplied for foreach() in photos/pp-inc.php on line 2891

mitchjaz2 · March 2nd, 2006, 11:53 AM

Apologies if another thread should be started, but it's all related I believe. If I go to upload photos, no options show in the category dropdown box to upload photos. Options do appear in the album drop down box. The following mysql warning appears at the top of the upload page:

Warning: Invalid argument supplied for foreach() in photos/pp-inc.php on line 2891

Nothing has been changed on the server...this all has just happened overnight.

Chuck S · March 2nd, 2006, 12:00 PM

Turn off your cache in Global Options and see what happens.

mitchjaz2 · March 2nd, 2006, 12:07 PM

I did that earlier. Same result.

mitchjaz2 · March 2nd, 2006, 12:56 PM

BTW, in the error message it looks like it's looking for pp-inc in "photos" directory, and photopost in in forumphotos directory.

Chuck S · March 2nd, 2006, 02:06 PM

What is your pp_path set to in config-inc.php?

Verify you have properly repaired the cache table.

By the way what version of Photopost you running cause line 2891 has nothing to do with a query in 5.3

Code:

Content visible to verified customers only.