forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: unbeliever on November 05, 2005, 12:57:20 pm

Title: There was an error while processing a database query.
Post by: unbeliever on November 05, 2005, 12:57:20 pm

While executing query "SELECT sum(hits) FROM copper_pictures as p LEFT JOIN copper_albums as a ON p.aid=a.aid WHERE 1" on 0

mySQL error: Got error 127 from table handler


what should i do ?!?
i just uploaded some pics, suddenly this message appeared !!

DEBUG-INFO.txt (http://floseim.fl.funpic.de/debug-info.txt)

thx

Title: Re: There was an error while processing a database query.
Post by: Nibbler on November 05, 2005, 01:29:07 pm

Repair the table using phpmyadmin

Title: Re: There was an error while processing a database query.
Post by: unbeliever on November 05, 2005, 01:34:01 pm

and how ?

Title: Re: There was an error while processing a database query.
Post by: kegobeer on November 05, 2005, 02:06:48 pm

Use your website's Control Panel to repair the tables, or use phpMyAdmin to execute these sql queries:

repair table copper_pictures
repair table copper_albums

Title: Re: There was an error while processing a database query.
Post by: unbeliever on November 05, 2005, 02:11:15 pm

thx a lot.  ;D