Bug Database Error Upon Installing

[Bullmama DeLano]

Initial installation started good but then I received a db error after several db tables were installed.

Here is the error:

Invalid SQL:

ALTER TABLE  `vb3dbtech_classifieds_question_category` 
CHANGE  `question_categoryid`  `question_categoryid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error   : Table 'englishb_mysql.vb3dbtech_classifieds_question_category' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, December 31st 2013 @ 12:24:20 PM
Error Date    : Tuesday, December 31st 2013 @ 12:24:56 PM
Script        : http://www.englishbulldognews.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.englishbulldognews.com/forums/admincp/plugin.php?do=productadd
IP Address    : 107.4.97.254
Username      : desertskybulldogs
Classname     : vB_Database
MySQL Version : 5.1.72-cll

I then uploaded all the files again to make sure there was no mistake there. Then I tried uploading the XML again, this time I got this error:

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO `package` (`productid`, `class`) 
VALUES ('dbtech_classifieds', 'DBTechClassifieds');;

MySQL Error   : Duplicate entry 'DBTechClassifieds' for key 'class'
Error Number  : 1062
Request Date  : Tuesday, December 31st 2013 @ 12:27:35 PM
Error Date    : Tuesday, December 31st 2013 @ 12:27:37 PM
Script        : http://www.englishbulldognews.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.englishbulldognews.com/forums/admincp/plugin.php?do=productadd
IP Address    : 107.4.97.254
Username      : desertskybulldogs
Classname     : vB_Database
MySQL Version : 5.1.72-cll

I cannot uninstall the product because it hasn't been completely added yet. Help please!

 

[Bullmama DeLano]

I thought I would try it on one of my other sites to see if it worked, here is when the first db error came up:

 

[Mokonzi]

I'm not sure on the issue. Will have a look a little later in the evening. If you can send me access to your phpmyadmin install via PM I'll fix the errors so you can install cleanly. Thanks for reporting the issue.

 

[Bullmama DeLano]

I'm not sure on the issue. Will have a look a little later in the evening. If you can send me access to your phpmyadmin install via PM I'll fix the errors so you can install cleanly. Thanks for reporting the issue.

I actually don't know it, I use a managed server so anything related to that type of stuff I have them handle.

I tried installing on 3 different forums, it stops at the same spot everytime.

 

[Mokonzi]

If you have a cPanel login that would work. managed servers are far easier

 

[Mokonzi]

I've found the error and fixed it in the RC2 download. The RC2 download then needs reuploading to your server and proceeding with the install again.

I'll PM you once I've completed the cleanup of your database.

 

[Bullmama DeLano]

I've found the error and fixed it in the RC2 download. The RC2 download then needs reuploading to your server and proceeding with the install again.

I'll PM you once I've completed the cleanup of your database.

Thanks! Very much looking forward to what this mod can do.