DB Error: Duplicate entry '‘����������

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: 8
Joined: Mon Apr 30, 2007 4:40 am
Location: Copenhagen, Denmark

DB Error: Duplicate entry '‘����������

Postby kurtmathiesen » Thu Jun 21, 2007 3:23 pm

I've just uploaded a series of articles for a new issue of a journal. It is a journal that does all the reviewing outside of OJS, so I've just uploaded the files and used the exspedite funtion to skip most of the process. For all articles exept one there has been no problems.

The problem is that when I upload the galley file I get this error:
DB Error: Duplicate entry '‘������������' for key 2

at a page on this address:
http://ej.lib.cbs.dk/index.php/sats/edi ... LayoutFile

I find it odd as it was not a problem to upload the file in the first place (in the submission).

The new issue has to be published tomorrow (in 10 hours from now) can anybody help?

Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby asmecher » Fri Jun 22, 2007 3:43 pm

Hi kurtmathiesen,

It sounds to me like a character set problem between PHP, the galley, and the DBMS. First, try making sure you're using the connection_charset and database_charset options in your config.inc.php file. You might also be able to patch in some work-arounds for problems like this that have not yet been released; see http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=2324.

Also make sure that you're saving your HTML documents using the UTF-8 encoding.

There are several patches you'll need to apply to get this change in place:
  • http://pkp.sfu.ca/cvs/cvsweb.cgi/ojs2/classes/db/DAO.inc.php.diff?r1=1.23;r2=1.24
  • http://pkp.sfu.ca/cvs/cvsweb.cgi/ojs2/classes/search/ArticleSearchDAO.inc.php.diff?r1=1.26;r2=1.27
  • http://pkp.sfu.ca/cvs/cvsweb.cgi/ojs2/classes/search/ArticleSearchIndex.inc.php.diff?r1=1.21;r2=1.22
Alec Smecher
Public Knowledge Project Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada

Return to “OJS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest