Support Forum
Support Forum
Offline
Hi there,
I am wondering why a smiley that I write in the editor (tiny MCE) for a forum post:
turns into an unreadable character in the forum:
Warm regards,
Sebastian
Offline
Can you tell me what result you get when you try the same thing in a blog post on your website?
 |
YELLOW
SWORDFISH
|
Offline
It took me a while to get back to this.
Indeed, the whole website converts emoticons into squares.
That sucks!
Any idea why? I searched on Google but could not find the solution.
Offline
OK - so this is site wide and actually a WordPress issue as opposed to Simple:Press. SP passes those kind of keystrokes straight through to WordPress to resolve.
So I can only think of two possible reasons. The obvious one is that WP can not find images to resolve with. Check the url that is getting created in the display source code - that will give you a clue.
The other is that your tables have not been upgraded to MB4 encoding - needed for WP to display emoji's. WP will attempt to use the MB4 encoding when it creates tables at install or - if an older, established database, attempt to upgrade tables during an update.
My problem with that scenario, is that I was pretty sure WP had a fallback to emoticon/image files if the tables were not updated. And some people do have a problem updating their encodings if the mySQL version being used is older and does not give the support.
I believe I am right in thinking that you have a test site? If so - and of you have the same problem on that - you could try using our MB4 upgrade tool plugin (https://simple-press.com/downl.....4-encoder/) but this will only convert the SP tables. But you can inspect the DB tables to find out of course - which is probably quicker!
|
YELLOW
SWORDFISH
|
Offline
I checked the source code and all I found is a square in it, so no path to any image file.
This probably means there is an issue with the encoding of the database.
I am hesitant to make such profound change in the database because I have never done it and I am worried that it may cause issue with other data in the database. I more like a "button pusher" when it comes to MySQL. I can make dumps and stuff but I have no experience with changing the encoding on a running site.
Is it risky? Of course I would need to make a backup first, but is it risky that it could cause issues in the long run, when i change the encoding of the entire database?
We have a test site to experiment with, for sure.
Offline
i have not heard of anyone having a problem making this conversion. The big issue is whether the version of MySQL you are using is capable - I can not recall now which V5 version was the one that allowed for it.
But - am I not right in thinking you are hosted by WP Engine? If so they should be up to date and also up to date with the WP updates that ran this code on the whole DB.
To be perfectly honest with you - I think they would be the best people to speak to about this as it seems to me that this is essentially a WordPress issue as it happens in blog posts too. All the forum does is pass this straight through to WP filtering.
|
YELLOW
SWORDFISH
|
Offline
Thanks!
Your input it very valuable. I will talk to the WP Engine peops and let you know how it goes.
(non converted big smile)
Offline
Please do let us know what happens...
|
YELLOW
SWORDFISH
|
Offline
I just try to use the plugin but this is what I got
it seems all tables already have the "right" encoding?
What else can I do?
Offline
Did you ask the hosting support guys?
To be honest I don't have a detailed understanding of how WordPress does this. The emoji support was built in quite a while back. If I want to enter a standard 'smiley' then I can just use the colon+right-bracket and it gets converted to 🙂
I can also add an emoji from my browser (edit menu) like this - ? - but whether that is just on a Mac I do not know.
As this is not working across the board for you - and the first place to test would be a blog post - then I would assume something is interfering with that built in support. I still think you need to work this with your host or on the WP support forums I am afraid
|
YELLOW
SWORDFISH
|
All RSS