× Here you can get community support related to ReDJ.

Illegal mix of collations error

  • juanm_la22
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #5974 by juanm_la22
Illegal mix of collations error was created by juanm_la22
Hi, i am new here!

My problem is this: we migrate our old website to a new one developed under joomla 3.6. Because we have a lot of url indexed on google and bing, we decide to make as much 301 as we can. Everything works fine except for this kind of url:

www.example.com/mabel%20fotograf%EDa%20artistica.html

That url has utf8 encoded chars (i didn't do that!!) and is indexed on google. We have not any rule in ReDJ for that url, but when plugin tries to check if there is something for that url i get an 1267 ERROR: Illegal mix of collations.

I saw in the change logs of ReDJ (v 1.6.2 if i am not wrong) this:

Replaced urlencode(<string>) with urlencode(utf8_encode(<string>)) (only for Enterprise);
Replaced urldecode(<string>) with utf8_decode(urldecode(<string>)) (only for Enterprise).

And indeed, i try that on my ReDJ Community (latest version) and it works.

So my question is: This isn't fixed on latest community version because you forgot or because i need to pay to have this working?

Regards and thanks in advance,
Juan Manuel

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

More
7 years 1 month ago #5975 by admin
Replied by admin on topic Illegal mix of collations error
HI Juan Manuel,
this should be a problem with the database collation.

While ReDJ tables are created with CHARSET=utf8 in the definition, the latest Joomla tables have CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci.

Try to change the charset/collation of the ReDJ redirection rule table (#__redj_redirects) according to other joomla tables. It should fix the issue.

Kind regards,
Luigi

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

  • juanm_la22
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #5976 by juanm_la22
Replied by juanm_la22 on topic Illegal mix of collations error
Hi, thanks for your quick answer!

I did that before posting here, but the error was still there.

The only way I can fix it was changing $currenturi = urldecode(... ) ; to utf8_decode(urldecode(... ) ) ; in plugin.

This would be in a future update?

Thanks

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

More
7 years 1 month ago #5979 by admin
Replied by admin on topic Illegal mix of collations error
Of course I will check the fix you suggest, and I will include it in the next release.

Thanks

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

Time to create page: 0.088 seconds