[Storyteller69]

Originally Posted by mandingo

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : Table '*****.vb_contentpages_categories' doesn't exist
Error Number : 1146
Request Date : Sunday, March 28th 2010 @ 04:31:24 PM
Error Date : Sunday, March 28th 2010 @ 04:31:25 PM
Script : http://mysite/admincp/plugin.php?do=productimport
Referrer : http://mysite/admincp/plugin.php?do=productadd
IP Address : 75.172.232.60
Username : yez
Classname : vB_Database
MySQL Version : 5.1.30

I get the same error when i try to install version 0.9.0 the first time with this Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 421
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 439
#2 vB_Database->query_write() called in [path]/includes/adminfunctions_plugin.php(450) : eval()'d code on line 12
#3 run_queries() called in [path]/includes/adminfunctions_plugin.php(450) : eval()'d code on line 50
#4 eval() called in [path]/includes/adminfunctions_plugin.php on line 450
#5 install_product() called in [path]/admincp/plugin.php on line 1714

The tables where created but with "my" prefix vb_3 and not only vb_. On a local-testforum without a table-prefix i get the same error. Can the "wrong" prefix be the reason for the error?