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

Emoji characters in forum name causing SQL errors

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2.0
    • Fix Version/s: 3.2.8-RC1
    • Component/s: ACP
    • Labels:
    • Environment:
      CentOS Linux release 7.3.1611, PHP 7.0.18, 5.5.52-MariaDB MariaDB Server

      Description

      In ACP->FORUMS->Edit forum and attempting to add an emoji to the forum name results in a GENERAL ERROR.

      SQL ERROR [ mysqli ]
       
      Incorrect string value: '\xF0\x9F\x92\x99' for column 'forum_name' at row 1 [1366]
       
      SQL
       
      UPDATE phpbb_forums SET parent_id = 1, forum_type = 1, forum_status = 0, forum_parents = '', forum_name = 'Your first forum (EMOJI removed because of Jira limitation) ', forum_link = '', forum_desc = '<r>Description of your first forum. <EMOJI seq=\"1f499\">&#128153;</EMOJI></r>', forum_desc_uid = '', forum_desc_options = 7, forum_desc_bitfield = '', forum_rules = '', forum_rules_uid = '', forum_rules_options = 7, forum_rules_bitfield = '', forum_rules_link = '', forum_image = '', forum_style = 0, display_subforum_list = 1, display_on_index = 1, forum_topics_per_page = 0, enable_indexing = 1, enable_icons = 1, enable_prune = 0, enable_shadow_prune = 0, prune_days = 0, prune_viewed = 0, prune_freq = 0, prune_shadow_days = 7, prune_shadow_freq = 1, forum_flags = 48 WHERE forum_id = 2
       
      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]/includes/acp/acp_forums.php
      LINE: 1363
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/includes/acp/acp_forums.php
      LINE: 199
      CALL: acp_forums->update_forum_data()
       
      FILE: [ROOT]/includes/functions_module.php
      LINE: 676
      CALL: acp_forums->main()
       
      FILE: [ROOT]/adm/index.php
      LINE: 82
      CALL: p_master->load_active()

        Attachments

          Activity

            People

            • Assignee:
              Marc Marc
              Reporter:
              P_I P_I
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: