Issue: DATABASE ERROR WHILE SEARCHING

Database error in vBulletin 4.0.3:

Invalid SQL:

				SELECT searchgroup.searchgroupid , searchgroup_text.title
				FROM forum_searchgroup AS searchgroup
			 INNER JOIN forum_thread AS thread ON (
				searchgroup.contenttypeid = 2  AND searchgroup.groupid = thread.threadid)
 INNER JOIN forum_post AS post ON (
				thread.threadid = post.threadid AND searchcore.primaryid = post.postid AND post.parentid = 0)
JOIN forum_searchgroup_text AS searchgroup_text ON (searchgroup_text.searchgroupid = searchgroup.searchgroupid)

WHERE MATCH(searchgroup_text.title) AGAINST ('apple') AND thread.forumid IN ('97','140','99','149','81','103','135','80','111','101','143','104','134','234') AND searchgroup.contenttypeid IN ('2') LIMIT 500;

MySQL Error   : Unknown column 'searchcore.primaryid' in 'on clause'
Error Number  : 1054
Request Date  : Wednesday, June 2nd 2010 @ 05:39:01 PM
Error Date    : Wednesday, June 2nd 2010 @ 05:39:02 PM
Script        : http://www.vaultwiki.org/search.php?do=process
Referrer      : http://www.vaultwiki.org/search.php?search_type=1
IP Address    : 96.246.226.120
Username      : Claw Snuff
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.46-log

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1308
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 468
#2 vB_Database->query_read_slave() called in [path]/packages/vbdbsearch/coresearchcontroller.php on line 701
#3 vBDBSearch_CoreSearchController->get_query_results() called in [path]/packages/vbdbsearch/coresearchcontroller.php on line 123
#4 vBDBSearch_CoreSearchController->get_results() called in [path]/vb/search/results.php on line 51
#5 vB_Search_Results::create_from_criteria() called in [path]/search.php on line 350
#6 require([path]/search.php) called in [path]/vbseo.php on line 1382