I can not use EzSocial or my frontend after reloading an archive of my site on a different server

Hello Stackideas,

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'

Retour au panneau de contrôle

I had already posted this issue, associated with another, more or less closed. But no answer to date for this so I post it again.

I have loaded an archive of my site to investigate a compatibility issue between EzBlog and a third party extension. I can not log on the frontend (error above). I can log on the backend, but cannot access Ezsocial : I get the same error.

In an attempt to work around the issue, I tried to re-install EZSocial. I then got the same error as during the initial install (see attachment)

So, I am stuck, and worse, I discovered my archives are useless.

I would appreciate some help and guidance.