WordPress.org

Make WordPress Core

Opened 21 months ago

Last modified 20 months ago

#38286 new defect (bug)

Lost emojis

Reported by: ramonjosegn Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 4.6.1
Component: Emoji Keywords:
Focuses: Cc:

Description

Hi dears

I was working in my website with WordPress and suddenly I lost all my emoji, were replaced with the symbols = ????

A friend who works with WordPress also told me the same thing happened recently for no reason apparent

I think it can be a serious failure in Wordpress, appreciate it if you revise

Thanks

Attachments (1)

emojis-bug.jpg (171.0 KB) - added by ramonjosegn 21 months ago.

Download all attachments as: .zip

Change History (11)

#1 follow-up: @superpoincare
21 months ago

I think it's difficult to find what the issue is without the link to your site.

Could you provide it?

#2 in reply to: ↑ 1 @ramonjosegn
21 months ago

Replying to superpoincare:

I think it's difficult to find what the issue is without the link to your site.

Could you provide it?

Of course, my website its mirutafacil.com

Thanks for looking

#3 follow-up: @superpoincare
21 months ago

Looks like there is no issue in the front end. If I add new nodes using emoji using Chrome's developer's tools, it displays them fine. So it's possible that between your publishing anything and sending it to the database or reading from the database has some issue.

In your post editor, do the emoji display fine?

#4 in reply to: ↑ 3 @ramonjosegn
21 months ago

Replying to superpoincare:

Looks like there is no issue in the front end. If I add new nodes using emoji using Chrome's developer's tools, it displays them fine. So it's possible that between your publishing anything and sending it to the database or reading from the database has some issue.

In your post editor, do the emoji display fine?

I think for some reason lost in database (possibly), I can add news emojis and can look and display fine, but the old are lost...

Last edited 21 months ago by ramonjosegn (previous) (diff)

#5 follow-up: @superpoincare
21 months ago

I could find one ticket discussing this issue (old one)

[30345]

Last edited 21 months ago by SergeyBiryukov (previous) (diff)

#6 in reply to: ↑ 5 @ramonjosegn
21 months ago

Replying to superpoincare:

I could find one ticket discussing this issue (old one)

https://core.trac.wordpress.org/changeset/30345

Thanks, but is there any solution?

#7 follow-up: @superpoincare
21 months ago

Don't know if there's any solution. When did you input those emoji - were you using any plugin or something?

#8 in reply to: ↑ 7 @ramonjosegn
21 months ago

Replying to superpoincare:

Don't know if there's any solution. When did you input those emoji - were you using any plugin or something?

Hi

Not, I am only copy and paste, working fine for two years... but now I have this problem.

#9 follow-up: @dd32
20 months ago

Hi,

Can you please let us know what version of MySQL/MariaDB/etc you're using, the PHP version, and the Database collation that's currently set (Check the database schema via phpmyadmin or similar and it should say something like utf8_general_ci or utf8mb4_general_ci). Did any of that change recently to your knowledge (upgraded MySQL, host migration, etc)

This sounds like some kind of incompatibility between WordPress, MySQL and character encodings, like the older emoji's were encoded in the database differently to the newly added ones.

#10 in reply to: ↑ 9 @ramonjosegn
20 months ago

Replying to dd32:

Hi,

Can you please let us know what version of MySQL/MariaDB/etc you're using, the PHP version, and the Database collation that's currently set (Check the database schema via phpmyadmin or similar and it should say something like utf8_general_ci or utf8mb4_general_ci). Did any of that change recently to your knowledge (upgraded MySQL, host migration, etc)

This sounds like some kind of incompatibility between WordPress, MySQL and character encodings, like the older emoji's were encoded in the database differently to the newly added ones.

Hi, I know was a update in the cPanel and a few days after migrate the site.

But the problem if happened before the migration

Now the cPanel is using Versión MySQL 10.0.27-MariaDB

Thanks for support

Note: See TracTickets for help on using tickets.