HEEEELP!!!
I just found out, I guess, that I'll better not use function "Save as copy" with iCagenda events from now on...
I just saved one with that funcion and now the event list shows up like this:
_____________________________
Error
Illegal mix of collations for operation 'like' SQL=SELECT COUNT(*) FROM `rstam_icagenda_events` AS a LEFT JOIN `rstam_languages` AS l ON l.lang_code = a.language LEFT JOIN rstam_users AS uc ON uc.id=a.checked_out LEFT JOIN rstam_viewlevels AS ag ON ag.id = a.access LEFT JOIN rstam_icagenda_category AS c ON c.id=a.catid LEFT JOIN rstam_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 '%Рождественский рынок%' OR a.next 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 `rstam_icagenda_events` AS a LEFT JOIN `rstam_languages` AS l ON l.lang_code = a.language LEFT JOIN rstam_users AS uc ON uc.id=a.checked_out LEFT JOIN rstam_viewlevels AS ag ON ag.id = a.access LEFT JOIN rstam_icagenda_category AS c ON c.id=a.catid LEFT JOIN rstam_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 '%Рождественский рынок%' OR a.next LIKE '%Рождественский рынок%' ) ORDER BY a.title asc LIMIT 0, 20 Illegal mix of collations for operation 'like' SQL=SELECT COUNT(*) FROM `rstam_icagenda_events` AS a LEFT JOIN `rstam_languages` AS l ON l.lang_code = a.language LEFT JOIN rstam_users AS uc ON uc.id=a.checked_out LEFT JOIN rstam_viewlevels AS ag ON ag.id = a.access LEFT JOIN rstam_icagenda_category AS c ON c.id=a.catid LEFT JOIN rstam_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 '%Рождественский рынок%' OR a.next LIKE '%Рождественский рынок%' )
____________________________
Рождественский рынок is the event I just saved...
Since I can't see the list I can't delete it and I don't know how to solve this!!!!
Please help me ???
THANKS!
iCagenda version: v 3.3.8
Joomla version: 3.3
The website is offine but if you need it I can make it public:
www.russkijmir.org 
