Main menu

Forum


× Help Forum English

Problem when saving an event

  • cacauRio
  • Topic Author
  • New Member
  • New Member
More
10 years 2 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
10 years 2 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.3
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
10 years 2 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
10 years 2 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.3
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.132 seconds

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new