Blank screen and easydicsuss SQL error with Easy Profile account
By saidi on Friday, 15 August 2014
Posted in Technical Issues
Replies 15
Likes 0
Views 768
Votes 0
Hi,
I installed Easy Profile from JSN with their joomsocial bridge feature which permit to have avatar intergration. So i configured easydiscuss with :

Go to Administration->Components->EasyDiscuss
Set Jomsocial on Settings->General->Workflow->Select a register provider
Set Jomsocial on Settings->Layout->Avatar->Profile picture integrations

Then when i update my profile avatar photo and i come back to home, i get a blank screen, and when i go to easydiscuss menu, i get this error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') union select b.`category_id` from `b1j2i_discuss_category_acl_map` as b ' at line 1 SQL=select c.`id` from `b1j2i_discuss_category` as c where not exists ( select b.`category_id` from `b1j2i_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'group' and b.`content_id` IN () union select b.`category_id` from `b1j2i_discuss_category_acl_map` as b where b.`category_id` = c.`id` and b.`acl_id` = '2' and b.`type` = 'user' and b.`content_id` = '559' ) and c.`private` = '2'

I need to logout and re-login and then it works.

Could you help me?
+1
Please help us!
Evgeniy
·
Friday, 15 August 2014 04:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello saidi,

Sorry for late reply to this,
Actually I have tried to reproduce on this issues, but I can't able to reproduce this SQL error in your site, what i noticed is if you set Intégration Photo de Profil to JomSocial then the user will not to upload their avatar from frontpage.

If I tried to set to default I can able to upload my avatar, but it seems like after i click save my avatar, then it look like working fine without any error.
May i know how the step to reproduce this issues? Please advise.
Arlex Wong
·
Friday, 15 August 2014 14:39
·
0 Likes
·
0 Votes
·
0 Comments
·
OK.
To reproduce this issue, you need to :
-login on the website (use "connexion" in the menu)
- edit your profil (use connexion/profil in the menu)
- change anything (image or description), save
- then go to home (accueil) or discussion

You will see a blank page on home and a SQL error on discussion
saidi
·
Friday, 15 August 2014 17:19
·
0 Likes
·
0 Votes
·
0 Comments
·
i activate error log and when i connect to homepage i have :

Notice: Undefined variable: gantry in /home/cmapause/www/templates/rt_plethora/error.php on line 15
Fatal error: Call to a member function init() on a non-object in /home/cmapause/www/templates/rt_plethora/error.php on line 15

Does it help you ?

Best regards
saidi
·
Friday, 15 August 2014 21:52
·
0 Likes
·
0 Votes
·
0 Comments
·
I continue the troobleshooting and the problem is due to easydiscuss.
I desactivated easydiscuss module from the home page. Then the home page works.
I desactivated all easy profile plugin to use joomla native profil and i get the same error when i update my profil with the home page (easydiscuss module activated) and easydiscuss page (error 1064)
So the problem is not Easy Profile, I think that when a user update own profile Joomla replace the old session and Easy Discuss module get an error.

Please help...
saidi
·
Saturday, 16 August 2014 18:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello saidi,


-login on the website (use "connexion" in the menu)
- edit your profil (use connexion/profil in the menu)
- change anything (image or description), save
- then go to home (accueil) or discussion


I am really sorry for the delay of this reply as it is a weekend for us here. I tried to reproduce the steps you mentioned above and this is the result:

1. http://screencast.com/t/LP9BQBjY (Saving profile)
2. http://screencast.com/t/nIZHpsTdHwjN (Viewing homepage)

I am not sure how to reproduce this issue because all your menu's are French and I don't understand French. I do not see a menu for "Connextion/profil" either.
Mark
·
Saturday, 16 August 2014 23:26
·
0 Likes
·
0 Votes
·
0 Comments
·
As i said, the home page works because i disabled the easydiscuss plugin on home page.
So, to reproduce, please do this :
- Log on the website (use connexion button on top right)
- Click on the "Mon profil" button (on the home page) or use http://www.mydomain.fr/index.php/mon-profil
- edit the profil and change your photo or anything in the user profile tab (ex : description)
- save
- Then go to easydiscuss with the menu "S'informer"/"Discussions". You will find the error code

Then, logoff and logon and come back to easydiscuss, and you will see, it's correct

I don't understand why easydiscuss crach after an editing of profil.

Best regards
saidi
·
Saturday, 16 August 2014 23:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I have applied some fixes on the site and it should no longer throw any errors now. By the way there's some really extensive caching going on at the site. When I tried to output some codes, it doesn't get updated regardless if I removed the debug codes unless I access the URL differently.
Mark
·
Sunday, 17 August 2014 00:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi, thank you for your answer. I still have an error with easydiscuss but not the same. Now it's :

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR (`type` = 'user' AND `content_id`='567' )' at line 1 SQL=SELECT COUNT(1) FROM `b1j2i_discuss_category_acl_map` WHERE `acl_id` = '5' AND ( ) OR (`type` = 'user' AND `content_id`='567' )

How can i help you to troobleshoot?
saidi
·
Sunday, 17 August 2014 00:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Saidi,

Hm, which page are you hitting this error? By the way, there's some issues with the way easy profile is saving the user object.

Before easy profile saving:



$my = JFactory::getUser();

var_dump($my->groups); // This returns a list of groups


After easy profile saving:



$my = JFactory::getUser();

var_dump($my->groups); // This returns an empty value
Mark
·
Sunday, 17 August 2014 14:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

I desactivated all easy profile plugins, i configured easyblog and easydiscuss to use their own avatar. This change don't solve my problem.
When you edit your profil (with "compte" in the menu bar : link to joomla profil not to easy profil) and you come back to easydiscuss (with "s'informer"/"discussion" in the toolbar menu), you get :

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR (`type` = 'user' AND `content_id`='567' )' at line 1 SQL=SELECT COUNT(1) FROM `b1j2i_discuss_category_acl_map` WHERE `acl_id` = '5' AND ( ) OR (`type` = 'user' AND `content_id`='567' )

So this confirm, that it's not easyprofil who cause this problem but easysdiscuss. I don't have the compentencies in php to troobleshoot the code.

You will find an other post in your forum with the same issue but not solved. It's the post of "Evgeniy"

I will keep easy profile desactivated until you troobleshoot.

Please help Mark, it's a big problem for me.

Best regards
saidi
·
Sunday, 17 August 2014 16:01
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

The problem is due to easydiscuss on joomla 3.3.3 !

I have troobleshooting on an other website with an older version of joomla. I was using only joomla, easydiscuss and easyblog without any other component. The site works fine for updating my profil.
Then i upgrade joomla to 3.3.3 and the problem appears.

Others users of easy discuss will meet this problem when they will upgrade their joomla.

Best regards,
saidi
·
Sunday, 17 August 2014 19:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Saidi,

Firstly, I really have no idea how to reproduce the second issue as you did not provide the steps to reproduce the second issue. I have tried the same steps to

1. Edit Profile
2. Save Profile
3. Viewed EasyDiscuss

I did not hit any more errors. Anyway I have applied some fixes on the helper file, can you see if you are able to reproduce this error ? If you are able to reproduce this error, please provide the steps to reproduce this second error
Mark
·
Sunday, 17 August 2014 22:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

Waou !!! it works with your helper.php file.

Will you include this fix to the futur easydiscuss version ?

Many thanks for your help,
saidi
·
Sunday, 17 August 2014 22:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, this fix will be included in the next release of EasyDiscuss
Mark
·
Sunday, 17 August 2014 22:44
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post