We just upgraded from 3.6.0 rc 1 to 3.6.11.
We pruned threads prior to the upgrade and we rebuilt the thread information and the forum information. Then we uploaded the 3.6.11 files and ran the upgrade.
Everything seemed to go fine, except we now have a problem with the search. We get a database error when we attempt a search. The error is as follows:
Database error in vBulletin 3.6.11:
Invalid SQL:
INSERT INTO vbrq_recent_queries
SELECT * FROM vbsearch
WHERE searchid = 1013743;
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Sunday, November 2nd 2008 @ 03:13:48 PM
Script : http://www.xxxxxxx.com/boards/search.php?do=process
Referrer : http://www.xxxxxxx.com/boards/search...archid=1013734
IP Address : xx.xxx.xxx.xxx
Username : xxxxx
Classname : vb_database
We pruned threads prior to the upgrade and we rebuilt the thread information and the forum information. Then we uploaded the 3.6.11 files and ran the upgrade.
Everything seemed to go fine, except we now have a problem with the search. We get a database error when we attempt a search. The error is as follows:
Database error in vBulletin 3.6.11:
Invalid SQL:
INSERT INTO vbrq_recent_queries
SELECT * FROM vbsearch
WHERE searchid = 1013743;
MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Sunday, November 2nd 2008 @ 03:13:48 PM
Script : http://www.xxxxxxx.com/boards/search.php?do=process
Referrer : http://www.xxxxxxx.com/boards/search...archid=1013734
IP Address : xx.xxx.xxx.xxx
Username : xxxxx
Classname : vb_database
Comment