You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Some emoji's get rendered to the review frontend like ?. Worse yet, if I include those emoji's as an annotation and POST them it crashes the server with:
[error] there may now be a database missmatch between the original table and the unique table
/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Parser.js:80
throw err; // Rethrow non-MySQL errors
^
Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xF0\x9F\x94\xA5Bi...' for column 'annotation' at row 1
at Query.Sequence._packetToError (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
at Query.ErrorPacket (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
at Protocol._parsePacket (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Protocol.js:279:23)
at Parser.write (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Parser.js:76:12)
at Protocol.write (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket.<anonymous> (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/Connection.js:103:28)
at emitOne (events.js:116:13)
at Socket.emit (events.js:211:7)
at addChunk (_stream_readable.js:263:12)
at readableAddChunk (_stream_readable.js:250:11)
--------------------
at Protocol._enqueue (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Protocol.js:145:48)
at PoolConnection.query (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/Connection.js:208:25)
at dbPool.getConnection (/media/bbpwn2/emerge_drive/mftm-backend/server.js:208:14)
at Ping.onOperationComplete [as _callback] (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/Pool.js:110:5)
at Ping.Sequence.end (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/sequences/Sequence.js:88:24)
at Ping.Sequence.OkPacket (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/sequences/Sequence.js:97:8)
at Protocol._parsePacket (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Protocol.js:279:23)
at Parser.write (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Parser.js:76:12)
at Protocol.write (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket.<anonymous> (/media/bbpwn2/emerge_drive/mftm-backend/node_modules/mysql/lib/Connection.js:103:28)
The text was updated successfully, but these errors were encountered:
brannondorsey
changed the title
Database not handling some emojis properly 🔥
Database not handling some emojis properly 🔥
Mar 21, 2018
Some emoji's get rendered to the review frontend like
?
. Worse yet, if I include those emoji's as an annotation and POST them it crashes the server with:The text was updated successfully, but these errors were encountered: