Forum 4.0 Gold Upgrade Causes DB Error -- Take #2
 

All right folks* I tried to upgrade a 3.8.4p1 forum* with very few mods* to vB 4.0 Gold.

I have a colleague standing by to help me redo our css and template changes.

I backed up everything* disabled all products.

During the upgrade assistant* I got stuck on Step 3:

Quote:
Database error in vBulletin 3.8.4:

Invalid SQL:
INSERT INTO tagcontent
(tagid* contenttypeid* contentid* userid* dateline)
SELECT tagid* 2* threadid* userid* dateline
FROM tagthread;

MySQL Error : Duplicate entry '62-2-17' for key 1
Error Number : 1062
Request Date : Tuesday* December 22nd 2009 @ 10:27:09 AM
Error Date : Tuesday* December 22nd 2009 @ 10:27:09 AM
Script : http://www.rockoids.com/forum/instal...0a1.php?step=3
Referrer : http://www.rockoids.com/forum/instal...0a1.php?step=2
IP Address : 68.3.100.119
Username :
Classname : vB_Database
MySQL Version : 5.0.87-community

I ran the tools.php file and attempted to repair the tagcontent table* with no change.

I'm not a MySQL wizard* but if anyone can walk me through a fix via query or any other method* let me know.

We're at a stopping point* but at least this is our least-trafficked board* so it makes little difference if it's offline a few hours.

Peace*
Gene Steinberg