[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] export import



Thank you for your response.  The table "counters" does not exist in the new system using Postgres.  It does exist in the old system using Mysql.  Will this cause any issues to the new system?  Please note that the new system "with Postgres" is running fine and the errors "DBD::Pg::db selectrow_array failed: ERROR:  currval of sequence "fileid_seq" is not yet defined in this session"  only appeared when doing the import (using the exported XML files)  of the users and eprints to the new system.

For new items being created from the GUI we are not seeing in the logs the errors "DBD::Pg::db selectrow_array failed: ERROR:  currval of sequence "fileid_seq" is not yet defined in this session"

Will this error have any effect on the system?

Thanks,
Maher



From: Alan.Stiles [mailto:alan.stiles at open.ac.uk]
Sent: Wednesday, November 06, 2019 12:11 PM
To: eprints-tech at ecs.soton.ac.uk; Maher Abdellatif Ahmad Qahwash
Subject: RE: 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 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




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 an  .  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/319c92c2/attachment-0001.html