No announcement yet.

Need help with a database error....

  • Filter
  • Time
  • Show
Clear All
new posts

  • Need help with a database error....

    I'm getting this in what appears to be on forum. Can someone tell me what to do? Thanks in advance. Mark

    Database error in vBulletin 2.2.7:

    Invalid SQL: SELECT username, invisible, userid
    FROM user
    WHERE inforum = 2
    AND lastactivity > 1035896549
    AND lastvisit <> lastactivity
    mysql error: Got error 127 from table handler

    mysql error number: 1030


    Another one when trying to post......

    Database error in vBulletin 2.2.7:

    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (1189,95937,1)
    mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Tuesday 29th of October 2002 05:42:37 AM

    Date: Tuesday 29th of October 2002 05:17:29 AM
    Last edited by [email protected]; Tue 29 Oct '02, 4:44am.

  • #2
    you have corrupted tables, you need to repair it via one of the following methods
    1. via phpmyadmin

    using 2 queries

    REPAIR TABLE user;


    REPAIR TABLE searchindex;

    2. or using mysqlcheck repair for 3.23.38 and above

    i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

    mysqlcheck -r -u mysqlusername -p databasename

    3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

    myisamchk -r -u root -p databasename

    option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
    :: 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 [ blog summary ]


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