Announcement

Collapse
No announcement yet.

Database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    See this thread:

    http://www.vbulletin.com/forum/showt...threadid=69171

    Leave a comment:

  • mclark2112
    Member

  • mclark2112
    replied
    I am having the same problems. Sometimes it is the user table sometimes the thread table. The errors just started a week ago, and they are happening about twice a day.

    What else could be going wrong. I am still using 2.6
    and am going to upgrade to 2.9 as soon as I fix this.

    Leave a comment:

  • Jay Krupp
    Member

  • Jay Krupp
    replied
    That was actually really funny.

    Haha, thanks, I'll try it.

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    I bet at parties you let other people tell jokes and you chip in with the punch line, right?

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    It's a gift.

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    I don't believe it.
    How do you do it?
    You picked exactly the right moment to beat me to it with the query.
    vBR
    Senior Member
    Last edited by vBR; Thu 10 Apr '03, 12:19am.

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Your user table is corrupted. To fix this run this query in phpMyAdmin:

    REPAIR TABLE user;

    Leave a comment:

  • Jay Krupp
    Member

  • Jay Krupp
    replied
    Database error in vBulletin Control Panel 2.2.9:

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

    mysql error number: 1016

    Date: Thursday 10th of April 2003 12:08:40 AM
    Script: http://www.rhymenreason.net/forum/forum/admin/
    Referer:
    Database error in vBulletin 2.2.9:

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

    mysql error number: 1016

    Date: Thursday 10th of April 2003 12:10:14 AM
    Script: http://www.rhymenreason.net/forum/forum/
    Referer:
    Each sent in seperate emails.

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    View your forums again with the correct technical email set and let it mail you the error report.

    Leave a comment:

  • Jay Krupp
    Member

  • Jay Krupp
    replied
    Yes.

    I haven't tried individual threads, but I'd assume it was the same. Everything else on the site works except the vb at this point.

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    So you receive the error just by viewing your forum home?

    Leave a comment:

  • Jay Krupp
    Member

  • Jay Krupp
    replied
    That's just the thing. It happened when I was not online.

    I got on my computer and found it.

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    Originally posted by Jay Krupp
    I understood all of that up until "duplicate the error."

    How would I do that?
    What were you doing when the error happened?
    Can you make the error happen again?

    Leave a comment:

  • Jay Krupp
    Member

  • Jay Krupp
    replied
    I understood all of that up until "duplicate the error."

    How would I do that?

    Leave a comment:

  • vBR
    Senior Member

  • vBR
    replied
    Originally posted by Jay Krupp
    And let's say the address it would be sent to is inactive. Then how would a person go about fixing it?
    As admin you keep the address active or change it in /admin/config.php.

    Code:
    // technical email address - any error messages will be emailed here
    $technicalemail = "[email protected]";
    If that address is inactive, update it to an active one and try to duplicate the error.

    Leave a comment:

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