[Forum] usercss table crashed, how to delete/recreate?

[djsteve007]

I am anxious to upgrade to the 4.x branch, but during the backup process (of my 3.x) - I am getting database errors. Tried repairing in several different ways, including my host attempting - but it fails.

I read here ( https://www.vbulletin.com/forum/show...hlight=usercss ) that there is a way to delete and re-create this table, which I assume should be done before upgrading to 4.x - question is, how do I do this?

Steve

[Hartmut]

Which version of vB 3. do you actually run?

[djsteve007]

3.8.7 patch level 3

[Hartmut]

Only do this if you are 100% sure that the table can not get repaired !!!

When deleting usercss it'll be a minor loss of data if you allow users to customize their profiles, go into your phpMyAdmin and delete the table usercss, afterwards create a new one with this query:

CREATE TABLE usercss (
 userid INT 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))
); 

In case you use a table prefix you would have to ad this in front of the table name.

This could help to fix your issue. Make sure you have made a backup of the rest of the tables before doing this.