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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.3.1, 3.2.10
    • 3.3.0, 3.2.10-RC2
    • None
    • Database server: MySQL(i) 5.7.9-log
      PHP version: 7.4.1

      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()
      

            Marc Marc
            rxu rxu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: