You are viewing the PKP Support Forum | PKP Home Wiki

DB Error: Duplicate entry 'XXX' for k1 [RESOLVED]

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.

DB Error: Duplicate entry 'XXX' for k1 [RESOLVED]

Postby strangelove » Mon Mar 03, 2008 9:33 am


I have just had an extra db made available and installed OJS. Upon initial login I get the following:

DB Error: Duplicate entry '0uk1m8j2aiebo0pohdvqk6dfp3' for key 1

and cannot get in.

I see this is a common (?) problem, but cannot find the solution in the OJS forums. Alec, if the answer is not immediately obvious, I can make pswds available to you if you would not mind taking a look at iipj.org.


Dr. Strangelove
University of Ottawa

Here are some of my server details (blacksun.ca is my server provider)

PHP Built on: Linux bx256.blacksun.ca 2.6.9-55.0.9.ELsmp #1 SMP Thu Sep 27 18:27:41 EDT 2007 i686
Database Version: 4.1.21-standard
Database Collation: utf8_general_ci [NOT SURE THIS IS RELEVANT __ GENERATED BY JOOMLA CMS prog}
PHP Version: 5.2.5
Web Server: Apache
Web Server to PHP interface: apache2handler
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20080201 Firefox/
Last edited by strangelove on Wed Mar 05, 2008 2:41 pm, edited 1 time in total.
Posts: 14
Joined: Sun Mar 02, 2008 8:27 am

Re: DB Error: Duplicate entry 'XXX' for k1

Postby asmecher » Mon Mar 03, 2008 9:48 am

Hi Dr. Strangelove,

Two things to try -- first, execute the following in MySQL:
Code: Select all
DELETE * FROM sessions;
Then make sure that the session.auto_start option in your config.inc.php file is not turned on. (You may have to restart your IIS/Apache after changing the php.ini file.)

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

Re: DB Error: Duplicate entry 'XXX' for k1 [RESOLVED]

Postby strangelove » Mon Mar 03, 2008 12:02 pm

Problem is fixed within login and DB ERROR: Duplicate entry at http://www.iipj.org.

For details see related post for details http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=2885
Posts: 14
Joined: Sun Mar 02, 2008 8:27 am

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Yahoo [Bot] and 4 guests