Announcement

Collapse
No announcement yet.

Database errors

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

  • h4p3
    replied
    I think they were lost during the repairing thingy. Two members were deleted, but I really don't know exactly why.

    Anyway ... solved.

    Leave a comment:


  • George L
    replied
    Originally posted by h4p3
    Ok, solved ... found it myself
    okay

    where did they disappear to ?

    Leave a comment:


  • h4p3
    replied
    Ok, solved ... found it myself

    Leave a comment:


  • h4p3
    replied
    http://www.overclockers.at/forum/showgroups.php?s=

    Check this out.

    The moderator list. The first one is the deleted user. Huch?

    Leave a comment:


  • h4p3
    replied
    New problem:

    After the server crash and repairing the tables, some user accounts were deleted.

    wtf?

    Leave a comment:


  • h4p3
    replied
    Ok, got it!

    Everything works now ... thx @ all.

    Leave a comment:


  • Joshua Clinard
    replied
    No, that means you need to run the following URL in your browser.

    repair.php?check=1&iterations=4&forum=vbdatabase

    Change "vbdatabase" to your database name.

    Leave a comment:


  • h4p3
    replied
    I have closed my forum before repairing.

    Now, i got this after running the repair.php file.

    Is it fixed now?

    Leave a comment:


  • George L
    replied
    exactly an improper shut down can cause corruption but just run the repair.php and following the instructions and it will be fixed.. just close your forum when doing this

    Leave a comment:


  • rylin
    replied
    try running the repair file, it will check all the tables in your database, and attempt to repair them.

    the problem is (just like you thought) that mysql didn't shut down properly, eg the table files are possibly still open, waiting to be written to etc.

    hopefully, you'll be able to repair it

    Leave a comment:


  • h4p3
    started a topic Database errors

    Database errors

    Hi,

    got following database errors (my mailbox is nice , 100 emails in 4 minutes, yeah ).

    Database error in vBulletin 2.2.0:

    Invalid SQL: SELECT DISTINCT session.userid,username,invisible,usergroupid
    FROM session
    LEFT JOIN user ON (user.userid=session.userid)
    WHERE session.userid>0 AND session.lastactivity>1011104946
    ORDER BY invisible ASC, username ASC
    mysql error: Got error 127 from table handler

    mysql error number: 1030

    Date: Tuesday 15th of January 2002 03:39:06 PM
    Script: http://www.overclockers.at/forum/forum/
    Referer:
    My server crashed last night, now it's up again, but after some forum browsing, i got this error. Should i run the repair.php file? I think it will help. Btw: could anybody explain me, why MySQL got errors after a server crash? Because of not shutting down correctly?

    Any suggestions appreciated!

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