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
  • Auteur du sujet
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 11 ans 3 mois #6611 par cacauRio
Problem when saving an event a été créé par 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,

Connexion ou Créer un compte pour participer à la conversation.

  • Lyr!C
  • Portrait de Lyr!C
  • Administrateur
  • Administrateur
  • Lead Developer
Plus d'informations
il y a 11 ans 3 mois #6636 par Lyr!C
Réponse de Lyr!C sur le sujet 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) .

Fichier attaché :

Connexion ou Créer un compte pour participer à la conversation.

  • cacauRio
  • Auteur du sujet
  • Nouveau membre
  • Nouveau membre
Plus d'informations
il y a 11 ans 3 mois #6639 par cacauRio
Réponse de cacauRio sur le sujet Problem when saving an event
Joomla 3.2.1

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

Connexion ou Créer un compte pour participer à la conversation.

  • Lyr!C
  • Portrait de Lyr!C
  • Administrateur
  • Administrateur
  • Lead Developer
Plus d'informations
il y a 11 ans 3 mois #6642 par Lyr!C
Réponse de Lyr!C sur le sujet 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) .

Fichier attaché :

Connexion ou Créer un compte pour participer à la conversation.

Modérateurs: Lyr!C
Temps de génération de la page : 0.090 secondes

Follow Us

Créez vos templates Joomla avec Template Creator CK

acymailing logo new