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.

JS Trending Hashtag module and ILLEGAL MIX OF COLLATIONS FOR OPERATION

6 years 6 months ago
Licenses:
JomSocial Active

Hello.

Sometims users post in content (text-post) and comments links (or somethimng like that) with "#" and seemssystem thinks that it's #hashtag.

I set up "JS Trending Hashtag" module to display 20 tags for last 20 days and page doesn't load. It display error 1271 ILLEGAL MIX OF COLLATIONS FOR OPERATION ' IN ' (and no content).

If I set 7 day and it start to works. But seems any new random link or #hashtag can broke it and shotdown site.

Can you please look at it?

Thanks.


Sorry for my English
6 years 6 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi,

This is coming from mysql code, we will check this issue further.

thank you!

6 years 6 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi,

did you changed the backend account? we cant access it right now? need it to debug your issue.

thank you!

6 years 6 months ago
Licenses:
JomSocial Active

Hi. I just changed it (you can turn off JCH Optimise plugin and cache if you need). Thanks.


Sorry for my English
6 years 6 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

thank you...

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