hi,
i checked my email and noticed that i had a lot of people complaining that my gallery was down, so i went to my site and all that loads up is...
Fatal error :
my url is www.didireallydothat.com
any help would be VERY VERY much appriciated as i really need to get this back online
thanks in advance
PS: i have searched but could only find topics which didnt have the same exact problem.
http://coppermine-gallery.net/tutorial/debug_mode.php
hi,
thnks for that, should i post up here what its says in the debut window? as i dont understand what it means!
thanks again
Yeah.
While executing query "delete from `didireal_copr`.cpg148_sessions where time<1154343346 and remember=0;" on Resource id #5
mySQL error: Table './didireal_copr/cpg148_sessions' is marked as crashed and should be repaired
thanks again
Repair the table using phpmyadmin or seek support from your webhost.
http://forum.coppermine-gallery.net/index.php?topic=10409.0
that is absolutly BRILLIANT :) thank you so so so much....
should i send an email to my webhost about this? and if so what should i say, cuz i dont want this to be happening over and over again so id just like to know what the fault was?
thanks again
your a star!
Google is your friend ,Here is some info about crashing mysql table:
Fixed in 4.0.18
*INSERT DELAYED ... SELECT ... could cause table corruption because tables were not locked properly. This is now fixed by ignoring DELAYED in this context. (Bug #1983)
Fixed in 4.0.16
*Fixed bug in overrun check for BLOB values with compressed tables. This was a bug introduced in 4.0.14. It caused MySQL to regard some correct tables containing BLOB values as corrupted. (Bug #770, Bug #1304, and maybe Bug #1295)
Fixed in 4.0.15
*Fixed rare bug in MYISAM introduced in 4.0.3 where the index file header was not updated directly after an UPDATE of split dynamic rows. The symptom was that the table had a corrupted delete-link if mysqld was shut down or the table was checked directly after the update.
Fixed in 4.0.14
*Comparison/sorting for latin1_de character set was rewritten. The old algorithm could not handle cases like "sä" < "ßa". See section 5.6.1.1 German character set. In rare cases, it resulted in table corruption.
@bmossavari: I'm afraid you're asking a bit too much from cofitanner - he/she doesn't seem to be that advanced.
@cofitanner: send them an email, give them a call, use their contact form, ring their doorbell. We can't tell you what method of contact you or your webhost prefer. Just tell them the error message
QuotemySQL error: Table './didireal_copr/cpg148_sessions' is marked as crashed and should be repaired
and ask them to fix it.