Hi there,
I'm trying to migrate my phpbb database to the current version of phpbb with the install converter. It gives me an SQL error as follows:
SQL ERROR [ mysqli ]
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 'groups\x0AWHERE (groups.group_single_user = 0)\x0A LIMIT 2000' at line 2 [1064]
SQL
SELECT groups.group_id, groups.group_type, groups.group_name, groups.group_description FROM phpbb_groups groups WHERE (groups.group_single_user = 0) LIMIT 2000
in file C:\marsh\shga_website\forum\phpBB3\phpbb\db\driver\driver.php on line 997
As it turns out, 'groups' is a protected keyword in mysql 8.0... joy.
Any way I can get around this problem with a quick edit to the installer code? I took a brief look and didn't see anything obvious to change.
(replying to my own post to help out anyone else who is having similar problems)
I decided that the best course of action would be to downgrade to MySQL version 5.7 and convert again, since 5.7 will not be end of lifed until 2020. This fixed the problem and the conversion was a breeze.