Main menu

Forum


× Help Forum English

Problem when saving an event

  • cacauRio
  • Topic Author
  • Junior Member
  • Junior Member
More
12 years 8 months ago #6611 by cacauRio
Problem when saving an event was created by cacauRio
Hi,
I have installed the freeware version.

I received this error when I tried to save an event. But I can save if I click at the button "save & new".

I do I have to do to fix this error? What is wrong?
The version is 3.2.13

500 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `qq4s1_icagenda_events` AS a LEFT JOIN `qq4s1_languages` AS l ON l.lang_code = a.language LEFT JOIN qq4s1_users AS uc ON uc.id=a.checked_out LEFT JOIN qq4s1_viewlevels AS ag ON ag.id = a.access LEFT JOIN qq4s1_icagenda_category AS c ON c.id=a.catid LEFT JOIN qq4s1_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1)) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category,ua.name AS author_name, ua.username AS author_username FROM `qq4s1_icagenda_events` AS a LEFT JOIN `qq4s1_languages` AS l ON l.lang_code = a.language LEFT JOIN qq4s1_users AS uc ON uc.id=a.checked_out LEFT JOIN qq4s1_viewlevels AS ag ON ag.id = a.access LEFT JOIN qq4s1_icagenda_category AS c ON c.id=a.catid LEFT JOIN qq4s1_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `qq4s1_icagenda_events` AS a LEFT JOIN `qq4s1_languages` AS l ON l.lang_code = a.language LEFT JOIN qq4s1_users AS uc ON uc.id=a.checked_out LEFT JOIN qq4s1_viewlevels AS ag ON ag.id = a.access LEFT JOIN qq4s1_icagenda_category AS c ON c.id=a.catid LEFT JOIN qq4s1_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1))

Thank you,

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

  • Lyr!C
  • Lyr!C's Avatar
  • Administrator
  • Administrator
  • Lead Developer
More
12 years 8 months ago #6636 by Lyr!C
Replied by Lyr!C on topic Problem when saving an event
Hello!

What is your Joomla version ?

The first time i see such an error... Don't you have it too with article ?

Latest version : iCagenda 4.0.17 Joomla! 4 > Joomla! 6
We recommend every user to keep iCagenda updated.
Support for iCagenda version 3.9 (the final version compatible with Joomla 3) ended on October 13, 2026
Extended security support for the iCagenda PRO 3.9 version until October 13, 2027 (to benefit from this extended support, you must have a Pro subscription: www.joomlic.com/extensions/icagenda)
Don't forget to have your Joomla!® up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

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

  • cacauRio
  • Topic Author
  • Junior Member
  • Junior Member
More
12 years 8 months ago #6639 by cacauRio
Replied by cacauRio on topic Problem when saving an event
Joomla 3.2.1

No, I don't have any problem with the articles.

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

  • Lyr!C
  • Lyr!C's Avatar
  • Administrator
  • Administrator
  • Lead Developer
More
12 years 8 months ago #6642 by Lyr!C
Replied by Lyr!C on topic Problem when saving an event
Try to update joomla to 3.2.2, and to install again iCagenda...
In case it is just a problem of installation, which could happen...

Really strange error...

Latest version : iCagenda 4.0.17 Joomla! 4 > Joomla! 6
We recommend every user to keep iCagenda updated.
Support for iCagenda version 3.9 (the final version compatible with Joomla 3) ended on October 13, 2026
Extended security support for the iCagenda PRO 3.9 version until October 13, 2027 (to benefit from this extended support, you must have a Pro subscription: www.joomlic.com/extensions/icagenda)
Don't forget to have your Joomla!® up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

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

Moderators: Lyr!C
Time to create page: 0.037 seconds

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new