Topic: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax

[Jarppi]

Terve,

SMF päivitys 1.1.21 -> 2.0.15 menossa ja päivitys tökkää MySQL virheeseen:

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 log_floodcontrol CHANGE COLUMN ip ip char(16) NOT NULL default ' ' at line 1

Oiskos tälle joku fixi olemassa?

PHP Version   7.2.21
MySQL Version   5.7.27

[shawnb61]

In your forum root folder right now there should be a file named "upgrade_1-1.sql".

Open that file up and change all instances of "ALTER IGNORE TABLE" to "ALTER TABLE".   There should be 6 of them.

Hope this helps.

https://www.simplemachines.org/community/index.php?topic=569542.msg4030480#msg4030480

[Jarppi]

Kiitos! Thank you very much!
Problem solved.