PhotoPost Database Problem

Jennifer Marx · November 9th, 2009, 11:54 AM

We upgraded our PhotoPost installation last week, but it revealed errors with our PhotoPost database that I believe must have existed from before the upgrade. Namely, when I try to view some photos, I get "we're sorry, but the system experienced an unrecoverable error." For example:
PassPorter Photos - Message

When I look closely at our database, one of the tables (pp_extrafields) appears to be damaged -- I cannot view its contents. My web host looked at it and says "The table only has one file (out of 3) created." All I can think to do is ask my host to recreate the table, but I would need to give them the query to use.

Do you think recreating the table would help, and if so, what would the query for pp_extrafields be?

Thank you in advance!

Chuck S · November 9th, 2009, 01:35 PM

Hello

Have you or your host tried a repair on that table?

REPAIR TABLE pp_extrafields;

Jennifer Marx · November 9th, 2009, 04:50 PM

I asked my host about a repair and this is what they say:

"Unfortunately a repair will not work. Their is only one file out of 3, so it will fail. We would need to delete the table file and then you would need to recreate the table. Do you give us permission to proceed."

Does this sound right? How would I recreate the table?

Chuck S · November 9th, 2009, 04:57 PM

You can delete and recreate the table with this

Code:

Content visible to verified customers only.

Jennifer Marx · November 10th, 2009, 08:26 AM

Thank you! We used that to recreate the table. Now I get this error:

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

Script:

Query: SELECT e.id,e.fieldname,e.fieldtype,e.fieldoptions,p.selection FROM pp_extrafields e LEFT JOIN pp_photoextras p ON (p.extraid=e.id AND p.photo=15967) WHERE e.cat=590

Result: Table 'passporterphotos.pp_photoextras' doesn't exist

Database handle: Resource id #6"

Can I have the directions to recreate the pp_photoextras table too?

Chuck S · November 10th, 2009, 09:29 AM

Same thing does that table exist or is corrupt?

have you ran your upgrade script? You really need to find out why your server hosting environment is corrupting all your tables and stop it.

Code:

Content visible to verified customers only.

Jennifer Marx · November 10th, 2009, 09:35 AM

Thanks. As for running the upgrade script, I'm not sure what you mean -- sorry. You did the upgrade for us last week. Is there something else I was supposed to do?

My host is trying to figure out what happened -- they asked me to ask you if you made any changes to the database when you did the upgrade.

Chuck S · November 10th, 2009, 09:40 AM

Nope I know the upgrade script was ran if we did it. Your site appeared fine last week knew I recognized the name somehow. So basically what we have here is several mysql tables have crashed in a week or so so your host might need to check if mysql is working correctly because multiple mysql tables just dont crash. One here or there yes that is known to happen.