Jomsocial 4.5.8 Updated for Improvements and bug fixes More Details

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

7 months 3 days 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?

7 months 3 days 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
7 months 2 days 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?

6 months 4 weeks 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