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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 14
Joined: Sun Mar 02, 2008 8:27 am

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: 10015
Joined: Wed Aug 10, 2005 12:56 pm

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: 14
Joined: Sun Mar 02, 2008 8:27 am

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

Return to “OJS Technical Support”

Who is online

Users browsing this forum: Google [Bot] and 1 guest