Bug Installation errors [mysql errors duplicate entries] cannot install

[sendur]

Hi,

When trying to install i'm getting mysql errors...
At first try i've tried to install with upload xml + overwrite settings, but that gave me a blank screen.
So i went ahead with installing xml from server + overwrite settings. Installation now goed wrong on multiple duplicate entries:

First:

Database error in vBulletin 4.2.2:

Invalid SQL:

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

MySQL Error   : Duplicate entry 'DBTechClassifieds' for key 'class'
Error Number  : 1062

I've fixed that by running: DELETE FROM vbb_package WHERE packageid = 4;

But now at the next installation tryout i'm getting:

Invalid SQL:

INSERT INTO `vbb_dbtech_classifieds_bidincrement` (`bidincrementid`, `value`, `minrange`, `maxrange`, `currencyid`) VALUES
(1, 0.05, 0.01, 0.99, 1),
(2, 0.2, 1, 4.99, 1),
(3, 0.5, 5, 14.99, 1),
(4, 1, 15, 59.99, 1),
(5, 2, 60, 149.99, 1),
(6, 5, 150, 299.99, 1),
(7, 10, 300, 599.99, 1),
(8, 20, 600, 1499.99, 1),
(9, 50, 1500, 2999.99, 1),
(10, 100, 3000, -1, 1);;

MySQL Error   : Duplicate entry '1' for key 'PRIMARY'
Error Number  : 1062

I don't want to keep fixing tables, please advice.

 

[sendur]

Deleted that table (and had to delete vbb_package id (increment?) also again. Step goed further, but now error in the next table:

Invalid SQL:

INSERT INTO `vbb_dbtech_classifieds_condition` (`conditionid`, `title`, `description`, `active`) VALUES
(1, 'New', '', 1),
(2, 'Used', '', 1);;

MySQL Error   : Duplicate entry '1' for key 'PRIMARY'
Error Number  : 1062

 

[Mokonzi]

I'll PM you with a file and some instructions on how to run the uninstall code in this unusual situation.

How long did the screen hang before you tried reinstalling?

 

[sendur]

I'll PM you with a file and some instructions on how to run the uninstall code in this unusual situation.

How long did the screen hang before you tried reinstalling?

Hi,

Approx 1 minute... In mysql i can see that multiple tables have been created, that's where it goes wrong, the installer cannot recreate or overwrite them i quess.

 

[Mokonzi]

Issue closed. Seems we had issue with the upload of the XML and possibly server config... but we managed to get the install sorted.