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

MySql Error when saving draft with Emoji

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.2.0
    • Fix Version/s: 3.2.1-RC1
    • Component/s: Posting
    • Labels:
    • Environment:
      PHP 7.1.0RC1, MySQL 5.5.53-0+, Firefox 50.1.0

      Description

      phpBB crash when I save a draft with Emoji

      {{Erreur générale
      SQL ERROR [ mysqli ]

      Incorrect string value: '\xF0\x9F\x98\x98' for column 'draft_message' at row 1 [1366]

      SQL

      INSERT INTO phpbb_drafts (user_id, topic_id, forum_id, save_time, draft_subject, draft_message) VALUES (5, 3315, 38, 1485367106, 'Re: ', 'The Emoji but removed because of Jira limitation')

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 999
      CALL: trigger_error()

      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 193
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()

      FILE: [ROOT]/posting.php
      LINE: 705
      CALL: phpbb\db\driver\factory->sql_query()}}

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Marc Marc
                Reporter:
                Aurelienazerty Aurelienazerty
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: