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:
in this thread: http://www.vbulletin.com/forum/forum...ss-table-issue Is that suggestion still viable in this case? Thanks,
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.
Comment