Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-16535

Migration from phpBB 2.0.x broken with MySQL 8.x

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.3.0
    • Fix Version/s: 3.3.3-RC1
    • Component/s: phpBB 2.0 convertor
    • Labels:
    • Environment:
      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()

       

        Attachments

          Activity

            People

            Assignee:
            Marc Marc
            Reporter:
            cosmoschtroumpf cosmoschtroumpf
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: