Xmlui dspace 5.1 update from 4.1
Basically the sql updater expects only one entry for element=rights in the
table metadatafieldregistry but ours has two.
Does anyone have any idea what I should do?
Should I merge the two rights: how would I do that?
thank You,
Ben
>From the dspace.log
**********
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error
executing statement at line 64: INSERT INTO metadatavalue (resource_id,
resource_type_id, metadata_field_id, text_value, text_lang, place)
SELECT
community_id AS resource_id,
4 AS resource_type_id,
(select metadata_field_id from metadatafieldregistry where metadata_schema_id=
(select metadata_schema_id from metadataschemaregistry where short_id='dc')
and element = 'rights' and qualifier is null) AS metadata_field_id,
copyright_text AS text_value,
null AS text_lang,
0 AS place
FROM community where not copyright_text is null
............................
Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned
by a subquery used as an expression
*****************
Query against the database.
select * from metadatafieldregistry where metadata_schema_id=1 and element =
'rights' and qualifier is null;
metadata_field_id | metadata_schema_id | element | qualifier |
scope_note
-------------------+--------------------+---------+-----------+--------------------------------------------------------------------
53 | 1 | rights | | Terms governing
use and reproduction.
70 | 1 | rights | | Information
about intellectual rights held in or over the document
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
