Site Logout -- SQL error

9 years 3 months ago - 9 years 3 months ago #255032 by ah202
Site Logout -- SQL error was created by ah202
Hi,

I have recently installed Community builder on my test site in order to interact with another plugin that exports user Data onto another website upon registration in Joomla.

I have added the CB login module onto my site homepage, and removed the default Joomla login form module.

I am experiencing an issue when logging out of the site. When any user logs out they are sometimes redirected to the following page:

/index.php/cb-logout/logout

The following SQL database error is then displayed, 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, '')

I am running

Joomla 3.3.6 stable
CB 2.0.4
PHP 5.4.34
MYSQL 5.1

Can you advise on what might be the cause of this problem? Thanks

Please Log in to join the conversation.

9 years 3 months ago - 9 years 3 months ago #255246 by ah202
Replied by ah202 on topic Site Logout -- SQL error
It is inserting data for the primary key 'session_id' upon login then not clearing it down after the first logout.

Then upon the second logout it is giving an error due to a duplicate entry already being in place...


I have tried re-creating and repairing the table without success, can anyone help???

Please Log in to join the conversation.

9 years 2 months ago #257167 by ah202
Replied by ah202 on topic Site Logout -- SQL error
I have raised #257166 in the Pro support area for this now...

Please Log in to join the conversation.

9 years 2 months ago #257267 by nant
Replied by nant on topic Site Logout -- SQL error

ah202 wrote: I have raised #257166 in the Pro support area for this now...


Thank you - sorry we missed this in this thread.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.192 seconds

Facebook Twitter LinkedIn