Announcement

Collapse
No announcement yet.

vB3.8 to vB4.2.3 Upgrade DB Error

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

  • JamesStPattrick
    started a topic [Forum] vB3.8 to vB4.2.3 Upgrade DB Error

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

    Leave a comment:


  • motd2
    replied
    Use 4.2.4 RC2

    Leave a comment:


  • JamesStPattrick
    replied
    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?

    Leave a comment:

Related Topics

Collapse

Working...
X