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:\"\" ;;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\" ;;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
|