Announcement

Collapse
No announcement yet.

Contact Support

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

  • Contact Support

    I am now going on day 3 of trying to upgrade from vb4.2 to vb5 and woke up this morning to the following error:

    ACTION REQUIRED

    An erro has occured 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)

    Please advise, thanks!

  • #2
    Finally got the search engine here to return results and found the answer to fix...

    Comment


    • #3
      Originally posted by SatelliteGuys View Post
      I am now going on day 3 of trying to upgrade from vb4.2 to vb5 and woke up this morning to the following error: ACTION REQUIRED An erro has occured 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) Please advise, thanks!
      I have this problem. Can you tell me how you fixed it? Perhaps direct me to the link that you found? Thanks!

      Comment


      • #4
        As per your ticket, this comes from orphaned infraction records in your database.

        To solve, go to your database via phpMyAdmin and run the following query (make sure you have a backup before doing this):

        DELETE FROM infraction WHERE nodeid = 0;

        Then refresh the upgrade script
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        -
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - "Quick Route" Interface...

        Comment

        Related Topics

        Collapse

        Working...
        X