Announcement

Collapse
No announcement yet.

mySQL error

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mySQL error

    I keep getting the following errors since having to reboot my server. My VBulletin is currently down and so is the admin section.

    Invalid SQL: SELECT userid, username, birthday FROM user WHERE birthday LIKE '%-12-17'
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT user.userid,user.username,moderator.forumid
    FROM moderator
    LEFT JOIN user
    ON (moderator.userid=user.userid)
    ORDER BY user.username
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='813'
    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016



    I had a guy that went into to the system and said he did the following:

    "Repair.php is part of vBulletin. I use the SSH interfacing directly
    with MySQL instead, it gives more information. I did repair the
    databases, but that seems not to be the problem as the error is still
    occurring."

    How can I fix this problem?

  • #2
    one thread is enough http://www.vbulletin.com/forum/showt...threadid=61355
    :: 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