Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax

Started by Jarppi, September 09, 2019, 01:22:43 AM

Previous topic - Next topic

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


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
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Jarppi


Advertisement: