Hello,
Trying to complete upgrade from 1.1.21 -> 2.0.15 and I get this:
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 'WHERE id_board IN (1,34)' at line 3
Any fix for this?
PHP Version 7.2.21
MySQL Version 5.7.27
My first theory is that you somehow got a null value as a $profile.
In the file upgrade_2-0.sql, ~line 1776, change:
// Update the board tables.
foreach ($board_updates as $profile => $boards)
{
if (empty($boards))
continue;
$boards = implode(',', $boards);
To:
// Update the board tables.
foreach ($board_updates as $profile => $boards)
{
if (empty($boards) || empty($profile))
continue;
$boards = implode(',', $boards);
& let us know if this works!
*** Note php 7.2 is not officially supported at this time for 2.0.x. If you can go back to 7.1 you should do so. ***
Awesome! That did the trick!
Thank you!
Good to know. I'm not sure what settings in 1.1 resulted in this condition, so I recommend auditing your boards & permissions closely after the upgrade.
I'm flagging this as resolved.