NamelessMC

Internet Explorer

Internet Explorer is not supported. Please upgrade to a more modern browser.

Bug Problem with posting emoticons in Forum
Started by Flyprinc

Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5

Hello,

That happened when my friend made a topic, so I did reply him with emoticons, text works perfectly but emoticons disappeared.

I tried to check the files about emoticons, I think I have all files for that. Maybe I broke up while converting utf-8 files for czech language... Any ideas?

Thanks for help.

My web: aphelion.cz

Flyprinc · over 4 years ago · Last edited: over 4 years ago
Samerton

Samerton

Owner
Joined
30 Mar 2015
Last Seen
29 Mar 2024
Topics
41
Posts
1042

I'm afraid I'm not sure what's going on, do you have a link to the topic which has the problem?

Samerton · over 4 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5

http://aphelion.cz/index.php?route=/forum/topic/11-prikaz-admin/

I mean I tried to reply a message with emoticons but emoticons gone after entering the reply.

Flyprinc · over 4 years ago · Last edited: over 4 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5

I tried change language code in MySQL nl2_posts - post_content from utf8_czech_ci to latin1_swedish_ci and emoticons changes to "???"... So I have no idea how to fix it.

Flyprinc · over 4 years ago · Last edited: over 4 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5

I tried different emojis like U2600 emojis, it already works. Unicode emojis are problem show up...

I tested in MySQL, if I change post_content value with emojis which I copied from unicode table. It shows:
Warning: #1366 Incorrect string value: '\xF0\x9F\xA4\xA5&l...' for column 'post_content' at row 1

Flyprinc · over 4 years ago · Last edited: over 4 years ago
Samerton

Samerton

Owner
Joined
30 Mar 2015
Last Seen
29 Mar 2024
Topics
41
Posts
1042

Try utf8mb4 for the database instead of latin1_swedish_ci; utf8mb4 has emoji support.

Samerton · over 4 years ago
Flyprinc

Flyprinc

Member
Joined
19 May 2019
Last Seen
23 Jun 2019
Topics
1
Posts
5

Still not working, again changes to "????"...

Screen of MySQL: https://ctrlv.cz/1Qxs

Maybe I figured out, only one thing I can disable emoticon list from tinymce editor... Maybe the hosting has probably bad mysql version or something which I can't understand this problem.

Flyprinc · over 4 years ago · Last edited: over 4 years ago