Announcement

Collapse
No announcement yet.

database errors, help please

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

  • database errors, help please

    When I try to login to my admin I get the following error
    Code:
    Database error in vBulletin 3.7.2:
    Invalid SQL:
    DELETE FROM vbulletinstrikes WHERE striketime < 1227042228;
    MySQL Error   : Can't open file: 'vbulletinstrikes.MYI' (errno: 145)
    Error Number  : 1016
    Request Date  : Tuesday, November 18th 2008 @ 05:03:48 PM
    Error Date    : Tuesday, November 18th 2008 @ 05:03:48 PM
    Script        : http://www.tattoofreaks.com/forums/login.php?do=login
    Referrer      : http://www.tattoofreaks.com/forums/admincp/index.php
    IP Address    : 125.27.31.182
    Username      : Karl
    Classname     : vB_Database
    MySQL Version : 4.1.12-log
    And when my members are trying to login, they get an error aswell.
    Code:
    Database error in vBulletin 3.7.2:
    Invalid SQL:
    DELETE FROM vbulletinstrikes WHERE striketime < 1226962811;
    MySQL Error : Can't open file: 'vbulletinstrikes.MYI' (errno: 145)
    Error Number : 1016
    
    I believe I have to repair some tables, but don't have a clue where to start.
    I have phpmyadmin installed or could use PuTTY to get into my database.

    Thanks

  • #2
    You can go to the admincp > maintenance > repair database > run optimize and then repair - on the specific table, and then on all tables.

    Or

    Use phpmyadmin to select the database, then checkbox all the tables, and run repair and optimize a few times.

    Or

    Use SSH.

    Comment


    • #3
      Thanks, I can't get into my admin, so need to use another solution, what commands do I use in SSH to repair?

      Comment


      • #4
        A repair query can be run directly against the table:

        REPAIR TABLE x;


        Replace X with the table name that's corrupt.


        myisamchk can be used too if you want, check the mysql site for details. http://dev.mysql.com/doc/refman/5.0/...r-options.html



        or use: mysqlcheck

        mysqlcheck -s -u mysqlusername -p dbname

        Ignore session and cpsession table messages.

        quick repair: mysqlcheck -r -q -u mysqlusername -p dbname

        then check again, if it still errors, use a full repair:

        mysqlcheck -r -u mysqlusername -p dbname

        Comment


        • #5
          Thnks, if you look at the errors above, would the table to repair be 'vbulletinstrikes' ?

          Comment


          • #6
            the table strikes with prefix vbulletin, yes

            Comment

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