Announcement

Collapse
No announcement yet.

vB3.8 to vB4.2.3 Upgrade DB Error

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

  • [Forum] vB3.8 to vB4.2.3 Upgrade DB Error

    When I try to upgrade my vB3.8.9 PL1 to vB4.2.3 PL2 I get the following SQL error upon starting the upgrade process:

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

    Module: 400a1, Step 8 Database Error:1064

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE vb_reputation ADD UNIQUE INDEX whoadded_postid (whoadded, postid)' at line 2

    Query:
    ALTER IGNORE TABLE vb_reputation ADD UNIQUE INDEX whoadded_postid (whoadded, postid)"
    Thanks

  • #2
    Here is some information:
    PHP Version: 5.6.28
    MySQL Version: 5.7.16

    I have also set:
    $config['Database']['force_sql_mode']
    to true and false both but still results in the same error.

    Doing my own research I came upon this:
    As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.
    (but since I am using 5.7.1x it shouldn't matter)

    Any idea?

    Comment


    • #3
      Use 4.2.4 RC2

      Comment


      • #4
        I fixed this issue by removing all IGNORE statements from the SQL queries carried out by the vBulletin upgrade/install system.
        For those with same issue, modify all files in : install/includes/ that have ALTER IGNORE TABLE to ALTER TABLE.

        Enjoy this fix.

        Comment

        Related Topics

        Collapse

        Working...
        X