EPrints Technical Mailing List Archive

Message: #08015


< 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


Unfortunately I don’t really know Postgres, but it appears that the sequencing of table ids works differently between that and MySQL.

 

It looks like something is possibly not initialised for the file, document and eprint tables’ primary keys.

 

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 11:56
To: Alan.Stiles <alan.stiles@open.ac.uk>; eprints-tech@ecs.soton.ac.uk
Subject: Re: [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@open.ac.uk]
Sent: Wednesday, November 06, 2019 12:11 PM
To: eprints-tech@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@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

 

 

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.