[Forum] Error Building search index

[monstermunch]

Hi,

I upgraded today from 3.8 to 4.02 pl1, everything seems ok and after logging into admincp i was given a couple of things to do, one was to "rebuilt search index" but when i do this i get the following error.

Building Search Index Null Type 0 :: 250 Database error

Database error in vBulletin 4.0.2:

Invalid SQL:

            SELECT p.postid, p.threadid, p.username, p.userid, p.title, p.dateline, p.pagetext, p.allowsmilie, p.showsignature, p.ipaddress, p.iconid, p.visible, p.parentid, p.attach, p.infraction, p.reportthreadid, t.threadid, t.title, t.lastpost, t.forumid, t.pollid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.iconid, t.notes, t.visible, t.sticky, t.votenum, t.votetotal, t.attach, t.firstpostid, t.similar, t.hiddencount, t.deletedcount, t.lastpostid, t.prefixid, t.taglist, t.lastposterid, t.keywords
            FROM post as p join thread as t ON p.threadid = t.threadid
            WHERE p.postid >= 0 AND p.postid <= 250;

MySQL Error   : Unknown column 'p.infraction' in 'field list'
Error Number  : 1054

any ideas?

[biggazillakilla]

Just got this error, too, and am looking for a way to fix the problem...

[Trevor Hannant]

On 4.0.2?

[biggazillakilla]

On 4.0.2?

Yes.

I've currently got the CMS disabled; I re-enabled it temporarily to see whether that would allow me to rebuild the search index. That worked.

[Trevor Hannant]

That column appears as a default column in 3.8.6 and through vB4 so something else has deleted that if it doesn't exist in your database - it's not been done by the upgrade script.

Double check the list of columns for the post table in phpMyAdmin against those below (taken from the 4.0.2 install/mysql-schema.php file) and make sure nothing else is missing:

$schema['CREATE']['query']['post'] = "
CREATE TABLE " . TABLE_PREFIX . "post (
    postid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    parentid INT UNSIGNED NOT NULL DEFAULT '0',
    username VARCHAR(100) NOT NULL DEFAULT '',
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    title VARCHAR(250) NOT NULL DEFAULT '',
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    pagetext MEDIUMTEXT,
    allowsmilie SMALLINT NOT NULL DEFAULT '0',
    showsignature SMALLINT NOT NULL DEFAULT '0',
    ipaddress CHAR(15) NOT NULL DEFAULT '',
    iconid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    visible SMALLINT NOT NULL DEFAULT '0',
    attach SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    infraction SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (postid),
    KEY userid (userid),
    KEY threadid (threadid, userid),
  KEY threadid_visible_dateline (threadid, visible, dateline, userid, postid),
    KEY dateline (dateline),
    KEY ipaddress (ipaddress)
)
";
$schema['CREATE']['explain']['post'] = sprintf($vbphrase['create_table'], TABLE_PREFIX . "post");