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
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
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
(and repalce PREFIX with your specific database prefix)
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;
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
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
For technical details see:
github.com/jemproject/JEM-Project/issues/1716
github.com/jemproject/JEM-Project/commit/02790b20a08f136b8f8dce28e1d79eef29d77789
Please Log in or Create an account to join the conversation.
Time to create page: 0.370 seconds