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

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

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

Hi

Any help on the bellow issues?

Thanks,

Maher

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.