Announcement

Collapse
No announcement yet.

Just got this error message....

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

  • Just got this error message....

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    REPLACE INTO postindex
    (wordid, postid, score, intitle)
    VALUES
    (4672, 112923, 2, 2), (43441, 112923, 2, 2), (9462, 112923, 3, 2), (3939, 112923, 4, 2), (3324, 112923, 1, 0), (1280, 112923, 1, 0), (566, 112923, 1, 0), (1727, 112923, 2, 0), (11175, 112923, 2, 0), (21164, 112923, 1, 0), (8347, 112923, 3, 0), (1611, 112923, 2, 0), (4422, 112923, 1, 0), (5846, 112923, 1, 0), (35934, 112923, 1, 0), (549, 112923, 1, 0), (850, 112923, 1, 0), (5230, 112923, 1, 0), (223, 112923, 1, 0), (150, 112923, 1, 0)

    mysql error: Can't open file: 'postindex.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Saturday 11th of December 2004 04:40:21 PM
    Script: http://www.theconversationcafe.com/forums/newthread.php
    Referer: http://www.theconversationcafe.com/f...newthread&f=27
    Username: Mabel

  • #2
    Database error in vBulletin 3.0.3:

    Invalid SQL:
    REPLACE INTO postindex
    (wordid, postid, score, intitle)
    VALUES
    (52, 112927, 1, 1), (200, 112927, 1, 0), (642, 112927, 1, 0), (15185, 112927, 1, 0), (17167, 112927, 1, 0), (2683, 112927, 1, 0), (572, 112927, 1, 0), (3025, 112927, 1, 0), (1616, 112927, 1, 0), (173, 112927, 1, 0), (59, 112927, 1, 0), (939, 112927, 1, 0), (280, 112927, 1, 0)

    mysql error: Can't open file: 'postindex.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Saturday 11th of December 2004 04:48:07 PM
    Script: http://www.theconversationcafe.com/forums/newreply.php
    Referer: http://www.theconversationcafe.com/f...ad.php?t=11759
    Username: Mabel

    Comment


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

      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
      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


      • #4
        Alright, I did that about 6 times, and it did fix some things, but 2 things wouldn't fix -

        1.) attachmentviews - error: can't find file: 'attachmentviews.MYD' (errno:2)

        2.) threadviews - error: can't find file: 'threadviews.MYD' (errno:2)

        Comment


        • #5
          To fix these, errors, run these queries to recreate these tables (assuming you have no table prefix):

          DROP TABLE IF EXISTS attachmentviews;
          CREATE TABLE attachmentviews (
          attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
          KEY postid (attachmentid)
          );


          DROP TABLE IF EXISTS threadviews;
          CREATE TABLE threadviews (
          threadid INT UNSIGNED NOT NULL DEFAULT '0',
          KEY threadid (threadid)
          );
          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


          • #6
            In addition to running those queries, you may want to set attachment and thread views to not be updated automatically (if they are not so already). This can cause these errors quite easily. To do this, go to:

            Admin CP --> vBulletin Options --> Server Settings and Optimization Options

            Set both of the following to No: Update Thread Views Immediately and Update Attachment Views Immediately. See if that helps if they are on.
            Bugdar: PHP bug tracking software that is beautiful, fast, and robust.

            Comment


            • #7
              I'm not sure how to run those queries, I've never done that before - can someone walk me through it?

              Comment

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