Joomla + Community Builder SQL Logout Error

6 years 2 months ago 6 years 2 months ago by Adrian H.
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #1
Hi,

I have installed Joomdle in Joomla and Moodle, and now want to get Joomdle functioning with mappings using community builder. I have added the CB login module onto my site homepage, and removed the default Joomla login form module. I have added the mappings shown in the screenshot below



I am experiencing an issue when logging out of the site. When any user logs out more than once in the same session taken to the following page:

/index.php/cb-logout/logout

An SQL database error is then displayed on the page as below, the rest of the page is blank:

Duplicate entry '' for key 'PRIMARY' SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES ('', 0, 1, '0', 0, '')

The issue resolves itself once I disable either the Joomdle or CB plugins.

I have done some investigation into this and can see that the 'Jos_session' table in the Joomla database appears to not be cleared down properly after the first logout, Leaving a row with a blank session ID. I have attached the contents the Jos_session table after login for the first time and after the second time for comparison.

I raised this issue with the community builder support team and they have found that the 'com_joomdle' extension is inserting the row with a blank session ID on logout, the query is also attached (SQLquery.txt)

I am running:

Joomla 3.3.6 stable
Community Builder 2.0.4
Joomdle 0.95
PHP 5.4.34
MYSQL 5.1

Can you advise on how I can resolve this issue? Is this a known bug when Community builder is installed with Joomdle?
Attachments:

Please Log in or Create an account to join the conversation.

6 years 2 months ago 6 years 2 months ago by Chris.
Chris
Posts: 2118
More
Joomla + Community Builder SQL Logout Error #2
Hi there, I have not seen this error message before and we know there are many sites running CB and Joomdle 0.95. Antonio is away until next week and thus will not be able to look into that part of the code. In the mean time, I shall run some tests to see if I can replicate your error but before I start can you please confirm you are using Joomdle 0.95.

Thanks

Edited:
I have looked at your files and see LDAP. Are you using LDAP for authentication somewhere?

Please Log in or Create an account to join the conversation.

6 years 2 months ago 6 years 2 months ago by Adrian H.
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #3
Yes, sorry I forgot to mention this. I am also using a plugin called JmapmyLDAP to allow authentication with domain logins.

I can also confirm I am running Joomdle 0.95

I should have tested this earlier but I can't re-create the issue on users that aren't authenticating via LDAP, so this looks to be some incompatibility between JMAP and Joomdle, can you see why a blank session id is being inserted and not cleared for these users?

Please Log in or Create an account to join the conversation.

6 years 2 months ago
Chris
Posts: 2118
More
Joomla + Community Builder SQL Logout Error #4
It is quite possible there is a compatibility problem with JmapmyLDAP. We do not test all of the login nor SSO related plugins. If you are using Joomla's, Jomsocial's, CB's, EasySocial's, VM's, etc. we have no problem - in fact we do not do anything special with these as they all integrate with the normal Joomla login / logout process. The problems tend to arise when a plugin does something a little different then 'normal'.

With regards to the blank session ID, I will look at this.

Please Log in or Create an account to join the conversation.

6 years 2 months ago 6 years 2 months ago by Adrian H.
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #5

Chris wrote: With regards to the blank session ID, I will look at this.


Thanks, your help is really appreciated. this is probably my last chance at getting it working as the developer for JMapMyLDAP doesn't appear to be active anymore

Edit: I've attached the full SQL query log from logout.
Attachments:

Please Log in or Create an account to join the conversation.

6 years 2 months ago 6 years 2 months ago by Adrian H.
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #6
If I disable the Joomdle user hooks plugin in Joomla this issue does not occur. All other Joomdle Plugins are still enabled.

Apart from Moodle SSO, What functionality does the user hooks service provide? If I disable it what is the full impact?

Please Log in or Create an account to join the conversation.

6 years 2 months ago
Antonio Durán
Posts: 7276
More
Joomla + Community Builder SQL Logout Error #7
I have tested on a local CB setup, and can't reproduce the problem.

> I raised this issue with the community builder support team and they have found that the 'com_joomdle' extension is inserting the row with a blank session ID on logout,

Did they give you any hints on why they say this? I can't think of how Joomdle can be inserting rows in table, by looking at Joomdle code.

Have you tried with a normal (non ldap) user?

Please Log in or Create an account to join the conversation.

6 years 2 months ago 6 years 2 months ago by Adrian H.
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #8
Hi Antonio

Antonio Durán wrote: I have tested on a local CB setup, and can't reproduce the problem.Have you tried with a normal (non ldap) user?


Yes and it works without a problem. If I disable the Joomdle user hooks plugin then LDAP users work perfectly.

It looks to be some Issue with the plugin Jmapmyldap and Joomdle. How is your test system setup?

Antonio Durán wrote: Did they give you any hints on why they say this? I can't think of how Joomdle can be inserting rows in table, by looking at Joomdle code.


Ive saved and attached the page for you to read to this reply.
Attachments:

Please Log in or Create an account to join the conversation.

6 years 2 months ago
Antonio Durán
Posts: 7276
More
Joomla + Community Builder SQL Logout Error #9
I don't feel like setting up a LDAP enviroment just for testing that... but if this is as it seems a problem between Joomdle, CB and Jmapmyldap, I could look into it in your site, if that's possible,

I remember some clients using Jmapmyldap with Joomdle without any problems, but they were not using CB.

Please Log in or Create an account to join the conversation.

6 years 2 months ago
Adrian H
Posts: 19
More
Topic Author
Joomla + Community Builder SQL Logout Error #10
Hi Antonio,

That is understandable. I am happy to provide some details for you to take a look at my site, however I don't want to share this on a public forum.

I can't find a way to send a private message on this forum, do you have an email address I can send some login details to?

Please Log in or Create an account to join the conversation.