Announcement

Collapse
No announcement yet.

Error during upgrade to 5.01 - Primary key in table infraction

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

  • Error during upgrade to 5.01 - Primary key in table infraction



    This is the error message I received:

    An error has occurred with your database. Please contact vBulletin Support for assistance.


    Module: 501a2, Step 28 Database Error:1062


    Duplicate entry '0' for key 'PRIMARY'


    Query:



    ALTER TABLE infraction ADD PRIMARY KEY (nodeid)

  • #2
    I had to wipe the infraction table to continue, as half of them had noteid = 0.

    Comment


    • #3
      Probably would have been best for you to start a support ticket so we could have looked at it.

      Comment


      • #4
        Same problem here. Solution:

        Code:
        DELETE FROM infraction WHERE nodeid = 0;

        Comment


        • #5
          Support ticket here: http://tracker.vbulletin.com/browse/VBV-9019

          Comment

          Related Topics

          Collapse

          Working...
          X