Database error

[leannet]

Can anyone help me with this please

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT * FROM user FORCE INDEX (lastactivity)
WHERE lastactivity > 1256562000 ORDER BY username;

MySQL Error : Incorrect key file for table './xxxxxxxxxxxxx/user.MYI'; try to repair it
Error Number : 126
Request Date : Tuesday, October 27th 2009 @ 12:39:16 AM
Error Date : Tuesday, October 27th 2009 @ 12:39:17 AM
Script : http://www.xxxxxxxxxxxxxx.com/
Referrer :
IP Address : xxxxxxxx
Username : xxxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.0.85-community-log

[WEBDosser]

Try running a repair:

Admin CP -> Maintenance -> Repair / Optimize Tables

Run it twice to make sure it comes back clean the second time.

[leannet]

I can't log into admin cp I keep getting error aswell :(

Do you know or how this could have happened ?

[WEBDosser]

try to disable the hook system and then enter admincp..

you need to edit includes/config.php and add the following code: define('DISABLE_HOOKS', true);

then delete the line when done

[snakes1100]

If the "user" table is crashed as the msg states, the you will not be able to login from the admincp or the forum pages wether the hook system is disabled or not.

You will need to run a repair with either myisamchk via the cmd line in ssh or use phpmyadmin which comes with most panels like cpanel, plesk etc.

[leannet]

Thanks for the reply snakes I am not familiar with phpmyadmin but I will see what I can do.

--------------- Added 1256628638 at 1256628638 ---------------

is phpmyadmin the same thing as smart ftp client, sorry to be a pita

[DeanLag]

No, PhpMyAdmin is a software to handle the administration of MySQL (textbook definition =p) and FTP client is just to transfer file from your computer to your webhost, or vice versa.

Did you try disabling the plugin system and see if you can go into ACP?
How did your error happen? Did you install a new Mod then you got the error? or it just happened out of the blue?

[leannet]

It just happened out of the blue

how do I disable the plug in system ?

--------------- Added 1256632191 at 1256632191 ---------------

i've downloaded phpmyadmin but I can't get it to work I must have done something wrong.

--------------- Added 1256632289 at 1256632289 ---------------

I downloaded this one
phpMyAdmin-3.2.2.1-english.7z 1.5 MiB is it correct?

[DeanLag]

If you have cPanel or Plesk, it usually comes with PhpMyAdmin.

To disable the plugin system

you need to edit includes/config.php and add the following code: define('DISABLE_HOOKS', true);

[snakes1100]

leannet posted in his first post that the "USER" table is crashed with a incorrect key, what is disabling the plugin system going to do?


@leannet
You should do a little searching over at vbulletin com for incorrect key as there are a few answers there as well as google that might shed some light on why the sudden crash, it can even be caused by mis-matched character collations on your table.

[leannet]

Thanks for all the replies I am not sure what was wrong but it seems to have corrected itself.

[snakes1100]

Depending on OS installed on the server, some are setup to check DB's for crashed tables on restart of sql, ie Ubuntu