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
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