Bug Field 53 Error Upon Installation

[RobAC]

When uploading the xml file during installation, I get the following error:

Database error in vBulletin 4.1.3:

Invalid SQL:
ALTER TABLE userfield ADD field53 MEDIUMTEXT NULL;

MySQL Error : Duplicate column name 'field53'
Error Number : 1060
Request Date : Friday, April 15th 2011 @ 09:17:56 PM
Error Date : Friday, April 15th 2011 @ 09:18:05 PM
Script : http://www.xxx/forums/admincp/plugin.php?do=productimport
Referrer : http://www.xxx/forums/admincp/plugin.php?do=productadd
IP Address : 24.63.105.213
Username : Rob
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-community

 

[Dylan]

When uploading the xml file during installation, I get the following error:

Did the rest of the mod get installed correctly?If you look at the Manage Products section of the ACP, do you see an entry for the quiz mod?

 

[RobAC]

Did the rest of the mod get installed correctly?If you look at the Manage Products section of the ACP, do you see an entry for the quiz mod?

Ok, so I figured out field 53 was left over from an old hack I had installed years ago, so I deleted it. Tried uploading the xml file again and got the following error - (it did not install):

Database error in vBulletin 4.1.3:

Invalid SQL:

INSERT INTO dbtech_vbquiz_category
(category_id, category_name, category_desc, parent, permissions, sort_order, active)
VALUES
(1, 'Default Category', 'This is the default OOB category', 0, 'a:2:{s:4:"view";a:5:{i:0;i:6;i:1;i:7;i:2;i:2;i:3;i:5;i:4;i:1;}s:6:"submit";a:4:{i:0;i:6;i:1;i:7;i:2;i:2;i:3;i:5;}}', 1, 1);

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062
Request Date : Saturday, April 16th 2011 @ 09:08:19 AM
Error Date : Saturday, April 16th 2011 @ 09:08:21 AM
Script : http:///forums/admincp/plugin.php?do=productimport
Referrer : http:///forums/admincp/plugin.php?do=productadd
IP Address : 24.63.105.213
Username : Rob
Classname : vB_Database_MySQLi
MySQL Version : 5.0.92-community

 

[RobAC]

Success! I had to go into the database and delete the tables which had installed when I previously tried to import the xml file.

 

[Dylan]

Sorry about the problems installing. I'll need to change the code to account for having to reinstall without throwing errors and stopping it.