[EP-tech] export import

[Alan.Stiles]

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

Hi

Any help on the bellow issues?

Thanks,
Maher

From: eprints-tech-bounces at ecs.soton.ac.uk<mailto:eprints-tech-bounces at ecs.soton.ac.uk> [mailto:eprints-tech-bounces at 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 at ecs.soton.ac.uk<mailto:eprints-tech at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20191106/a2e22797/attachment-0001.html