Skip to Content Skip to Menu

[SOLVED] emoticon crash messages

2 years 8 months ago - 2 years 8 months ago #328841 by dirtydavid
[SOLVED] emoticon crash messages was created by dirtydavid
Hi,
Has anyone else had issues where the use of emoticons has crashed messages between users?
Does anyone know how to resolve the issue?
David
Last edit: 2 years 8 months ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48584
  • Thanks: 8295
  • Karma: 1445
2 years 8 months ago #328842 by krileon
Replied by krileon on topic emoticon crash messages
Emoticons has crashed messages? Can you be more specific? I've no idea what that means.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

2 years 8 months ago #328843 by dirtydavid
Replied by dirtydavid on topic emoticon crash messages
Hi

If a user puts an emoticon in their message to another user in Community Manager they get an error and the message is not sent

For example, the message below:
[hr]
testing emoticons

😋

test
[hr]

Causes the message system to crash with an error:

If difficulties persist, please contact the website administrator and report the error below.

1366 Incorrect string value: '\xF0\x9F\x98\x8B" ...' for column 'message' at row 1

I thought at first it was user error, but I have now tested it myself and I get the same error.

Regards
David

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48584
  • Thanks: 8295
  • Karma: 1445
2 years 8 months ago #328852 by krileon
Replied by krileon on topic emoticon crash messages
That's a problem with your database and not CB (confirmed emoji are working fine). Your database collation is wrong and not supporting unicode characters. Ensure your entire database, the tables in it, and the columns in those tables is set to utf8mb4_unicode_ci. phpmyadmin provides a tool for mass-applying this change under the Operations tab (scroll to Collation at the bottom and check both checkboxes then press Go), but please make a full database backup before you do this.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: dirtydavid

Please Log in or Create an account to join the conversation.

2 years 8 months ago #328854 by dirtydavid
Replied by dirtydavid on topic emoticon crash messages
Thanks for the information.
I ran the fix and the emoticons are now working fine.
Thanks Vey much
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum