vB3.8 to vB4.2.3 Upgrade DB Error

[JamesStPattrick]

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.

[motd2]

Use 4.2.4 RC2

[JamesStPattrick]

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?

[JamesStPattrick]

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