Print Page - Database error

Title: Database error
Post by: tibski on November 24, 2007, 05:37:17 AM

My site displays this message:

Critical error
There was an error while processing a database query.

And my database shows:

Error

SQL query: Edit

SHOW CREATE TABLE `testcopper`.`cpglsapictures`

#145 - Table './testcopper/cpglsapictures' is marked as crashed and should be repaired

Can anyone please help me out.

Thanks much

Title: Re: Database error
Post by: Aditya Mooley on November 24, 2007, 05:50:58 AM

The error is not because of Coppermine. Your database error message suggests that the table has been crashed. Repair it with PHPMyAdmin. If you don't know how to do that contact your webhost.

Title: Re: Database error
Post by: tibski on November 24, 2007, 07:58:36 AM

Thanks Aditya. I will try fixing it.

Title: Re: Database error
Post by: tibski on November 27, 2007, 01:05:29 PM

Quote from: Aditya Mooley on November 24, 2007, 05:50:58 AM
The error is not because of Coppermine. Your database error message suggests that the table has been crashed. Repair it with PHPMyAdmin. If you don't know how to do that contact your webhost.

Hi Aditya, can you please help me out on how to repair the table that has crashed? It seems that my hosting wont fix the problem.

Thanks in advance!

Title: Re: Database error
Post by: Nibbler on November 27, 2007, 01:27:25 PM

Go into phpMyAdmin, click on the SQL tab and enter the code

Code Select

REPAIR TABLE `testcopper`.`cpglsapictures`

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tibski on November 24, 2007, 05:37:17 AM