EB/ES DB Collation on Joomla 3.7.2
By LAC Webadmin on Wednesday, 14 June 2017
Posted in General Issues
Replies 12
Likes 0
Views 696
Votes 0
Hi There,

I upgraded to J3.7.2 and ES 2.0.19, everything went well, no errors! I have this component I am working on and I would need to call a login module. I am using mod_easysocial_login and render it inside a component layout using:

$loginModules = JModuleHelper::getModules('logins');

foreach ($loginModules as $loginModule)
{
echo JModuleHelper::renderModule($loginModule);
}

I am getting this error:

1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

I checked the DB collation for Joomla tables it was changed to utf8mb4_general_ci and ES tables are utf8_general_ci.

Thanks,

Jackson
Hey there,

Is it can provide us following site details so we can better have a check?

1. staging backend access
2. staging FTP access
3. staging database access
4. how to replicate this error on the page
Arlex Wong
·
Wednesday, 14 June 2017 11:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

We have the same problem as well. Did you find a solution ?
B.M.
·
Friday, 08 September 2017 17:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Alex,

Currently I can't replicate this issue on my locally, perhaps you can start a new thread and provide us with your site access so we can better have a check?
Arlex Wong
·
Friday, 08 September 2017 20:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Just FYKI: for some reason, the exact error appeared using EasySocial login on our site. I'll open a private ticket.
Jozsef Simony
·
Monday, 04 December 2017 20:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Update: I've fixed this error using Akeeba Admin Tools by converting the Joomla database to “UTF-8 Multibyte” collation.

I'm sure there are other methods, but this one seemed easy...

Update: nope it didn't solve it just sometimes it didn't throw the error...
Jozsef Simony
·
Monday, 04 December 2017 21:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey guys,

Could you try to download the attached file and upload it into /components/com_easysocial/views/login/ and see if you are still experiencing any issues?
Mark
·
Monday, 04 December 2017 21:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, Mark, the issue is gone, and another (less serious one) appeared.

We're using EasySocial for an intranet with locked down mode (with J! .htaccess SEF on), and until the file update after the login, the user has been redirected to the home page: ourdomain.com/ (in case it's typed instead of clicked from a document.referrer)

With the updated file now it redirects to: ourdomain.com/everyone
Our problem with this that some of our modules linked to the home menu item ID.

Is there something we could do about this (redirect to home instead of /everyone without losing the document.referrer functionality if there's one)?
Jozsef Simony
·
Monday, 04 December 2017 23:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Jozsef,

Hm, this fix is just a quick patch to fix the issue with redirection. The developers are working on a proper fix for this. I believe this bug was introduced while trying to fix an issue with the login redirection from EasyDiscuss.

I think your issue is a different one altogether. Perhaps you can start a new thread on this?
Mark
·
Monday, 04 December 2017 23:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

I had the same issue with logging into Easysocial, "Illegal mix of collocations..". Just applied the fix and all good! Assume you guys will fix on the next ES update.

Cheers, David
David
·
Friday, 08 December 2017 13:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi David,

Yes, this is a known issue where the ticket has been logged in our issue tracker and the proper fix will included in the next release, probably will be out by today
Muhammad Fadhli
·
Friday, 08 December 2017 15:48
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post