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:
Thanks
"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)"
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)"
Comment