Hello! I have a problem with site of my client. Installed Joomla + SH404SEF + Community Builder (All the latest version). When I try to Add album (through Community builder Gallery), I have error
1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' SQL=SELECT `id`,`alias`,`newurl`,`hits` FROM `#__sh404sef_aliases` WHERE `alias` = 
. If SH404SEF is turn off - it's OK, but I need sef links on the site pages.
How can I fix it with a working component?
Responses (3)
  • Accepted Answer

    Monday, February 13 2017, 08:33 AM - #Permalink
    Hi,

    You are on public forum, where we can only reply to pre-sale questions. Please be kind to use our helpdesk for all support requests.

    In your case however, the error is not related to sh404SEF. It is coming from your mysql server, and this is where the db tables collations should be fixed.

    Rgds
    The reply is currently minimized Show
  • Accepted Answer

    Monday, February 13 2017, 12:00 PM - #Permalink
    How I can to write my request there? I don't have access when I try to create new ticket.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, February 13 2017, 12:42 PM - #Permalink
    Hi

    You need a valid sh404SEF subscription to get support through the helpdesk.

    Also, as I mentioned, the problem is not in sh40SEF but in your mysql server setup.

    Rgds
    The reply is currently minimized Show
Your Reply