MyBB Community Forums

Hello mybb!


I am searching Google and err I couldn't find an answer sadly.


Anyway I am having problems with SQL.

Here is the error;

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1034 - Incorrect key file for table 'mybb_users'; try to repair it
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
Please contact the MyBB Group for support.

Server Statics:
8GB RAM
75gB Disk space left.

Manual Repair error;

Table	Op	Msg_type	Msg_text
elitesengineerin.mybb_users	repair	Error	Incorrect key file for table 'mybb_users'; try to repair it
elitesengineerin.mybb_users	repair	error	Corrupt

I am not sure why it does that worked before.

Note;Host wont do anything since I am using a SELF MANAGED server.


Thanks for your time and help

mm the error is in the table mybb_users in the mysql i think there is a corruption code

Which version of mysql are you using? One thing that can help is to rename the key file (.myi I believe?) then try repairing it.

(2012-07-28, 09:22 AM)euantor Wrote: [ -> ]Which version of mysql are you using? One thing that can help is to rename the key file (.myi I believe?) then try repairing it.

Its fixed now but now lots of SQL tables are missing lol

try to rihost if you have the file the mybb_users table

(2012-07-28, 09:42 AM)propilot Wrote: [ -> ]

(2012-07-28, 09:22 AM)euantor Wrote: [ -> ]Which version of mysql are you using? One thing that can help is to rename the key file (.myi I believe?) then try repairing it.

Its fixed now but now lots of SQL tables are missing lol

Not so good. Have you got a recent-ish backup at all?

(2012-07-28, 09:44 AM)euantor Wrote: [ -> ]

(2012-07-28, 09:42 AM)propilot Wrote: [ -> ]

(2012-07-28, 09:22 AM)euantor Wrote: [ -> ]Which version of mysql are you using? One thing that can help is to rename the key file (.myi I believe?) then try repairing it.

Its fixed now but now lots of SQL tables are missing lol

Not so good. Have you got a recent-ish backup at all?

abit old but it kept giving me errors, so I tried deleting the DB fully and remaking it. And it worked! . I lost few members but eh at least the forum is functional.

Thanks for your time and help! Have a great day "