View Full Version : Help! We're sorry, but the system experienced an unrecoverable error. Please try agai
March 29th, 2008, 08:37 AM
I'm getting this error:
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: SELECT COUNT(*), SUM(views) AS fsize FROM photos
Result: Table 'photos' is marked as crashed and should be repaired
Database handle: Resource id #6
How do I repair the photos table? Note - the resource ID has varied between #6 and #7 if that makes a difference.
March 29th, 2008, 09:05 AM
Ignore this. I think I posted in the wrong forum. I'll post in the discussion forum.
March 29th, 2008, 09:29 AM
Your photos table is crashed and you need to repair it. Using your webhost control panel database viewer which is normally phpmyadmin run this command.
REPAIR TABLE photos;
January 3rd, 2009, 12:10 PM
I am experiencing this exact problem.
My photopost is in my forums database along with my classifieds. The photopost prefix is "pp_".
I backed up my database and tried running several queries similar to the one suggested and eventually managed to get it to run with REPAIR TABLE forums;".
Unfortunately it gave me an error too.
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
January 3rd, 2009, 01:17 PM
REPAIR TABLE pp_photos;
That should do it. ;)
January 3rd, 2009, 01:41 PM
Thank you very much! That did it!:)
January 3rd, 2009, 01:57 PM
Not a problem you always need to place the correct table name to fix the table. glad to assist.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.