WordPress.org

Make WordPress Core

Opened 3 years ago

Last modified 10 months ago

#38286 closed defect (bug)

Lost emojis — at Version 11

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

Description (last modified by desrosj)

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

Change History (12)

#1 follow-up: @superpoincare
3 years 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
3 years 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
3 years 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
3 years 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 3 years ago by ramonjosegn (previous) (diff)

#5 follow-up: @superpoincare
3 years ago

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

[30345]

Last edited 3 years ago by SergeyBiryukov (previous) (diff)

#6 in reply to: ↑ 5 @ramonjosegn
3 years 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
3 years 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
3 years 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
3 years 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
3 years 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

#11 @desrosj
13 months ago

  • Description modified (diff)
  • Keywords close added

Hi @ramonjosegn,

My apologies that this ticket was overlooked!

Are you still experiencing this issue? I am going to mark this as close, but please do supply more details if you can.

Note: See TracTickets for help on using tickets.