Database error 1016

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • basa
    Senior Member
    • Jan 2002
    • 421
    • 3.0.0 Beta 4

    Database error 1016

    Hi,

    I get the following error, and the thread views is messed up... any ideas?

    Thanks

    Database error in vBulletin 3.6.0:
    Invalid SQL:
    SELECT threadid, COUNT(*) AS views
    FROM threadviews
    GROUP BY threadid;
    MySQL Error : Can't open file: 'threadviews.MYI'. (errno: 145) Error Number : 1016
    Date : Wednesday, October 4th 2006 @ 08:56:02 PM
    Script :
    http://www.wehrmacht-awards.com/forums/cron.php?&rand=384325
    Referrer : http://www.wehrmacht-awards.com/forums/private.php?do=insertpm&pmid=1408628
    IP Address : 74.56.111.58
    Username : Unregistered
    Classname : vb_database
    Sebastián J. Bianchi

  • basa
    Senior Member
    • Jan 2002
    • 421
    • 3.0.0 Beta 4

    #2
    Is this the right place to ask?
    Sebastián J. Bianchi

    Comment

    • Marco van Herwaarden
      Senior Member
      • Nov 2004
      • 6999
      • 3.8.x

      #3
      MySQL error code 145: Table was marked as crashed and should be repaired

      To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all
      errors:
      Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

      If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

      Comment

      • mikep
        Senior Member
        • Jun 2006
        • 164
        • 3.5.x

        #4
        i HAVE THIS ERROR AND CANT LOG IN, CAN YOU PLEASE DIRECT ME TO PHPMYADMIN INFO SO i CAN USE THIS

        tHANKS

        - sorry for the caps
        ai-stockmarketforum vbulletin-faq vbulletin-fans

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          PhpMyAdmin is a MySQL database management tool. Most web hosts provide this as part of the web site management tools such as CPanel, Plesk or Ensim. Look for a link to SQL or MySQL Databases. If you can't find it I suggest you ask your host about this.

          If for some reason they do not provide phpMyAdmin or an equivalent MySQL manager, then you can download and install phpMyAdmin yourself from this location:
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

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