Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
3.3.0
-
PHP 7.4.1, MySQL 8.0.19, Windows 10/IIS
Description
While trying to migrate a phpBB 2.x forum to 3.3.0, the convertor gets "phpbb_xxx" tables and creates a query like "select x from phpbb_xxx xxx".
It crashes when it tries to read the phpbb_groups table, because "groups" is now a reserved keyword in MySQL 8
(see fix in comment)
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 D:\Perso\arcanum\phpbb-3.3.0\phpBB3\phpbb\db\driver\driver.php on line 1023 |
|
|
BACKTRACE
|
|
|
|
|
FILE: (not given by php)
|
LINE: (not given by php)
|
CALL: installer_msg_handler()
|
|
|
FILE: [ROOT]/phpbb/db/driver/driver.php
|
LINE: 1023 |
CALL: trigger_error()
|
|
|
FILE: [ROOT]/phpbb/db/driver/mysqli.php
|
LINE: 195 |
CALL: phpbb\db\driver\driver->sql_error()
|
|
|
FILE: [ROOT]/phpbb/db/driver/mysql_base.php
|
LINE: 45 |
CALL: phpbb\db\driver\mysqli->sql_query()
|
|
|
FILE: [ROOT]/phpbb/db/driver/driver.php
|
LINE: 296 |
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()
|
|
|
FILE: [ROOT]/install/convert/convertor.php
|
LINE: 692 |
CALL: phpbb\db\driver\driver->sql_query_limit()
|
|
|
FILE: [ROOT]/install/convert/controller/convertor.php
|
LINE: 370 |
CALL: phpbb\convert\convertor->convert_data()
|
|
|
FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
|
LINE: 151 |
CALL: phpbb\convert\controller\convertor->convert()
|
|
|
FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
|
LINE: 68 |
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()
|
|
|
FILE: [ROOT]/install/app.php
|
LINE: 61 |
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()
|