Phoca Forum

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?

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

Hi Jan,

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

Theo

Hi, great to hear it.

Jan