Log in

View Full Version : Database error only with one user


Alexey?
10-10-2009, 10:11 AM
Some thing strange happen to one of my users.
I'm trying to edit her profile from admin cp and it makes a database error it even happens when she is trying to logout.


here is the error

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE user SET
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = '<font size=\"2\" color=\"#0099FF\"><b>מפקחת קטגורית אסטרטגיה וחברה בצוות פרויקטים</b></font>',
customtitle = 1,
birthday_search = '1997-05-20',
birthday = '05-20-1997',
referrerid = 0,
joindate = 1251035760,
lastactivity = 1255103280,
lastpost = 1255171620,
membergroupids = '',
displaygroupid = '5'
WHERE userid = 6596;

MySQL Error : Incorrect key file for table './namedatabase/user.MYI'; try to repair it
Error Number : 126
Request Date : Saturday, October 10th 2009 @ 01:05:50 PM
Error Date : Saturday, October 10th 2009 @ 01:05:50 PM
Script : http://www.tgt.co.il/MYPATH/user.php?do=update
Referrer : http://www.tgt.co.il/MYPATH/user.php?do=edit&u=6596
IP Address : MYIP
Username : Alexey
Classname : vB_Database
MySQL Version : 5.0.51a-community

Floris
10-10-2009, 10:42 AM
MySQL Error : Incorrect key file for table './namedatabase/user.MYI'; try to repair it
Error Number : 126

This is not a vBulletin issue, but MySQL, contact your host on how to fix MYI invalid key file, mysql error 126.

Alexey?
10-10-2009, 10:46 AM
How it is possible that it's happened only to one user in my forum?


Edit:
well i repaired the user table and it all fixed :)