Joomla + Community Builder SQL Logout Error
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:
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
Can you advise on how I can resolve this issue? Is this a known bug when Community builder is installed with Joomdle?
I have looked at your files and see LDAP. Are you using LDAP for authentication somewhere?
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?
With regards to the blank session ID, I will look at this.
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.
Apart from Moodle SSO, What functionality does the user hooks service provide? If I disable it what is the full impact?
> 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?
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.
I remember some clients using Jmapmyldap with Joomdle without any problems, but they were not using CB.
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?