Usercss table issue.

[korny30]

I have recently updated mysql and php and before the update, the usercss table was doing fine. Now, all the forums I have on this server that were 3.7.x + are saying the usercss is corrupt. I had an older version vb (3.6.8) and just updated it to 3.8.3 yesterday and the usercss is running fine. What caused this issue with usercss on all my forums? I tried to repair the table through phpMYadmin and it wouldn't allow me to saying it was corrupt.

Here is the db error I get when going to the Customize Profile in the usercp (this is the only place the db is occuring)

Database error in vBulletin 3.7.3:
Invalid SQL:
   SELECT * FROM usercss
   WHERE userid = 12165
   ORDER BY selector;
MySQL Error   : Incorrect key file for table 'usercss'; try to repair it
Error Number  : 1034
Request Date  : Wednesday, July 29th 2009 @ 07:21:16 PM
Error Date    : Wednesday, July 29th 2009 @ 07:21:16 PM
Script        : [URL]http://www.gmfullsize.com/forum/profile.php?do=customize[/URL]
Referrer      : [URL]http://www.gmfullsize.com/forum/usercp.php[/URL]

This vb version is of course 3.7.3, but my 3.8.2 versions are having the same issue. How can I fix this without losing data on the usercss table? Will updating to the lastest version of vb fix this?

[Steve Machol]

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.

[korny30]

Thanks Steve for the reply. I have allready done all that you listed besides the link and it comes up:

Error: Incorrect key file for table
Error: Corrupt

I already tried it in phpMYadmin and my host tried too and was unable to repair it.

If its unrepairable, how can I go about getting a new usercss table installed or am I pretty much stuck with this unrepairable table?

[Steve Machol]

Try this:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Fix Unique Indexes

Also your db error shows version 3.7.3, not 3.8.3. This means you did not upgrade correctly. First reupload all the 3.8.3 non-image files. Make sure you upload these in ASCII format, overwrite the ones on the server, and that version 3.8.3 shows in the upper right-hand corner of the page. Then run 'upgrade.php' again.

[korny30]

It has happened to another forum of mine that is a 3.8.3 version already that was this verison before the mysql and php upgrade. The "Fix Unique Indexes" did not fix the usercss problem.

[Steve Machol]

Did you try it in this case?

[korny30]

I have tried "fix Unique Indexes" on both forums, 3.7.3 and 3.8.3, and both are still corrupt and not working.

[Wayne Luke]

Try this query:

truncate usercss;

It will delete all the records and indexes. Your users will need to re-customize their profiles though.

[korny30]

That did it. Thanks!

[Al Gregory]

Thanks this fixed my same exact problem