coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Master D on March 18, 2006, 03:58:27 AM

Title: database query
Post by: Master D on March 18, 2006, 03:58:27 AM
I don't know what to do to fix this problem.

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

I turned on Debug mode:
While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg143_albums AS a  LEFT JOIN cpg143_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (11)GROUP BY a.aid" on 0

mySQL error: Got error 127 from table handler


Please help!  Any help is greatly appreciated.

Thank you!    :)
Title: Re: database query
Post by: Joachim Müller on March 18, 2006, 07:08:08 AM
In the future, please search (http://forum.coppermine-gallery.net/index.php?action=search2;search=mySQL%20error%20Got%20error%20127%20from%20table%20handler) for your error message first (has been reported before). The error message means that your database got corrupted. Fix it running mysql's repair command from a console or in phpMyAdmin.