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:

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\";s:10:\"searchuser \";s:0:\"\";s:9:\"exactname\";i:1;s:11:\"starteron ly\";i:0;s:3:\"tag\";s:0:\"\";s:11:\"forumchoice\" ;a:0:{}s:12:\"prefixchoice\";a:0:{}s:11:\"childfor ums\";i:1;s:9:\"titleonly\";i:0;s:9:\"showposts\"; i:0;s:10:\"searchdate\";s:0:\"\";s:11:\"beforeafte r\";s:0:\"\";s:6:\"sortby\";s:0:\"\";s:9:\"sortord er\";s:0:\"\";s:9:\"replyless\";i:0;s:10:\"replyli mit\";i:0;s:14:\"searchthreadid\";i:0;s:9:\"savepr efs\";i:0;s:11:\"quicksearch\";i:1;s:10:\"searchty pe\";i:0;s:7:\"exclude\";s:0:\"\";s:7:\"nocache\"; i:0;s:4:\"ajax\";i:0;s:11:\"humanverify\";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 1199036378 at 1199036378 ---------------

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 :)