Template breakes when using smileys amd message not sent in PM

As the title says.

My template breaks when you try to send a message with a smiley in it. If there is no use of smiley, the message gets sent just fine.

Please give me an email so I can give you login credentials and have a look. 

I am fairly certain you need access to my control panel for this fix, so I give full access as a superuser, control panel, and FTP. 

PS: I love your work. Amazing.

UPDATE:
I just realized that when you register, the cropping function does not work as intended when you upload the profile photo. It works as intended when you are already a member and update the photo. Maybe have a quick look as I cannot figure out why it is so myself. 

That is the only two issues I have. Fantastic work, guys. Keep it up.

Aksel 

It's not necessarily a Private Message System issue, but that your database doesn't support unicode so that's why standard emoji can't save. Try running CBs database fix tools in CB > Tools to see if it can fix your database collations, which tries to match whatever Joomla's is set to.

If that doesn't fix it you'll need to use phpMyAdmin then under the Operations tab use the Collation tool to change your database and its tables collations to utf8mb4_unicode_ci. Specifically the following.

Collation: utf8mb4_unicode_ci
Change all tables collations: CHECKED
Change all tables columns collations: CHECKED

I just realized that when you register, the cropping function does not work as intended when you upload the profile photo. It works as intended when you are already a member and update the photo. Maybe have a quick look as I cannot figure out why it is so myself.

Please create a separate topic detailing your issue.

Hi.
Please keep this thread open for a little while.

My host was not interested in helping out with an issue I got when trying to check the two boxes:
Change all tables collations: CHECKED
Change all tables, columns collations: CHECKED
It says:MySQL said:

You can try just applying it to the _comprofiler_plugin_messages table where messages are stored. To do this navigate into your database using phpMyAdmin, click on the _comprofiler_plugin_messages table, then click the Operations tab and adjust the following.

Table options
Collation: utf8mb4_unicode_ci
Change all column collations: CHECKED

This will cause mixed collations in your database though so it's not ideal only fixing 1 table. What table gave you the key length error as typically you'd just fix that tables indexes and then you'll be able to go back to applying this to every table.

Change all tables columns collations: CHECKED
This one is the one that gave me the error.

I looked over in PhPMyadmin and it was some utf4 and mostly utf3 for some reason. I mean, the freelancers working on this a few years back must have been reeaaaly a good hire😂. It was before I was going to run the site, as I had just played around with it for years before I moved to the Philippines, and now we will run it as soon as all is done.

I have gotten most of the site cleaned up and all start to look good, but databases I have zero knowledge about.

I did what you said. or, I took all the utf3 ones and updated to utf4. I ran the Change all column collations: CHECKED and now, my joomla and my jchat can use smiley.

The website still works, but I have no idea what I just did.😁

I did backup, though.

Thanks a lot. I will correct it and have it done properly; I just need to learn how to do it first. At least it works for now. Somehow...

You guys rock. Great help.

Also, lesson learned. It is better to do it myself, and if I run into a problem I do not know how to fix, I learn how to fix it.