Announcement

Collapse
No announcement yet.

Forum down! MySQL Error 1016 | errno: 145

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

  • Forum down! MySQL Error 1016 | errno: 145

    Hello there,

    the forum is down showing an Error page


    (There seems to have been a slight problem with the MCSEboard.de MCSE Forum database.
    Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


    We apologise for any inconvenience.)


    The mails we're getting are as follows (~200/min(!)):


    [quote]Database error in vBulletin 2.2.8:
    Invalid SQL:
    SELECT post.*,post.username AS postusername,user.username,user.signature,icon.title AS
    icontitle,icon.iconpath
    FROM post
    LEFT JOIN icon ON icon.iconid=post.iconid
    LEFT JOIN user ON user.userid=post.userid
    WHERE post.threadid='4763' AND post.visible=1
    ORDER BY dateline
    LIMIT 0,10
    mysql error: Can't open file: 'user.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Wednesday 03rd of September 2003 06:35:13 PM
    Script: http://www.mcseboard.de/printthread.php?threadid=4763
    Referer: [quote]

    or

    Database error in vBulletin 2.2.8:
    Invalid SQL: UPDATE user SET lastactivity=1062601638 WHERE userid=0 AND lastactivity<1062601638
    mysql error: Can't open file: 'user.MYD'. (errno: 145)
    mysql error number: 1016
    Date: Wednesday 03rd of September 2003 06:33:50 PM
    Script: http://www.mcseboard.de/showthread.php?threadid=10118
    Referer: http://www.mcseboard.de/archiv/28/2003/07/1/10118
    Anyone has any idea what that means?

    MySQL Error 1016, errno 145 on www.mcseboard.de

    Thanks,
    -Tom
    http://www.mcseboard.de/images/buttons/lastpost.gif www.MCSEboard.de
    German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

  • #2
    Solved

    Sorry, a search here on the forums did it:
    http://www.vbulletin.com/forum/showt...highlight=1016



    REPAIR table user; in phpmyadmin did it

    Thanks a bunch,
    you rock,
    -Tom
    http://www.mcseboard.de/images/buttons/lastpost.gif www.MCSEboard.de
    German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

    Comment


    • #3
      That means the table has crashed and needs to be repaired. Upload repair.php to your admin directory and run it from your browser. Repair.php is in the extras folder in the vBulletin zip file.

      Comment


      • #4
        Yes, I tried, but repair.php itself gave me the same error.
        Nevermind, Steve's solution using phpMyAdmin worked
        Thanks,
        http://www.mcseboard.de/images/buttons/lastpost.gif www.MCSEboard.de
        German Windows Server & IT Pro Community dedicated to Windows Client & Server Systems. MVPs inside

        Comment


        • #5
          The repair.php script often doesn't work on errors to the user and userfield tables. I don't know why exactly.
          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


          • #6
            Off topic but i think you should upgrade to 2.3.2, it's not hard.

            Comment

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