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

Correctly encode default_dateformat when converting from phpBB2

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.x
    • Fix Version/s: 3.0.9-RC1
    • Component/s: phpBB 2.0 convertor
    • Labels:
      None

      Description

      Hi,

      I've experienced an issue converting the "default_dateformat" value.
      My value is set for French language, using a "à". The value is this one: "d M Y à H:i"
      And I got this error message when I launched the conversion...

      SQL ERROR [ mysql4 ]

      Incorrect string value: '\xE0 H:i' for column 'config_value' at row 1 [1366]

      SQL

      UPDATE phpbb_config SET config_value = 'd M Y � H:i' WHERE config_name = 'default_dateformat'

      BACKTRACE

      FILE: includes/db/mysql.php
      LINE: 158
      CALL: dbal_mysql->sql_error()

      FILE: includes/functions.php
      LINE: 148
      CALL: dbal_mysql->sql_query()

      FILE: includes/functions_convert.php
      LINE: 1288
      CALL: set_config()

      FILE: install/install_convert.php
      LINE: 987
      CALL: restore_config()

      FILE: install/install_convert.php
      LINE: 203
      CALL: install_convert->convert_data()

      FILE: install/index.php
      LINE: 402
      CALL: install_convert->main()

      FILE: install/index.php
      LINE: 274
      CALL: module->load()

      Obviously, I have temporarily change the phpBB 2 default value to skip this bug but it'll be nice to fix it
      Thanks!

        Activity

        Hide
        frisbeefreestyler frisbeefreestyler [X] (Inactive) added a comment -

        Had the same problem with hebrew...
        I fixed this by changing the "default_dateformat" field on phpbb_config table of the phpbb2.0.x database.

        Show
        frisbeefreestyler frisbeefreestyler [X] (Inactive) added a comment - Had the same problem with hebrew... I fixed this by changing the "default_dateformat" field on phpbb_config table of the phpbb2.0.x database.
        Hide
        D¡cky Richard Foote [X] (Inactive) added a comment -

        This can be fixed by encoding the phpBB2 default_dateformat

        Show
        D¡cky Richard Foote [X] (Inactive) added a comment - This can be fixed by encoding the phpBB2 default_dateformat
        Hide
        D¡cky Richard Foote [X] (Inactive) added a comment -

        Patch for default_dateformat

        Show
        D¡cky Richard Foote [X] (Inactive) added a comment - Patch for default_dateformat

          People

          • Assignee:
            bantu Andreas Fischer
            Reporter:
            -=ET=- -=ET=- [X] (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development