Illegal mix of collations

[zwaneveld]

Hi,

Since I upgraded to the latest version of Joomla (3.5.1) and the latest version of Phoca Gallery (4.2.1), going to "Phoca Gallery Component -> Control Panel -> Images" results in the following (SQL) error:

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/dosbodegraven.nl/httpdocs/administrator/components/com_phocagallery/views/phocagalleryimgs/view.html.php on line 32

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=EXPLAIN SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg FROM `#__phocagallery` AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__users AS uua ON uua.id=a.userid LEFT JOIN #__phocagallery_categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = c.owner_id LEFT JOIN #__phocagallery_img_votes_statistics AS v ON v.imgid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Can you please help to solve this problem?

[Jan]

Hi, first do you get the error in version 4.3.0 (latest Phoca Gallery)?

Maybe the collation was changed somehow when updating, I think, the only way will be to go to phpMyAdmin and see the collation there, or change it so it will be for all tables the same
Jan

[zwaneveld]

Hi Jan,

Changing the collation of all tables and columns in the database, using your "change collation tool", solved the problem.
Many thanks!

Theo

[Jan]

Hi, great to hear it.

Jan