PDA

View Full Version : DB error when delete user


ales2cv
07-15-2011, 07:28 AM
When in administration choise user and go deletit first get confirm then after delete get that error.

Database error in vBulletin 4.1.4:

Invalid SQL:

DELETE FROM vb_blog_usercss
WHERE userid = 5590;

MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it
Error Number : 1034
Request Date : Friday, July 15th 2011 @ 03:28:23 AM
Error Date : Friday, July 15th 2011 @ 03:28:23 AM
Script : http://www.cxxcom/forum/admincp/user.php?do=kill
Referrer : http://www.cxx.com/forum/admincp/user.php?do=remove&u=5590
IP Address : 88.200.92.236
Username : 2cv
Classname : vB_Database
MySQL Version : 5.1.56


How could i fix that

y2ksw
07-15-2011, 08:21 AM
MySQL Error : Incorrect key file for table 'vb_blog_usercss'; try to repair it :)

ales2cv
07-15-2011, 05:25 PM
Yes i try to do that, but i am not mysql guru. The problem i guess start after i upgrade on server mysql on version 5. I dont find any good instrction how is posibel to repair some record in tabel that now not work after upgrade. I run repair chek and otimize over mysql admin and situatin is the same. Alsoo repair from vbulletin menu run uniq index and situatin is same. Any sugest were i find solution for that problem.

y2ksw
07-16-2011, 08:00 PM
Ok if the standard repair doesn't work, you will have to ask your hosting provider to do it. There are some situations where the indexes are to be rebuilt. Like a full server crash.

ales2cv
10-08-2011, 10:16 PM
no way to repair that two record
so my forum and portal must live with out that vb_blog_usercss
nad blog_usercss ---
But i stil think if some one could drop me that record i coud repier it and live it blank and at last dont ahve errro whem do base optimasition so if some oen could dorp and send me sql record for all _usercss tabel i be wery happy