Main menu

Forum


The developer takes a few days off for Summer vacation...
...and will be back with charged battery!

From 14 June to 29 June, 2025 included
During this period,
assistance from developer will not be provided.

NEWS: iCagenda 4.0.0-alpha1 will be available for testing for users with a PRO subscription in July!

× Help Forum English

Problem when saving an event

  • cacauRio
  • Topic Author
  • New Member
  • New Member
More
11 years 3 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
11 years 3 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 3.9.11
We recommend every user to keep iCagenda updated.
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
  • New Member
  • New Member
More
11 years 3 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
11 years 3 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 3.9.11
We recommend every user to keep iCagenda updated.
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.087 seconds

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new