Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Error 1267 "Illegal mix of collations..." when user clicks on Hashtag

4 months 2 weeks ago
  • Vitalii's Avatar
    Topic Author
  • Vitalii
  • Offline
  • Fresh Boarder
  • Posts: 17
  • Thank you received: 2
Licenses:
JomSocial Active

When user clicks on hashtag, the Error 1267 is raised " Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' ". Can you please look at it?

4 months 2 weeks ago
Licenses:

Privet Vitalii.

Thank you for contacting us.
Please, check your database what collation is used for tables. It seems that they are mixed - you use at the same database both collations: utf8_general_ci and utf8mb4_general_ci.


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
The following user(s) said Thank You: Vitalii
4 months 2 weeks ago
  • Vitalii's Avatar
    Topic Author
  • Vitalii
  • Offline
  • Fresh Boarder
  • Posts: 17
  • Thank you received: 2
Licenses:
JomSocial Active

Michał, can you recommend what I need to set in the database? Do I need to execute a query in the database to solve a problem?

4 months 1 week ago
Licenses:

HI, Vitalii.

Yes, you'll need to run SQL query like this:
stackoverflow.com/questions/1294117/how-...atabase-table-column
Use this collation: utf8_general_ci.
But before that, do a safe copy ;)


- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
The following user(s) said Thank You: Vitalii
Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW