Hello,

Congratulations about this great component. I am using icagenda the free version. I have a problem in searching events from the control panel in the backend. When I type (search) a word or phrase in english everything is ok. When I type (search) a greek word in the events i have the following message.

(My database collation is utf8_general_ci. My version is iCagenda™ v 3.2.12 )

500 Illegal mix of collations for operation 'like' SQL=SELECT COUNT(*) FROM `j813o_icagenda_events` AS a LEFT JOIN `j813o_languages` AS l ON l.lang_code = a.language LEFT JOIN j813o_users AS uc ON uc.id=a.checked_out LEFT JOIN j813o_viewlevels AS ag ON ag.id = a.access LEFT JOIN j813o_icagenda_category AS c ON c.id=a.catid LEFT JOIN j813o_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1)) AND ( a.title LIKE '%φωνες%' OR a.username LIKE '%φωνες%' OR a.created LIKE '%φωνες%' OR a.id LIKE '%φωνες%' OR a.email LIKE '%φωνες%' OR a.file LIKE '%φωνες%' OR a.place LIKE '%φωνες%' OR a.city LIKE '%φωνες%' OR a.country LIKE '%φωνες%' OR a.coordinate LIKE '%φωνες%' OR a.desc LIKE '%φωνες%' OR a.params LIKE '%φωνες%' OR c.title LIKE '%φωνες%' )

Illegal mix of collations for operation 'like' 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 `j813o_icagenda_events` AS a LEFT JOIN `j813o_languages` AS l ON l.lang_code = a.language LEFT JOIN j813o_users AS uc ON uc.id=a.checked_out LEFT JOIN j813o_viewlevels AS ag ON ag.id = a.access LEFT JOIN j813o_icagenda_category AS c ON c.id=a.catid LEFT JOIN j813o_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1)) AND ( a.title LIKE '%φωνες%' OR a.username LIKE '%φωνες%' OR a.created LIKE '%φωνες%' OR a.id LIKE '%φωνες%' OR a.email LIKE '%φωνες%' OR a.file LIKE '%φωνες%' OR a.place LIKE '%φωνες%' OR a.city LIKE '%φωνες%' OR a.country LIKE '%φωνες%' OR a.coordinate LIKE '%φωνες%' OR a.desc LIKE '%φωνες%' OR a.params LIKE '%φωνες%' OR c.title LIKE '%φωνες%' ) ORDER BY a.title asc LIMIT 0, 20

Illegal mix of collations for operation 'like' SQL=SELECT COUNT(*) FROM `j813o_icagenda_events` AS a LEFT JOIN `j813o_languages` AS l ON l.lang_code = a.language LEFT JOIN j813o_users AS uc ON uc.id=a.checked_out LEFT JOIN j813o_viewlevels AS ag ON ag.id = a.access LEFT JOIN j813o_icagenda_category AS c ON c.id=a.catid LEFT JOIN j813o_users AS ua ON ua.id = a.created_by WHERE (a.state IN (0, 1)) AND ( a.title LIKE '%φωνες%' OR a.username LIKE '%φωνες%' OR a.created LIKE '%φωνες%' OR a.id LIKE '%φωνες%' OR a.email LIKE '%φωνες%' OR a.file LIKE '%φωνες%' OR a.place LIKE '%φωνες%' OR a.city LIKE '%φωνες%' OR a.country LIKE '%φωνες%' OR a.coordinate LIKE '%φωνες%' OR a.desc LIKE '%φωνες%' OR a.params LIKE '%φωνες%' OR c.title LIKE '%φωνες%' )


I tried to execute the same SQL commands under phpmyadmin and they execute just fine.

Does anyone have an idea please?