Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: locodaddyman - marraskuu 17, 2008, 08:15:50 IP

Otsikko: Incorrect key file for table
Kirjoitti: locodaddyman - marraskuu 17, 2008, 08:15:50 IP
Database Error: Incorrect key file for table './musichei_vb/smf_log_online.MYI'; try to repair it
File: /home4/musichei/public_html/smf/Sources/Subs.php
Line: 3767
Otsikko: Re: Incorrect key file for table
Kirjoitti: ThorstenE - marraskuu 19, 2008, 02:23:08 IP
It's a host related issue .. the database is crashed and the table smf_log_online is now destroyed. try this with phpMyAdmin:

REPAIR TABLE smf_log_online;
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
Otsikko: Re: Incorrect key file for table
Kirjoitti: Xavi-Nena - marraskuu 21, 2008, 03:17:39 AP
I am having this same problem, how do I repair? I am in myphpadmin and have located the table....sorry im learning.

thanks
Otsikko: Re: Incorrect key file for table
Kirjoitti: ThorstenE - marraskuu 21, 2008, 03:22:37 AP
Look at the attached Screenhost..
Otsikko: Re: Incorrect key file for table
Kirjoitti: Xavi-Nena - marraskuu 21, 2008, 03:56:21 AP
awesome thank you i tried it and it worked...well i can at least see the board now.

however it also mentioned something about a php upgrade to the database being outdated...i have no clue what that means and right now i cannot access the admin controls and it tells me this when i try to log into admin:
Session verification failed. Please try logging out and back in again, and then try again.


and this when i try to post replies :
Your session timed out while posting. Please try to re-submit your message.

and no avatars are showing up..... my board has fallen apart!  :'(
Otsikko: Re: Incorrect key file for table
Kirjoitti: ThorstenE - marraskuu 21, 2008, 05:27:58 AP
try the "repair table" for ALL smf_tables..
Otsikko: Re: Incorrect key file for table
Kirjoitti: Xavi-Nena - marraskuu 21, 2008, 05:31:00 AP
haha you are genius! i can log into admin now..

however I still do not see any avatars?
Otsikko: Re: Incorrect key file for table
Kirjoitti: H - joulukuu 13, 2008, 05:01:12 IP
Hi NenaGB, do you still require assistance with this? :)
Otsikko: Re: Incorrect key file for table
Kirjoitti: Xavi-Nena - joulukuu 13, 2008, 07:47:23 IP
No sir thank you the issue was due to a hacker and repairing tables and having another member assist me with some clean up i am good.

but thank you for checking. :)
Otsikko: Re: Incorrect key file for table
Kirjoitti: H - joulukuu 14, 2008, 08:30:58 AP
Glad you got it solved :D