Hello Caizergues,

Ah, I am so sorry I guess I missed your post earlier Anyway I really can't reproduce this issue on your site. Can you please provide me with the steps to reproduce the errors?

Hello Mark, thanks for your attention.

step 1 - connect to http://www.caiztest.fr
step 2- try to login with user benarde64 and corresponding pswd (see credentials )
step 3- I get the error page.
step 4- any further attempt to connect to the site produces the error page instead of the welcome/login page

I attach screen captures of each step.

Note : to avoid confusion, I have edited the welcome, so that it is different from the site initially archived.

Variant : If I log into the backend and try to access easysocial using joomla backend dropdown menu item, I get a similar error message (I did not compare word by word frontend and backend error messages to make sure they were absolutely identical)

Finally, when I try to reinstall EzS to work around the problem, I get the "contact support" message illustrated by the last screen capture.

From my end, the pb is sysmatic and perfectly reproducible.

Note : I did not recopy site credentials which were in my first post above.

Hello Caizergues,

I can't access your back end as it is throwing me this error,

Désolé, mon firewall vous pense dangereux.

Oh, I was able to access now. I guess admin tools is blocking me. By the way, can I have the phpmyadmin access?

Hello Caizer,

Hm, yeah I was able to reproduce this issue now. It looks like for some reasons, MySQL 5.0 automatically enforces these group by queries. Is there a way to request the hosting provider to upgrade it to MySQL 5.1 first? We'll try to address this in 1.2.0

Hello mark,

caiztest.fr is running mysql 5.0.51a-24+lenny5 and the production site caizergues.fr is running 5.5.30-30.2, according to configuration info from the backend of each site. And this difference causes the problem ?

Myhost provider has upgraded both sites to the same version, and I successfully uploaded and installed an archive.

by the way what is the ETA for EzS 1.2 stable ?

regards and thanks for your attention.

paul

Hello mark, i just bought ezsocial yesterday,

evrything in my website is ok, only the ezsocial is failed.

Error when login from front end :

JDatabaseMySQLi::query: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=select `time`, UNIX_TIMESTAMP( date_add( '2014-04-12 09:13:14' , INTERVAL -15 MINUTE ) ) as `limit`, count(1) as `count` from `cnr1e_session` where `userid` = '42' order by `time` desc limit 1

Error from backend :



500 - An error has occurred.



JDatabaseMySQLi::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 `cnr1e_users` AS `a` LEFT JOIN `cnr1e_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `cnr1e_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `cnr1e_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `cnr1e_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `cnr1e_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '43'



Return to Control Panel

I had followed every step from instruction.

Hello,

I am really sorry for the delay of this reply as it is a weekend for us here. May I know which version of MySQL do you have on the site? Also, can you please start a new thread so that I can look into this?