Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-9637

SET NAMES 'BINARY' error in convertor

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.0.8-RC1
    • 3.0.7-PL1
    • None
    • Destination database MySQL >= 4.1.3
      Source database MySQL 3.23 or 4.0

      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.

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

              Created:
              Updated:
              Resolved: