i want to upgrade from 3.1.9 to newest version 3.2.12 because 3.1.9 seems to be incompatible with php 5.6 and above.
But when i install the package i get the error:
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 #__eflp_profiles ADD COLUMN unpublishedlisting tinyint(3) un’ at line 1 SQL=ALTER IGNORE TABLE #__eflp_profiles ADD COLUMN unpublishedlisting tinyint(3) unsigned NOT NULL DEFAULT ‘1’ AFTER method
@ereil. Thanks for that info. I checked the MySQL documentation and I think the issue is that the “IGNORE” syntax was removed in MySQL version 5.7. So, I will have to upgrade the extension and remove that from the code. I should have a new release with the fix some time today or tomorrow.
Viewing 4 posts - 1 through 4 (of 4 total)
The topic ‘SQL Syntax error when upgrading from 3.1.9 to 3.2.12’ is closed to new replies.