postindex table DB errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bplinson
    Senior Member
    • Mar 2004
    • 290
    • 6.X

    postindex table DB errors

    I am getting a lot of the following error.

    Database error in vBulletin 3.8.5:

    Invalid SQL:

    SELECT postid
    FROM vb3_postindex
    WHERE wordid IN(871);

    MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Request Date : Sunday, June 6th 2010 @ 09:44:09 PM
    Error Date : Sunday, June 6th 2010 @ 09:44:09 PM
    Script : http://xlforum.net/vbportal/forums/s...php?do=process
    Referrer : http://xlforum.net/vbportal/forums/search.php
    IP Address : xxx.xxx.xxx.xxx
    Username : xxxxxxxxxxx
    Classname : vB_Database_MySQLi
    MySQL Version :

    Also the post index table shows Data Length of 0 and an Index Length of 0

    When I run Repair/Optimize I only get this: Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed

    Anyway to fix this??
  • bplinson
    Senior Member
    • Mar 2004
    • 290
    • 6.X

    #2
    More examples of the error:

    Database error in vBulletin 3.8.5:

    Invalid SQL:

    SELECT postid, intitle
    FROM vb3_postindex
    WHERE wordid IN(220) AND intitle = 2;

    MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Request Date : Sunday, June 6th 2010 @ 09:46:14 PM
    Error Date : Sunday, June 6th 2010 @ 09:46:14 PM
    Script : http://www.xlforum.net/vbportal/foru...=0&titleonly=1
    Referrer : http://www.xlforum.net/vbportal/foru...=0&titleonly=1
    IP Address : 165.214.4.22
    Username : Phillober
    Classname : vB_Database_MySQLi
    MySQL Version :

    ----------------------------------------------

    Database error in vBulletin 3.8.5:

    Invalid SQL:

    REPLACE INTO vb3_postindex
    (wordid, postid, score, intitle)
    VALUES
    (1205, 2665400, 1, 0), (2971, 2665400, 1, 0), (72621, 2665400, 1, 0), (246416, 2665400, 1, 0), (1098, 2665400, 1, 0), (216546, 2665400, 1, 0), (253307, 2665400, 1, 0), (6, 2665400, 1, 0), (2696, 2665400, 1, 0), (596, 2665400, 1, 0), (2247, 2665400, 1, 0), (1097, 2665400, 1, 0), (1099, 2665400, 1, 0), (1035, 2665400, 1, 0), (10293, 2665400, 1, 0), (145, 2665400, 1, 0), (4222, 2665400, 1, 0), (35266, 2665400, 1, 0), (4699, 2665400, 1, 0), (216461, 2665400, 1, 0), (11146, 2665400, 1, 0), (18398, 2665400, 1, 0), (13137, 2665400, 2, 0), (220530, 2665400, 1, 0), (4254, 2665400, 2, 0), (217672, 2665400, 1, 0), (1824, 2665400, 1, 0), (357427, 2665400, 1, 0), (517895, 2665400, 1, 0), (197, 2665400, 1, 0), (1956, 2665400, 1, 0), (8531, 2665400, 1, 0), (1348, 2665400, 1, 0), (3425, 2665400, 1, 0), (443906, 2665400, 1, 0);

    MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Request Date : Sunday, June 6th 2010 @ 09:43:13 PM
    Error Date : Sunday, June 6th 2010 @ 09:43:14 PM
    Script : http://xlforum.net/vbportal/forums/n...reply&t=824715
    Referrer : http://xlforum.net/vbportal/forums/n...eply&p=2664300
    IP Address : 61.224.230.227
    Username : pigfoot
    Classname : vB_Database_MySQLi
    MySQL Version :

    -----------------------------------------------

    Database error in vBulletin 3.8.5:

    Invalid SQL:
    DELETE FROM vb3_postindex WHERE wordid IN (0,216354,58336,98990,7000,12005,6043) AND postid = 2665391;

    MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Request Date : Sunday, June 6th 2010 @ 09:40:52 PM
    Error Date : Sunday, June 6th 2010 @ 09:40:52 PM
    Script : http://xlforum.net/vbportal/forums/e...stid=undefined
    Referrer : http://xlforum.net/vbportal/forums/s...66660&page=364
    IP Address : 98.154.158.81
    Username : ceh383
    Classname : vB_Database_MySQLi
    MySQL Version :

    Comment

    • bplinson
      Senior Member
      • Mar 2004
      • 290
      • 6.X

      #3
      Also noticed now I can not pementently delete posts. When I try I get this error.

      Database error in vBulletin 3.8.5:
      Invalid SQL:
      DELETE FROM vb3_postindex WHERE wordid IN (0,1258,545,953,588,591,88564,813) AND postid = 2665457;
      MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Request Date : Sunday, June 6th 2010 @ 11:06:40 PM
      Error Date : Sunday, June 6th 2010 @ 11:06:40 PM
      Script : http://xlforum.net/vbportal/forums/p...hreadid=825555
      Referrer : http://xlforum.net/vbportal/forums/p...=825555&pollid=
      IP Address : xxx.xxx.xxx.xx
      Username : xxxxxx
      Classname : vB_Database_MySQLi
      MySQL Version : 5.0.45

      I can soft delete them. When I try to restore a soft deleted post I get the following error but it is restored.

      Database error in vBulletin 3.8.5:
      Invalid SQL:
      DELETE FROM vb3_postindex WHERE wordid IN (0,1258,545,953,588,591,88564,813) AND postid = 2665457;
      MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Request Date : Sunday, June 6th 2010 @ 11:08:15 PM
      Error Date : Sunday, June 6th 2010 @ 11:08:15 PM
      Script : http://xlforum.net/vbportal/forums/p...hread&t=825555
      Referrer : http://xlforum.net/vbportal/forums/p...hread&t=825555
      IP Address : xxx.xxx.xxx.xxx
      Username : xxxxxx
      Classname : vB_Database_MySQLi
      MySQL Version : 5.0.45

      When I try to edit a post I get the following error but the post is edited.

      Database error in vBulletin 3.8.5:
      Invalid SQL:
      DELETE FROM vb3_postindex WHERE wordid IN (0,1258,545,953,588,591,88564,813) AND postid = 2665457;
      MySQL Error : Table './db_xlforum_2/vb3_postindex' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Request Date : Sunday, June 6th 2010 @ 11:09:24 PM
      Error Date : Sunday, June 6th 2010 @ 11:09:24 PM
      Script : http://xlforum.net/vbportal/forums/e...postid=2665457
      Referrer : http://xlforum.net/vbportal/forums/s...d.php?t=825555
      IP Address : xxx.xxx.xxx.xxx
      Username : xxxxxxx
      Classname : vB_Database_MySQLi
      MySQL Version : 5.0.45

      Comment

      • bplinson
        Senior Member
        • Mar 2004
        • 290
        • 6.X

        #4
        Ok....I also notice that threads older then when this error began are not updating the New Posts when replied to.

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          As per your ticket, you will need to run the Repair option via AdminCP > Maintenance > Repair/Optimise Tables. You may need to run this several times for it to work.

          If this doesn't work, the tables may be too damaged for this to work and you should get your host to look into this for you.
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          Related Topics

          Collapse

          Working...