By Caizergues on Thursday, 27 February 2014
Posted in Technical Issues
Likes 0
Views 1.2K
Votes 0
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.
Hello Mark,

Issue #1

The PHP errors are on the test site http://www.caiztest.fr where I loaded an archive to try to backtrack my JCE problem on the production site. This remain an issue, because it shows that my archives are not effectively working. Are you going to look into it further, or do I try to re-install EzSocial,since the backend seems to work ? I need to be sure I have a proven and operational method to restore the site from an archive on a test server.

Issue #2

Sorry to address two issues in a single ticket.

So back to JCE and the production site : I changed my Ezblog settings in my own user profile toTINYMCE and it seems to be working. However JCE is working normally in Ezdiscuss. I can live with that configuration for the time being, although I don' t like dangling issues.

Issue #3

But this change raises another side issue : changing settings for one user in one component, namely JCE obviously does not affect the Ezsocial or Ezdiscuss profile settings for the same user. How are these profiles synchronized ? If I leave the "default parameters" setting in JCE settings, am I going to be using the corresponding Ezsocial setting for this user or site default ?
·
Friday, 28 February 2014 19:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Caizergus,

I have tried to check your site but I can't seem to reproduce this issue This is what I am seeing when I am accessing the profile page, http://screencast.com/t/wFMSTWOL
·
Thursday, 27 February 2014 23:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi mark,
caizergues.fr works fine, except for Ezblog content editing/creation features. If you look at the attached screen shot, you will see that the editor window just show "toggle editor" ; no tools bars, and no article text.
·
Friday, 28 February 2014 17:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Caizergues,

Ah I see. I thought you were referring to the PHP errors earlier. Anyway I tried to access the site and noticed that there are actually javascript errors from JCE itself as you can see here, http://screencast.com/t/Ef0f7FEWsSr7 . If you try with TINYMCE, do you hit similar problems?
·
Friday, 28 February 2014 18:22
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post