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

SET NAMES 'BINARY' error in convertor

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.7-PL1
    • Fix Version/s: 3.0.8-RC1
    • Labels:
      None
    • Environment:
      Destination database MySQL >= 4.1.3
      Source database MySQL 3.23 or 4.0

      Description

      The error occurs when converting from a database version < 4.1.3 to a database version >= 4.1.3. The resulting error is one of the two listed here:

      General Error
      SQL ERROR [ mysql4 ]
       
      Unknown system variable 'NAMES' [1193]
       
      SQL
       
      SET NAMES 'binary'

      SQL ERROR [ mysql4 ]
       
      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 'NAMES 'binary'' at line 1 [1064]
       
      SQL
       
      SET NAMES 'binary'

      The backtrace in both of these errors points to line 707 of install/install_convert.php.

      The problem is that function sql_server_info in mysql.php is returning the version of the destination database instead of the source database.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                A_Jelly_Doughnut A_Jelly_Doughnut
                Reporter:
                D¡cky Richard Foote [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: