Announcement

Collapse
No announcement yet.

What needs to be done??

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

  • What needs to be done??

    All of a sudden. I'm getting messages such as:


    Database error in vBulletin 3.5.4:
    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(thread.lastpost >= 1161967733 AND open <> 10, 1, 0)) AS newthread

    FROM thread AS thread

    WHERE forumid = 37
    AND sticky = 0
    AND visible IN (0,1,2);
    MySQL Error : Can't open file: 'thread.MYI'. (errno: 145)
    Error Number : 1016
    Date : Friday, October 27th 2006 @ 01:19:39 PM
    Script : http://www.nowisleep.com/forumdisplay.php?f=37
    Referrer : http://www.nowisleep.com/index.php?
    IP Address : 68.154.241.69
    Username : Kirk Kief
    Classname : vb_database


    And/or I'm receiving emails stating:

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT IF(visible = 2, 1, 0) AS isdeleted,



    thread.*
    FROM thread AS thread




    WHERE thread.threadid = 978;

    MySQL Error : Can't open file: 'thread.MYI'. (errno: 145)
    Error Number : 1016
    Date : Friday, October 27th 2006 @ 12:51:27 PM
    Script : http://www.nowisleep.com/showthread.php?t=978
    Referrer :
    IP Address : 70.20.227.149
    Username : Unregistered
    Classname : vb_database

    A common link in all the emails is the "Can't open 'thread.MYI'. Have I been hacked? What needs to be done? Do I need to reinstall the software?
    Kirk Kief
    http://www.kiefphoto.com
    http://www.professionalimagecreators.com

  • #2
    MySQL error: 145 = Table was marked as crashed and should be repaired

    This error means that table has crashed. 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 -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
    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


    • #3
      I'm running 3.5.4 and I do not find 'Import & Maintenance ' in my Admin CP, just 'Maintenance'
      Kirk Kief
      http://www.kiefphoto.com
      http://www.professionalimagecreators.com

      Comment


      • #4
        Duhh, never mind. I found it.
        Kirk Kief
        http://www.kiefphoto.com
        http://www.professionalimagecreators.com

        Comment


        • #5
          How long should it normally take for one of these Repair/optimize tables take? So far it is taking an hour, or more to run one.
          Kirk Kief
          http://www.kiefphoto.com
          http://www.professionalimagecreators.com

          Comment


          • #6
            That depends on the size of the database.
            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...
            X