-
Bug
-
Resolution: Fixed
-
Major
-
3.2.2
-
None
-
PHP 7.1.16 - MySQL(i) 10.1.30-MariaDB - FF 61.0.1 (64-bit) and MS Edge 42.17134.1.0
Inserting an emoji in a PM subject field causes errors, it only happens when you submit, preview is ok. Normal smilies work as expected by not allowing a smilie to go in the subject line.
At phpbb.com I get:
General Error
|
SQL ERROR [ mysqli ]
|
|
Incorrect string value: '\xF0\x9F\x87\xA9\xF0\x9F...' for column 'message_subject' at row 1 [1366] |
|
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists. |
On my test board I see:
General Error
|
SQL ERROR [ mysqli ]
|
|
Incorrect string value: '\xF0\x9F\x98\x8E' for column 'message_subject' at row 1 [1366] |
|
SQL
|
|
INSERT INTO phpbb_privmsgs (root_level, author_id, icon_id, author_ip, message_time, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, message_subject, message_text, message_attachment, bbcode_bitfield, bbcode_uid, to_address, bcc_address, message_reported) VALUES (0, '2', 0, '2a00:23c5:5302:8500:8c10:d8dc:20d:29f6', 1530174101, 1, 1, 1, 1, '', '<t>Test</t>', 0, '', '271uu31s', 'u_2', '', 0) |
|
BACKTRACE
|
|
FILE: (not given by php)
|
LINE: (not given by php)
|
CALL: msg_handler()
|
|
FILE: [ROOT]/phpbb/db/driver/driver.php
|
LINE: 996 |
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/functions_privmsgs.php
|
LINE: 1771 |
CALL: phpbb\db\driver\factory->sql_query()
|
|
FILE: [ROOT]/includes/ucp/ucp_pm_compose.php
|
LINE: 858 |
CALL: submit_pm()
|
|
FILE: [ROOT]/includes/ucp/ucp_pm.php
|
LINE: 108 |
CALL: compose_pm()
|
|
FILE: [ROOT]/includes/functions_module.php
|
LINE: 676 |
CALL: ucp_pm->main()
|
|
FILE: [ROOT]/ucp.php
|
LINE: 394 |
CALL: p_master->load_active()
|
I've only tested this with 3.2.2.
- is duplicated by
-
PHPBB-15299 Characters with more than 3 bytes in its default UTF-8
- Closed
-
PHPBB-16459 Emoji Parsing in PM Subject
- Closed
-
PHPBB-16317 Emoji in PM subject line error
- Closed
-
PHPBB-16318 Adding an emoji to the subject line in PM causes an error.
- Closed
-
PHPBB-16322 Emoji in PM subject line error
- Closed
- is related to
-
PHPBB-15299 Characters with more than 3 bytes in its default UTF-8
- Closed
-
PHPBB-16985 MYSQLi bug - Incorrect string value: '\xF0\x9F\x8E\x89\xF0\x9F...' for column `phpbb`.`phpbb_privmsgs`.`message_subject`
- Patch Awaiting Review