JCE plugin does not load

Hi.

I have EzSocial 1.1.6, ezblog 3.9.15210 and ezdiscuss3.2.9304 installed on joomla! 2.5.18 on my site http://www.caizergues.fr., and everything was finally working fine. I then installed one more component, yoorecipe. (which needs a bizarre plugin to provide some form of backward compatibility between joomla! 2.5 and 3.x ).

When I tried to create a blog entry to announce the new functionalities, I noted that JCE plugin does not load anymore in the post creation screen. Same if I try to modify an existing post.The plugin works in ezdiscuss and JEvents. The problem seems specific to EZBlog.

To check the issue, I reloaded an archive taken prior to the install of the most recent component on a test site http://www.caiztest.fr. I can access the backend, but when I try to access the frontend I get an error 500

500 - Une erreur s'est produite

JDatabaseMySQL::query: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `z5hs3_users` AS `a` LEFT JOIN `z5hs3_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `z5hs3_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `z5hs3_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `z5hs3_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `z5hs3_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '225'

When I try to access ezsocial in the backend, I get the same error. So there is the culprit, apparently.

So either you use absolute paths in ezsocial authentication(which I doubt), either you have built in measures to prevent reloading ezs on a second site. Whichever, I am stuck.

Can you help ?

I attach credentials to both sites.

Thanks.