Database error

[bollie]

Database error in vBulletin 3.6.5:
Invalid SQL:
INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 33852, CASE title WHEN 'fgfdgdfg' THEN 1 WHEN 'dfgdfgdfgdfg' THEN 1 ELSE 1 END, CASE title WHEN 'fgfdgdfg' THEN 1 WHEN 'dfgdfgdfgdfg' THEN 0 ELSE 0 END
FROM word
WHERE title IN ('test','dfgdfgdfgdfg');
MySQL Error : Table 'xxxxxxxxx.postindex' doesn't exist
Error Number : 1146
Date : Friday, March 23rd 2007 @ 11:07:15 PM
Script : http://www.xxxxxxxxxxx/forum/newthre...postthread&f=2
Referrer : http://www.xxxxxxxxxx/forum/newthrea...=newthread&f=2
IP Address : xxxxxxxxxx
Username : xxxxxxxxx
Classname : vB_Database

[peterska2]

In your AdminCP > Maintenance > Repair/Optimize Tables look for a table named postindex. If this exists, run repair and optimize a few times until the error clears. If it does not exist then you will need to recreate the table.

[bollie]

In your AdminCP > Maintenance > Repair/Optimize Tables look for a table named postindex. If this exists, run repair and optimize a few times until the error clears. If it does not exist then you will need to recreate the table.

postindex not exist help

[Steve Machol]

Run this query to create that table:

CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)
);

Then if you are using the default vB search option, rebuild the search index.

Admin CP -> Maintenance -> Update Counters -> Rebuild Search Index

[bollie]

Run this query to create that table:

CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)
);

Then if you are using the default vB search option, rebuild the search index.

Admin CP -> Maintenance -> Update Counters -> Rebuild Search Index

Thx Steve