help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

mysql error

Re: mysql error

11 months 3 hours ago
#31567
It seems it will not allow the save with emoji's. I am hoping this is something that can be fixed in an upcoming patch.

Please Log in or Create an account to join the conversation.

Re: mysql error

10 months 2 weeks ago - 10 months 2 weeks ago
#31606
For this the database and table would have to be changed to utf8mb4 and utf8mb4_unicode_ci.

Maybe a good idea for a future release.

In Joomla 5 most of the tables are alread in utf8mb4 and utf8mb4_unicode_ci and you can change it for JEM too.
I just tested it manually and it worked:

After a backup of you DB you can change it manually in phpmyadmin with
Code:
ALTER TABLE `PREFIX_jem_attachments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_categories` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_cats_event_relations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_config` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_countries` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_groupmembers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_register` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `PREFIX_jem_venues` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
(and repalce PREFIX with your specific database prefix)
Last edit: 10 months 2 weeks ago by hekla.
The following user(s) said Thank You: McKillo

Please Log in or Create an account to join the conversation.

Re: mysql error

10 months 2 weeks ago
#31609
It's implemented and will be in the next release this or next week (JEM 4.2.1).
For technical details see:
github.com/jemproject/JEM-Project/issues/1716
github.com/jemproject/JEM-Project/commit/02790b20a08f136b8f8dce28e1d79eef29d77789
The following user(s) said Thank You: Wolfgang, JoeyJ

Please Log in or Create an account to join the conversation.

Time to create page: 0.370 seconds