vB3.8 to vB4.2.3 Upgrade DB Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JamesStPattrick
    New Member
    • Oct 2016
    • 11

    [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
  • JamesStPattrick
    New Member
    • Oct 2016
    • 11

    #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

    • motd2
      Member
      • Jun 2010
      • 49
      • 3.8.x

      #3
      Use 4.2.4 RC2

      Comment

      • JamesStPattrick
        New Member
        • Oct 2016
        • 11

        #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...