Getting Database Error

[goaskanna2]

Please help me? I've searched and searched and I can't find a fix. I'm having pretty much the same problem as the original poster had, only difference is there's a different line number quoted.

After all my searching I found how to upgrade.php via phpmyadmin (although I was already upgraded to 1.1. and after tons more searching I found how to do a repair table.

Thing is, my table isn't being repaired!! After I click repair, I get a page with 3 lines, first line says table is marked as crashed and should be repaired, 2nd line says the same, then 3rd line says Table is already up to date   

I desperately need help getting my forum back online a.s.a.p. (p.s. I'm extremely blonde with techie stuff!)

Thanks

Anna

[Aleksi "Lex" Kilpinen]

Hi Anna

It would've been better for you to start a topic of your own,
but could you copy / paste the exact error you were getting?

EDIT: Split the topic, just to make this clearer for everyone

[goaskanna2]

Yeah, sorry, but I've always been told here to search through and possibly find related topics first 

Ok, this is the exact error I'm getting now:

Database Error
Table './adorsco_smf1/smf_log_online' is marked as crashed and should be repaired
File: /home/adorsco/public_html/forum/Sources/Subs.php
Line: 3095

Any ideas?

Thanks

[Aleksi "Lex" Kilpinen]

Yeah, sorry, but I've always been told here to search through and possibly find related topics first 

Yup, and it was a good thing you did 
But when it didn't solve your problem - it's best to make a topic of your own

Ok, this is the exact error I'm getting now:

Database Error
Table './adorsco_smf1/smf_log_online' is marked as crashed and should be repaired
File: /home/adorsco/public_html/forum/Sources/Subs.php
Line: 3095

Any ideas?

Thanks

Since I understood you already tried to REPAIR the table,

Code Select Expand


REPAIR TABLE smf_log_online;


now try to empty it

Code Select Expand


TRUNCATE TABLE smf_log_online


See if that helps

[goaskanna2]

OMG!!! Thank you so much!! It fixed it right up!!

You're a star I have no idea what might have caused it to suddenly crash, but your help fixed it straight away

Anna

[Aleksi "Lex" Kilpinen]

I'm glad you got it sorted that easily