DB Error during install
Got a db error during installation.
I did have version 3 installed, however i did uninstall it by uninstalling the product and then deleting those files, and upload the v4 stuff. I did the config.php thing correctly, but i get a db error when running the install script. It get's down to
Step 3
Adding data to table: bbcode
Adding data to table: vw_nodetype
Adding data to table: product
Adding data to table: productcode
Adding data to table: productdependency
Adding data to table: package
Adding data to table: contenttype
Then gives a db error with
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
REPLACE INTO `vb_contenttype` (`class`, `cansearch`, `canattach`, `packageid`) VALUES ('vwPage',1,0,),
('vwComment',1,1,);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),
('vwComment',1,1,)' at line 1
Error Number : 1064
Request Date : Saturday, March 23rd 2013 @ 11:46:51 PM
Error Date : Saturday, March 23rd 2013 @ 11:46:52 PM
Script : http://www.******.com/vault/install/index.php?step=3&nostyle=1
Referrer : http://www.******.com/vault/install/index.php?step=2&nostyle=1
IP Address : **.***.***.***
Username : *******
Classname : vB_Database
MySQL Version : 5.0.96-community-cll-lve
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/vault/core/controller/db/vb3.php on line 182
#3 vw_DB_Controller_vB3->query_write() called in [path]/vault/core/model/db/mysql/vw.php on line 791
#4 vw_DB_MySQL_Model->shutdown_or_run() called in [path]/vault/core/model/db/mysql/vw.php on line 762
#5 vw_DB_MySQL_Model->replace() called in [path]/vault/core/controller/install/full/steps/vb3.php on line 79
#6 {closure}() called in [path]/vault/core/controller/progress/vw.php on line 80
#7 vw_Progress_Controller->call() called in [path]/vault/core/controller/cp/progress/vw.php on line 39
#8 vw_CP_Progress_Controller->process() called in [path]/vault/core/controller/cp/install/vw.php on line 136
#9 vw_CP_Install_Controller->install() called in [path]/vault/core/controller/cp/install/vw.php on line 74
#10 vw_CP_Install_Controller->execute() called in [path]/vault/cp/global.php on line 70
#11 require_once([path]/vault/cp/global.php) called in [path]/vault/install/index.php on line 37
#12 require([path]/vault/install/index.php) called in [path]/vbseo.php on line 1398