You are viewing the PKP Support Forum | PKP Home Wiki

DB Error: Duplicate entry '4746929-0' for key 'PRIMARY'

Open Harvester Systems support questions and answers, bug reports, and development issues.

Moderators: jmacgreg, michael, John

Forum rules
Developer Resources:

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome.

DB Error: Duplicate entry '4746929-0' for key 'PRIMARY'

Postby singhkarki » Wed Jan 15, 2014 11:02 pm

When I update metadata index for an archive , i get the database error , which is as follows:
DB Error: Duplicate entry '4746929-0' for key 'PRIMARY'
please tell me what can i do to prevent this error?


Posts: 51
Joined: Fri Nov 29, 2013 3:28 pm

Re: DB Error: Duplicate entry '4746929-0' for key 'PRIMARY'

Postby asmecher » Thu Jan 16, 2014 8:30 am

Hi Vijay,

Off the top of my head, this supports my earlier suggestion that several archives are using the same record IDs. However, you can get more information by turning on the "debug" option in your config.inc.php and trying the operation again; this will dump database queries to the browser, including the SQL statement that resulted in the error.

Another possible source of trouble is database content that is not stored in UTF8. If you're not using UTF8 for your database charset and connection charset, I suggest changing it.

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

Return to Open Harvester Systems Support and Development

Who is online

Users browsing this forum: No registered users and 2 guests