EPrints Technical Mailing List Archive

Message: #08013


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] export import


Not using Postgres, but try looking in the DB table ‘counters’ and see what entries you have there.

You may need to replicate the values from your original setup for any that don’t already exist.

 

Alan

 

From: eprints-tech-bounces@ecs.soton.ac.uk <eprints-tech-bounces@ecs.soton.ac.uk> On Behalf Of Maher Abdellatif Ahmad Qahwash via Eprints-tech
Sent: 06 November 2019 05:17
To: eprints-tech@ecs.soton.ac.uk; Maher Abdellatif Ahmad Qahwash <qahwash@kfupm.edu.sa>
Subject: Re: [EP-tech] export import

 

Hi

 

Any help on the bellow issues?

 

Thanks,

Maher

 

From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Maher Abdellatif Ahmad Qahwash via Eprints-tech
Sent: Friday, November 01, 2019 9:52 PM
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] export import

 

تحذير: هذه الرسالة مرسلة من خارج الجامعة. لا تفتح أي مرفق أو رابط ما لم تكن متأكداً من أنه آمن
Warning: This mail has been sent from outside KFUPM. Do not open links or attachments unless you are sure they are safe.
____________________________________________________________

Hi

 

We have successfully done an export of all eprints items from our server running eprints 3.2.7 and Mysql to another server running eprints 3.4.1 and Postgress 9.6  .  The eprints items are showing fine on the new eprints 3.4.1 server but during the import "when running the /bin/import command" we received the following errors and I would like to ask if it is ok to ignore them?

 

DBD::Pg::db selectrow_array failed: ERROR:  currval of sequence "fileid_seq" is not yet defined in this session at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 214.

Use of uninitialized value $id in addition (+) at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 216.

DBD::Pg::db selectrow_array failed: ERROR:  currval of sequence "documentid_seq" is not yet defined in this session at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 214.

Use of uninitialized value $id in addition (+) at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 216.

DBD::Pg::db selectrow_array failed: ERROR:  currval of sequence "eprintid_seq" is not yet defined in this session at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 214.

Use of uninitialized value $id in addition (+) at /opt/eprints3/perl_lib/EPrints/Database/Pg.pm line 216.

 

Another question I have is how to export the "History" of the eprints items from the old system and import them in the new system?

 

Many thanks for the support.

 

Maher

 

 

-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority in relation to its secondary activity of credit broking.