Announcement

Collapse
No announcement yet.

postindex table DB errors

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

  • Trevor Hannant
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • bplinson
    replied
    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

    Leave a comment:


  • bplinson
    replied
    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 :

    Leave a comment:


  • bplinson
    started a topic postindex table DB errors

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

Related Topics

Collapse

Working...
X