Advertisement:

Author Topic: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax  (Read 2124 times)

Offline Jarppi

  • Semi-Newbie
  • *
  • Posts: 26
Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
« 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

Offline shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 2,075
    • sbulen on GitHub
Re: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
« Reply #1 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
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Jarppi

  • Semi-Newbie
  • *
  • Posts: 26
Re: Upgrade 1.1.21 -> 2.0.15 error in your SQL syntax
« Reply #2 on: September 09, 2019, 12:06:52 PM »
Kiitos! Thank you very much!
Problem solved.