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

General error (SQL ERROR) on adding emoji character to the profile field

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.3.0, 3.2.10-RC2
    • Fix Version/s: 3.3.1, 3.2.10
    • Labels:
      None
    • Environment:
      Database server: MySQL(i) 5.7.9-log
      PHP version: 7.4.1

      Description

      Adding emoji to the profile field with "Any character" validation type (.*) causes SQL error, f.e. for "Location" field:

      General ErrorSQL ERROR [ mysqli ]
       
      Incorrect string value: '\xF0\x9F\x91\xA8\xE2\x80...' for column 'pf_phpbb_location' at row 1 [1366]
       
      SQL
       
      UPDATE phpbb_profile_fields_data SET pf_phpbb_location = '[EMOJI_UNSUPPORTED_BY_JIRA_SO_A_PLACEHOLDER_IS_HERE]', pf_phpbb_website = '', pf_phpbb_facebook = '', pf_phpbb_twitter = '', pf_phpbb_skype = '', pf_phpbb_youtube = '', pf_phpbb_googleplus = '', pf_phpbb_telegram = '' WHERE user_id = 2
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 1023
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 195
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 345
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/phpbb/profilefields/manager.php
      LINE: 241
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/includes/ucp/ucp_profile.php
      LINE: 407
      CALL: phpbb\profilefields\manager->update_profile_field_data()
       
      FILE: [ROOT]/includes/functions_module.php
      LINE: 676
      CALL: ucp_profile->main()
       
      FILE: [ROOT]/ucp.php
      LINE: 438
      CALL: p_master->load_active()
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: