You are viewing the PKP Support Forum | PKP Home Wiki

Duplicate entry problem

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Duplicate entry problem

Postby Ajakss » Sun Jun 02, 2013 8:30 am


suddenly my site was crashed and I see the message: DB Error: Duplicate entry '1auh8eh7ec1tjoado2vvhd57bbpt1ksh4epd3r2r' for key 'sessions_pkey'. My version is 2.3.7.

I have enabled debugging but the messages are quite unclear for me:

Stack Trace:
File: .../ojs/lib/pkp/classes/session/SessionDAO.inc.php line 75
Function: DAO->update("INSERT INTO sessions (session_id, ip_address, user_agent, cr...", Array(8))

File:…/ojs/lib/pkp/classes/session/SessionManager.inc.php line 82
Function: SessionDAO->insertSession(Object(Session))

File: .../ojs/lib/pkp/classes/session/SessionManager.inc.php line 114
Function: SessionManager->SessionManager(Object(SessionDAO), Object(Request))

File: .../ojs/classes/security/Validation.inc.php line 283
Function: SessionManager->getManager()

File: .../ojs/lib/pkp/classes/core/PKPPageRouter.inc.php line 65
Function: Validation->isLoggedIn()

File: .../ojs/lib/pkp/classes/core/Dispatcher.inc.php line 113
Function: PKPPageRouter->isCacheable(Object(Request))

File: .../ojs/lib/pkp/classes/core/PKPApplication.inc.php line 180
Function: Dispatcher->dispatch(Object(Request))

File: .../ojs/index.php line 65
Function: PKPApplication->execute()

Unfortunately, because of the crash I do not have an access to the admin interface in order to clear user sessions. How can I solve this? I would be very appreciate for your help.

Many thanks in advance for your suggestions.

Kind regards,

Posts: 55
Joined: Fri Jun 08, 2012 11:16 am

Re: Duplicate entry problem

Postby asmecher » Sun Jun 02, 2013 9:15 am

Hi Adam,

There are lots of similar threads on the form -- see e.g. http://pkp.sfu.ca/support/forum/viewtopic.php?f=3&t=9235. Start with those. If they don't help, describe what you've tried here.

Alec Smecher
Public Knowledge Project Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: Duplicate entry problem

Postby Ajakss » Sun Jun 02, 2013 11:36 am

Hi Alec,

thanks for your reply. I have read all threads on this topic and deleted all user sessions but no effect. For a moment the site is available but when I try to change the page the message appears again. Any ideas what can I do? Thanks a lot for help.

Best regards,

Posts: 55
Joined: Fri Jun 08, 2012 11:16 am

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 5 guests