-
Bug
-
Resolution: Fixed
-
Major
-
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()
|
- caused
-
PHPBB-16582 SQL error when saving profile with empty custom field of type "Numbers"
- Closed