mysql error when viewing own profile page

[georgec]

Hi:
I recently upgraded mysql from 4.x to 5.1, and ever since, viewing one's own profile page no longer works and generated a database error. I'm running 4.2.0 Patch Level 3. The error returned is:

Database error in vBulletin 4.2.0: Invalid SQL: SELECT * FROM usercss WHERE userid = 54479 ORDER BY selector; MySQL Error : Incorrect key file for table 'usercss'; try to repair it Error Number : 1034 Request Date : Thursday, July 25th 2013 @ 09:50:24 AM Error Date : Thursday, July 25th 2013 @ 09:50:25 AM Script : http://www.dynamicdrive.com/forums/m...p?54479-ajfmrf Referrer : http://www.dynamicdrive.com/forums/s...earchid=586243 IP Address : 67.231.70.96 Username : ajfmrf Classname : vB_Database MySQL Version :

I've already tried running mysqlcheck directly in SSH, in which it reports several tables as corrupted and unrepairable:


ddforums.blog_trackbacklog OK
ddforums.blog_user OK
ddforums.blog_usercss
Error : Incorrect key file for table 'blog_usercss'; try to repair it
error : Corrupt
ddforums.blog_usercsscache OK
ddforums.blog_userread OK
ddforums.blog_userstats OK

ddforums.contentread OK
ddforums.contenttype OK
ddforums.cpsession
note : The storage engine for the table doesn't support repair
ddforums.cron OK
ddforums.cronlog OK
ddforums.customavatar OK
ddforums.customprofile OK
ddforums.customprofilepic OK

ddforums.searchgroup OK
ddforums.searchgroup_text OK
ddforums.searchlog OK
ddforums.session
note : The storage engine for the table doesn't support repair
ddforums.setting OK
ddforums.settinggroup OK
ddforums.sigparsed OK
ddforums.sigpic OK

ddforums.tachythreadpost OK
ddforums.tag OK
ddforums.tagcontent OK
ddforums.taggregate_temp_1223999760
note : The storage engine for the table doesn't support repair
ddforums.taggregate_temp_1328392560
note : The storage engine for the table doesn't support repair
ddforums.tagsearch OK
ddforums.template OK

ddforums.upgradelog OK
ddforums.user OK
ddforums.useractivation OK
ddforums.userban OK
ddforums.userchangelog OK
ddforums.usercss
Error : Incorrect key file for table 'usercss'; try to repair it
error : Corrupt
ddforums.usercsscache OK
ddforums.userfield OK
ddforums.usergroup OK

ddforums.usertitle OK
ddforums.visitormessage OK
ddforums.visitormessage_hash OK



I also tried restarting mysql to no avail. There is an old post by Wayne that recommends:

Try this query: truncate usercss; It will delete all the records and indexes. Your users will need to re-customize their profiles though.

in this thread: http://www.vbulletin.com/forum/forum...ss-table-issue Is that suggestion still viable in this case? Thanks,

[Hartmut]

Please try AdminCP -> Maintenance -> Repair / Optimize Tables first and run the tool, does that help?

[georgec]

Hi:
Thanks, but I've run Repair / Optimize Tables in the vBulletin CP a few times already, the results are the same as running mysqlcheck in SSH.

[Hartmut]

I would contact your web host, reporting them possible errors in the file system and asking them to check this issue if you can't repair the tables on your own.

[georgec]

Thanks, before I try that though, just wondering, is running the command:

truncate usercss

also something that may work as Wayne posted a while ago?

[BirdOPrey5]

It may work, it will definitely delete all custom css created by your users, if you're OK with that it is worth a shot.

[georgec]

For future reference, truncating usercss seems to have fixed the problem for me. Running mysqlcheck now successfully goes through, and the profile pages are accessible again on the forums.

Thanks,