Announcement

Collapse
No announcement yet.

MySQL error

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

  • MySQL error

    Database error in vBulletin 3.5.3:

    Invalid SQL:
    DELETE FROM postindex WHERE wordid IN (0,653,278,17889,3385,5570,247,1479,778,1539,1888,1006,3924,11342,1472,167,2901,1752,844,3 016,689,211,3481,761,1650,251,6097,216,2094,21347,45227,249,656,3596,802,3065,700,294,2030 9,41,45928,3214,284,19,1852,1759,13456,6812,2961,7455,1302,5082,102,4166,246,25,231,283,34 3,110,33039,7507,11926,1622,190,909,44,1642,1035,44940) AND postid = 31845;

    MySQL Error : Can't open file: 'postindex.MYI' (errno: 145)
    Error Number : 1016
    Date : Wednesday, January 11th 2006 @ 03:10:00 AM
    Script : http://www.gaiaevolved.com/forum/postings.php
    Referrer : http://www.gaiaevolved.com/forum/pos...gepost&p=31845



    It's when I try to physically delete a post that has been soft deleted by one of the moderators. Never got this error before, only started once 3.5.3 was uploaded.

  • #2
    Please run the Repair/Optimize database options in your AdminCP or in phpMyAdmin
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      What boxes do I check off?

      Comment


      • #4
        I recommend to run optimize first on all the tables.
        And then do another run with repair on all the tables.

        if that doesn't work ask your web hosting to run optimize and repair on the database from the shell.

        Comment


        • #5
          Thanks it worked!

          Comment


          • #6
            Glad to hear that it has been resolved.

            Comment

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