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
QuoteIn 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
Kiitos! Thank you very much!
Problem solved.