Skip to Content Skip to Menu

šŸŒ² Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with codeĀ XMAS-2024!

Site Logout -- SQL error

  • ah202
  • ah202
  • OFFLINE
  • Posts: 6
  • Thanks: 1
  • Karma: 0
10 years 1 week ago - 10 years 1 week 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
Last edit: 10 years 1 week ago by ah202.

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

  • ah202
  • ah202
  • OFFLINE
  • Posts: 6
  • Thanks: 1
  • Karma: 0
10 years 1 week ago - 10 years 1 week 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???
Last edit: 10 years 1 week ago by ah202.

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

  • ah202
  • ah202
  • OFFLINE
  • Posts: 6
  • Thanks: 1
  • Karma: 0
9 years 11 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 or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 11 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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum