Import journal to multijournal server

Hello,

I exported the issues from a server (ojs 2.4.8) and I tried to import them in another server that hosts multiple journals (ojs 2.4.8). The error I get is:
ojs2: DB Error: Duplicate entry '113-109' for key 'custom_section_orders_pkey'

I restored the DB and I found that there is not such entry in the system so I assume it is generated while importing the data… Any idea?

Hi @an75824,

Is it possible that section elements are repeating for the same section in the same issue?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi,

but when every ID in the db is ‘autoincrement’ where is the problem? Any idea about how to find such repeating elements?

Thanks for your help.

Hi @an75824,

Watch for cases like this…

<issue ...>
 <section title="Articles" ...>
  ...
 </section>
 <section title="Reviews" ...>
  ...
 </section>
 <section title="Articles" ...>
  ...
 </section>
</issue>

As you can see, the Articles section is repeated.

If you just want to get this content in place and are having trouble finding a repeat element, you can temporarily edit plugins/importexport/native/NativeImportDom.inc.php and temporarily remove the line:

$sectionDao->insertCustomSectionOrder($issue->getId(), $section->getId(), $sectionIndex);

Regards,
Alec Smecher
Public Knowledge Project Team