Announcement

Collapse
No announcement yet.

Help. Out of the blue, I get this message...

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

  • Help. Out of the blue, I get this message...

    after installing a new style set. It was running great, then boom, disappeared, and it now says this:


    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT userid,username FROM user WHERE userid=977
    mysql error: Got error 134 from table handler

    mysql error number: 1030


    How do I fix this? Thank you.

  • #2
    Ok, can someone please explain this. Now, about 5 minutes later, after doing nothing, it comes back fine, and my new 2nd style is gone.

    Comment


    • #3
      Error code 134 = Record was already deleted (or record file crashed)

      Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

      http://www.yourdomain/forum/admin/repair.php?html=1&check=1

      [Of course change the exact URL as appropriate for your forums.]

      If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        if that doesn't work you may need to via phpmyadmin

        select vB database and run this query

        Code:
        REPAIR TABLE user;
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

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