Announcement

Collapse
No announcement yet.

mysql error when viewing own profile page

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error when viewing own profile page

    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,
    Last edited by georgec; Thu 25th Jul '13, 9:18am.
    - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

  • #2
    Please try AdminCP -> Maintenance -> Repair / Optimize Tables first and run the tool, does that help?
    No private support, only PM me when I ask for it. Support in the forums only.

    Comment


    • #3
      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.
      - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

      Comment


      • #4
        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.
        No private support, only PM me when I ask for it. Support in the forums only.

        Comment


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

          Code:
          truncate usercss
          also something that may work as Wayne posted a while ago?
          - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

          Comment


          • #6
            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.

            Comment


            • #7
              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,
              - JavaScript Kit | CSS Drive | CodingForums.com | CodeTricks.com

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X