Simple Machines Community Forum

SMF Support => Language Specific Support => Suomenkielinen tuki (Finnish) => Topic started by: Jarppi on September 09, 2019, 01:22:43 AM

Title: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
Post by: Jarppi on September 09, 2019, 01:22:43 AM
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
Title: Re: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
Post by: shawnb61 on September 09, 2019, 01:26:09 AM

Quote
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
Title: Re: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
Post by: Jarppi on September 09, 2019, 12:06:52 PM
Kiitos! Thank you very much!
Problem solved.