Upgrade from 4.2.5 to 5.4.2 aborts due to duplicate entry..

[vmats]

"Step 3 - Altering moderator Table (1 of 3)

• Altering moderator Table (2 of 3)
• An error has occurred with your database. Please contact vBulletin Support for assistance.
  
  Module: 505rc1, Step 4 Database Error:-1
  
  Duplicate entry '1297-0' for key 'userid_nodeid'
  
  Query:
  ### vBulletin Database Alter ### ALTER TABLE vb_moderator ADD UNIQUE INDEX userid_nodeid (userid,nodeid)"
  
  Anything I can do? Starting to think that I need to pay for the installation Thanks, Mats

[vmats]

Ok, found the problem. I had a number of duplicate entries in the db table vb_moderator. Just deleted the copies and kept the first id of each. We'll see if that was smart, anyway the installation continued now. -m