Forum Error Building search index
 

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

Quote:
Building Search Index Null Type 0 :: 250 Database error

<div class="bbcode_container"> Code:
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