Database Query Errors

[tearcharmer]

I know that there have been other threads that have been posted on this issue and this is the second time that this error has happened to me with Coppermine. From what I remember, you go into PHPmyadmin and reset some sort of code by type a single word that resets the error. I remember doing this last time. But, I don't remember exactly what I did.

This is the error I get when the gallery is in debug mode:

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

mySQL error: Got error 127 from storage engine

If anyone can help me, that'd be lovely. I appreciate it. Thank you.

[tearcharmer]

Problem solved, I believe.

[tearcharmer]

Yes, I fixed it.

(Sorry for a waste of a thread.)

[Sami]

Please write your solution for others....

[lesault]

Thanks for setting me on the right track - I was getting the same error.

To fix it, I did the following using webmin:

• Browse to the relevant database
• Click 'Execute SQL' and enter the following for each table.

Code Select Expand

CHECK TABLE tablename   eg. CHECK TABLE cpg133_albums
Many of the tables said that they had been improperly closed - this seems to be ok, ignore them.
cpg133_pictures reported that link 1508 was damaged (I forgot to take a note of the exact message, sorry)
I then did

Code Select Expand

REPAIR TABLE cpg133_pictures QUICK
This gave lots of lines of information, the last line read 'OK'
 
  The gallery was then visible again. I've taken a backup of the database and will do more regularly from now on! Thanks again for saving my gallery! 

Regards,

Lesault.