Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    "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

  • #2
    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

    Comment

    Working...
    X