[SOLVED] Review tab...
 
Notifications
Clear all

[SOLVED] Review table crashed

2 Posts
1 Users
0 Reactions
1,228 Views
(@jacci)
Posts: 503
Honorable Member
Topic starter
 

version 3.3  (was jsut about to update when this happened)
http://www.pretendercentre.com/missingpieces/

My reveiw table has crashed and getting this error message when trying to get to author
A fatal MySQL error was encountered.
Query: SELECT COUNT(uid) FROM mpfffanfiction_reviews WHERE (uid = '132') AND review != 'No Review'
Error: (145) Table './pretende_mp/mpfffanfiction_reviews' is marked as crashed and should be repaired

If i try to read a reveiw I get this message
A fatal MySQL error was encountered.
Query: SELECT review.reviewid, review.respond, review.review, review.uid, review.reviewer, review.rating, UNIX_TIMESTAMP(review.date) as date, chapter.title as title, chapter.inorder as inorder FROM mpfffanfiction_reviews as review, mpfffanfiction_chapters as chapter WHERE chapter.sid = '52' AND chapter.chapid = review.chapid AND review.review != 'No Review' AND review.type = 'ST'ORDER BY review.reviewid DESC LIMIT 0,25
Error: (145) Table './pretende_mp/mpfffanfiction_reviews' is marked as crashed and should be repaired

If i try to leave a reveiw i get this message
A fatal MySQL error was encountered.
Query: INSERT INTO mpfffanfiction_reviews (item, type, reviewer, review, rating, date, uid, chapid) VALUES ('52', 'ST', 'jacci', 'test', '-1', now(), '8', '52')
Error: (145) Table './pretende_mp/mpfffanfiction_reviews' is marked as crashed and should be repaired

looking at the tables i am getting a report that the _reviews table is 'in use' and i cannot browse it or edit it and if i try to browse it i get the it has crashed and needs to be repaired message

i tried running a repair in mysql and all tables came up ok except for that one whcih wasnt on the list at all

mysql skills are pretty basic and i dont knwo how to deal with this. If it can't be repaired, i have backups of the entire database, is it possible to just copy the one table in, or will i have to restore the whole database?

thanks in advacne for any advice.
jacci


why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 08/10/2007 12:50 pm
(@jacci)
Posts: 503
Honorable Member
Topic starter
 

This has now been solved. I wrote to the server and they ran a repair and restored the table from their end since it couldn't be fixed from mine. Yay for good hosts that do stuff like this  πŸ˜€


why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 08/10/2007 9:45 pm
Share: