Incorrect key file for table... Help please

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Socialoutcast
Registered User
Posts: 61
Joined: Fri Oct 20, 2006 2:43 am
Location: Scotland

Incorrect key file for table... Help please

Post by Socialoutcast » Wed Aug 13, 2008 1:30 pm

My forum is showing this message:
General Error
SQL ERROR [ mysqli ]

Incorrect key file for table './...forum/phpbb_sessions.MYI'; try to repair it [126]

SQL

UPDATE phpbb_sessions SET session_viewonline = 0 WHERE session_user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/session.php
LINE: 1752
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 26
CALL: user->setup()

I've gone into phpmyadmin but I can't find phpbb_sessions.MYI' so I can't repair it and I've no idea what I'm meant to do to update phpBB_sessions? Any help would be appreciated :D

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7662
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Incorrect key file for table... Help please

Post by JimA » Wed Aug 13, 2008 1:38 pm

Try to run this query at your database:

Code: Select all

REPAIR TABLE phpbb_sessions;
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50869
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Incorrect key file for table... Help please

Post by stevemaury » Wed Aug 13, 2008 1:42 pm

And if JimA's solution doesn't work, try:

Code: Select all

REPAIR TABLE phpbb_sessions USE_FRM
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
Socialoutcast
Registered User
Posts: 61
Joined: Fri Oct 20, 2006 2:43 am
Location: Scotland

Re: Incorrect key file for table... Help please

Post by Socialoutcast » Wed Aug 13, 2008 3:12 pm

OK I'm nut sure if I'm doing this right but I tried running both of those and got this message
import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50869
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Incorrect key file for table... Help please

Post by stevemaury » Wed Aug 13, 2008 3:13 pm

Exactly how did you run this code?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
Socialoutcast
Registered User
Posts: 61
Joined: Fri Oct 20, 2006 2:43 am
Location: Scotland

Re: Incorrect key file for table... Help please

Post by Socialoutcast » Wed Aug 13, 2008 4:07 pm

I used the query window on phpmyadmin and copied and pasted the text written in the code boxes in the previous posts to do this. Was that wrong? I've very limited knowledge of how phpmyadmin works

Earlier I tried to repair phpBB_sessions earlier by ticking the box next to it and selecting the repair option from the drop down menu but that didn't work either so I figured I'd try the query window :oops:

User avatar
Socialoutcast
Registered User
Posts: 61
Joined: Fri Oct 20, 2006 2:43 am
Location: Scotland

Re: Incorrect key file for table... Help please

Post by Socialoutcast » Wed Aug 13, 2008 5:13 pm

I finally figured it out after a little head scratching. Thanks for your help stevemaury and JimA :D

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50869
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Incorrect key file for table... Help please

Post by stevemaury » Wed Aug 13, 2008 5:19 pm

Want to share?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Locked

Return to “[3.0.x] Support Forum”