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
  • Autore della discussione
  • New Member
  • New Member
Di più
11 Anni 3 Mesi fa #6611 da cacauRio
Problem when saving an event è stato creato da 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,

Si prega Accedi o Crea un account a partecipare alla conversazione.

  • Lyr!C
  • Avatar di Lyr!C
  • Administrator
  • Administrator
  • Lead Developer
Di più
11 Anni 3 Mesi fa #6636 da Lyr!C
Risposta da Lyr!C al 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 allegato:

Si prega Accedi o Crea un account a partecipare alla conversazione.

  • cacauRio
  • Autore della discussione
  • New Member
  • New Member
Di più
11 Anni 3 Mesi fa #6639 da cacauRio
Risposta da cacauRio al topic Problem when saving an event
Joomla 3.2.1

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

Si prega Accedi o Crea un account a partecipare alla conversazione.

  • Lyr!C
  • Avatar di Lyr!C
  • Administrator
  • Administrator
  • Lead Developer
Di più
11 Anni 3 Mesi fa #6642 da Lyr!C
Risposta da Lyr!C al 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 allegato:

Si prega Accedi o Crea un account a partecipare alla conversazione.

Moderatori: Lyr!C
Tempo creazione pagina: 0.119 secondi

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new