Announcement

Collapse
No announcement yet.

vb2 to vb3

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

  • vb2 to vb3

    hi

    when i try to ubgrad vb2 to vb3 this error come to me in step 6

    ////
    Database error in vBulletin :

    Invalid SQL: ALTER TABLE user
    ADD pmtotal SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
    ADD pmunread SMALLINT UNSIGNED DEFAULT 0 NOT NULL
    mysql error: Duplicate column name 'pmunread'

    mysql error number: 1060

    /////

    how can i fix it

  • #2
    you've installed a hack in vB2 which has broken the upgrade.

    Did you run the database conflicts script mentioned http://www.vbulletin.com/forum/showthread.php?t=73163

    if not revert back to your vB2 backup and run that script on a vB2 set of files prior to attempting another upgrade.
    Scott MacVicar

    My Blog | Twitter

    Comment


    • #3
      Originally posted by Scott MacVicar
      you've installed a hack in vB2 which has broken the upgrade.

      Did you run the database conflicts script mentioned http://www.vbulletin.com/forum/showthread.php?t=73163

      if not revert back to your vB2 backup and run that script on a vB2 set of files prior to attempting another upgrade.

      Table Conflicts
      No Table Conflicts

      Column Conflicts
      user
      Column Conflict for pmunread

      what i shoud to do now

      Comment


      • #4
        you'll need to remove the pmunread column prior to your vB3 upgrade.

        You can do this via phpMyAdmin.
        Scott MacVicar

        My Blog | Twitter

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X