Open Harvester Systems support questions and answers, bug reports, and development issues.
Moderators: jmacgreg, michael, John
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.
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
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.
Public Knowledge Project Team
- Posts: 10015
- Joined: Wed Aug 10, 2005 12:56 pm
Return to Open Harvester Systems Support and Development
Who is online
Users browsing this forum: Bing [Bot] and 2 guests