This took me quite a while to find. Here is the query to use in MySql to create the search table in VBulletin. To find the code to create other tables in VBulletin database go to your VB upload files to: install/mysql-schema.php
This was in response to an INVALID SQL error in VB 4.0 where “domainname” is the name of your website url:
MySQL Error : Table ‘domainname.search’ doesn’t exist
Error Number : 1146
A collection of my changed VBulletin 4.0 settings. I’m posting this so I can remember the changes as I go along that may be helpful to other people. Maybe other VB owners have better, or additional suggestions, they can let me know about. (hint, hint: leave a comment please!)
Just released on December 21, 2009 – the new VB4 has received mixed reviews. Members of my communities also are mixed on their appreciation. We’ll give it some time to settle and see how it goes with the new CMS. I run forums on both VB and PhpBB.