I woke up today, and tried to access my galleries, I have two of them. Big galleries with years of work in them, and I get this,"There was an error while processing a database query "
I checked the database's and they look intact and fine. No other database's on my site have become corrupted. I run a store and a forum also. Any clues? Nothing was changed, or anything, it just seems to have died for no reason.
Thanks
Ok, I read some previous posts and I enabled debug mode and get this:
While executing query "SELECT * FROM cpg135_cms WHERE conid='0' AND type='0' ORDER BY cpos" on 0
mySQL error: Table './chimera/cpg135_cms' is marked as crashed and should be repaired
am I dead? :(
Ok, I read that I have to do a repair table in mysql..I read some of the articles, but can't make much sense of it. I don't see any repair button in the database, it's a mysql command? Anyone feel like walking me through this?
Go into phpmyadmin, navigate to the Coppermine database, click on the SQL tab and enter
REPAIR TABLE cpg135_cms
It worked it work! Thank you so much! I thought I was totally in trouble.
Phew!
Time to backup everything.<lol>
uh oh, maybe it didn't? There might be a problem with the two databases..?
I try to log into the other database and I get the first one!? :(
oop, nope, they're both ok, just had to repair that one ;) <beam>
Thanks again.