Error in the upgrade procedure vb2.3.0 to vb3 RC3

[TheLab]

I get this at the 9 step:


Step 9) Alter User Table (part 2)

Altering User Table (1 of 5)
Altering User Table (2 of 5)
Altering User Table (3 of 5)
Altering User Table (4 of 5)
Altering User Table (5 of 5)
Converting Birthdays to New Format
Inserting administrator permissions into Administrator table


There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


and the source says:

Database error in vBulletin :

Invalid SQL:
INSERT INTO administrator (userid, adminpermissions)
SELECT user.userid, 65532
FROM user INNER JOIN usergroup USING(usergroupid)
WHERE usergroup.cancontrolpanel = 1

mysql error: Duplicate entry '1' for key 1

mysql error number: 1062

Date: Monday 02nd of February 2004 11:38:42 AM
Script: http://localhost/install/upgrade1.php?step=9
Referer: http://localhost/install/upgrade1.php?step=8
IP Address: 127.0.0.1
-->


What should i do?

[allan grossman]

I'd head over to

http://www.vbulletin.com/forum/forumdisplay.php?f=59

and ask the question there. That's the vB3 troubleshooting forum ;)

I've upgraded vB 2.3.0 boards to RC3 several times. The first time I had an error at step 16, but after repairing the database and running most all the maintenance options in the admin cp the next attempt worked without an error.

Also, vBulletin released a tool to see if your database was compatible with vB3 - it might be worth running ;)

YMMV, but I'd repair the database, and run all the appropriate maintenance options through vB's admin cp. A clean database is liable to convert a little easier ;)

[TheLab]

Before i upgrade, had already run the maintenance scripts so it must be something else.

Thanx anyway :)