The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Incorrect key file for table usercss
Updated mysql and rebuilding database I am receiving this error message
Incorrect key file for table 'usercss' I have tried repair in admincp under maintenance (didnt work) I have tried to access and repair using phpmyadmin (wont show the table) Is there a way to repair or delete this using a query? Thanks in advance |
#2
|
|||
|
|||
You might try the mysql_upgrade command: http://dev.mysql.com/doc/refman/5.0/...l-upgrade.html (which I believe has to be done from a command line).
|
#3
|
||||
|
||||
mysql has just been upgraded thats whats caused the table error i think, 2 running sites and a test site all affected with the same error.
|
#4
|
|||
|
|||
Right. I don't know if that will fix your problem or not, but even though mysql_upgrade sounds like it would upgrade your mysql version, what it actually does (according to the docs I linked above) is "examines all tables in all databases for incompatibilities with the current version of MySQL Server." and it also says "mysql_upgrade should be executed each time you upgrade MySQL." I found out about it when I searched for that error you got and found where someone said running mysql_upgrade fixed it.
|
#5
|
||||
|
||||
Thanks for the info i did read through, its supposed to repair all databases on upgrade, but for some reason, all 3 VB4 databases have the same corrupt error all on same table, which is weird.
I can create a new DB and export and import the offending tables but on a site with 18,000 members im reluctant to just do it without making sure its not going to do any major harm, seems this covers custom profiles so wont be a biggy, was hoping maybe someone encountered tis and knew best cure. The error is also preventing a database backup as it wont go past the corrupt table. |
#6
|
|||
|
|||
see this thread
Code:
https://www.vbulletin.com/forum/showthread.php/44909-3-ways-to-repair-a-database |
#7
|
||||
|
||||
Ok fixed it.
First I created a new VB4 database (basically a new testsite) Second I exported the usercss tables Third I dropped the damaged usercss table in main database I then readded using the query below. If your tables have a prefix then change name in red. Code:
CREATE TABLE `usercss` ( `userid` int(10) unsigned NOT NULL DEFAULT '0', `selector` varchar(30) NOT NULL DEFAULT '', `property` varchar(30) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`userid`,`selector`,`property`), KEY `property` (`property`,`userid`,`value`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
Благодарность от: | ||
fechten |
#8
|
|||
|
|||
Hi, Sorry to open up an old thread but I need some help with this.
I also have the same issue with the usercss table being corrupt and not being able to backup my database. I see you have fixed it and posted the directions however I need a little more hand holding to walk me through this. Where/how do you do this? Quote:
I just checked the table status and it's create and update date/time are the same so it looks like nothing has ever been done with this table. Create: 2013-03-01 12:06:53 Update: 2013-03-01 12:06:53 Check: 2013-03-29 16:19:11 From PHPmyadmin can I just drop the corrupt usercss table or can I try to import the blank one from my test site? Thank for any help you can provide. Brian |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|