sql error

[Liquid1ce]

ive upgraded to vb 3.7.0 beta 3 but the search keeps returning errors
ive searched vbulltin but nothing comes up

error is:

PHP Code:

MySQL Error   : Unknown column 'prefixchoice' in 'field list'
Error Number  : 1054
Date          : Saturday, December 22nd 2007 @ 11:55:09 AM 


anyone knw a fixx ?

[Lynne]

Have you disabled your hacks and seen if you still get the error?

[Liquid1ce]

yes they've been disabled, its only when i do a search it returns that error

[Liquid1ce]

bump still cant fix error

Invalid SQL:

REPLACE INTO search
(userid, titleonly, ipaddress, personal, query, searchuser, forumchoice, prefixchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, searchterms, displayterms, searchhash, completed)
VALUES (
1,
0 ,
'87.194.91.207',
0,
'net',
'',
'',
'',
'lastpost',
'DESC',
0,
0,
'',
1199034638,
'a:25:{s:5:\"query\";s:3:\"net\&quo t;;s:10:\"searchuser\";s:0:\"\&quot ;;s:9:\"exactname\";i:1;s:11:\"star teronly\";i:0;s:3:\"tag\";s:0:\&quo t;\";s:11:\"forumchoice\";a:0:{}s:1 2:\"prefixchoice\";a:0:{}s:11:\"chi ldforums\";i:1;s:9:\"titleonly\";i: 0;s:9:\"showposts\";i:0;s:10:\"sear chdate\";s:0:\"\";s:11:\"befor eafter\";s:0:\"\";s:6:\"sortby \";s:0:\"\";s:9:\"sortorder\&q uot;;s:0:\"\";s:9:\"replyless\&quot ;;i:0;s:10:\"replylimit\";i:0;s:14:\&quo t;searchthreadid\";i:0;s:9:\"saveprefs\& quot;;i:0;s:11:\"quicksearch\";i:1;s:10: \"searchtype\";i:0;s:7:\"exclude\&q uot;;s:0:\"\";s:7:\"nocache\"; i:0;s:4:\"ajax\";i:0;s:11:\"humanve rify\";a:0:{}s:6:\"userid\";i:0;}',
'',
'91c647f52d5ae6591d782f88092efc27',
0
);

MySQL Error : Unknown column 'prefixchoice' in 'field list'
Error Number : 1054
Date : Sunday, December 30th 2007 @ 11:10:38 AM
Script : /search.php?do=process

--------------- Added [DATE]1199036378[/DATE] at [TIME]1199036378[/TIME] ---------------

can anyone share there 3.7.0 beta 3 search table so i can just add it to my sql to hopefully fix this

[snakes1100]

If that is actually the issue, run this.

ALTER TABLE search ADD prefixchoice MEDIUMTEXT NULL;

[Liquid1ce]

thank u very much worked

[Dean C]

Did you run the upgrade script as well as upload the new files? If so you should report this at vBulletin.com