Getting this error when I attempt to view the Event Manager. I can access the other pages within ZapCalendar fine though. With the following install details:

Joomla! 1.5.15
Zap Calendar 2.0.9
RSVP installed - activated
Category Control - activated
Search - activated

500 - An error has occurred.

DB function failed with error number 1267
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT g.name AS groupname, zz.*, (select name from jos_users u where u.id = zz.created_by) as owner, (SELECT group_concat( distinct ec.catid ORDER BY c.ordering ASC SEPARATOR ',' ) FROM jos_zcalendar_event_categories ec, jos_zcalendar_categories c WHERE ec.uid = zz.uid and ec.catid = c.id GROUP BY ec.uid) as catid FROM jos_zcalendar_events as zz, jos_groups as g WHERE event_start >= '2010-02-26' AND g.id = zz.access ORDER BY zz.event_start ASC LIMIT 0,20

Wanted to make sure this one didn't get lost - I also tried uninstalling everything and clearing out the database tables to start 'fresh' without any luck. Thanks.

Somehow your collation sequence is different between the Zap Calendar tables and the jos_users table. You can verify this using phpMyAdmin if you have access to this. The collation sequence must be the same to avoid this error. You should be able to fix it using phpMyAdmin but I am wondering why the collation sequence changed.

Thanks for the reply. I checked in PHPMyAdmin and every table has the 'utf8_general_ci' collation applied to it. Is there something else I may be missing or something you might suggest? Thanks!

According to the error message, MySQL thinks at least one of the tables has a collation of "utf8_unicode_ci". Double check all your tables in the database.

Ah! Found it, it looks like the entire table was for some reason encoded in 'utf8_unicode_ci' instead of general... weird... but I did a global operation change and that seemed to work. Thanks!