Bugs item #1606439, was opened at 2006-11-30 23:56
Message generated for change (Comment added) made by stuartlewis
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=1606439&group_id=19984

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: 1.4.1 beta 1
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Scott Yeadon (syeadon)
>Assigned to: Stuart Lewis (stuartlewis)
Summary: Exception handling for deleting a metadata field

Initial Comment:
Trying to delete a metadatafield with associated values leads to an 
"java.sql.SQLException: ERROR: update or delete on "metadatafieldregistry" 
violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on 
"metadatavalue"" error.
This is indicated in the delete confirm page, but the error should be caught 
properly.

----------------------------------------------------------------------

>Comment By: Stuart Lewis (stuartlewis)
Date: 2009-01-18 21:25

Message:
Fixed in 1.5.2 (see attached patch). If the exception is thrown, the user
is returned to the confirmation page, but the submit button is replaced
with the error message and a hint.
File Added:
Fix_for_SF_bug_[1606439]_Exception_handling_for_deleting_a_metadata_field.patch

----------------------------------------------------------------------

Comment By: Claudia Juergen (cjuergen)
Date: 2007-04-11 14:01

Message:
Logged In: YES 
user_id=1209523
Originator: NO

Apart from this, there should be a sanity check at deleting or moving
metadata fields. Metadata fields used in input-forms and templates and per
default (timestamps) shouldn't be deletable at all.

Claudia


----------------------------------------------------------------------

Comment By: Sam Ottenhoff (ottenhoffs)
Date: 2007-01-28 17:46

Message:
Logged In: YES 
user_id=562689
Originator: NO

Deleting a namespace produces a similar error:

org.postgresql.util.PSQLException: ERROR: update or delete on
"metadataschemaregistry" violates foreign key constraint "$1" on
"metadatafieldregistry"

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=1606439&group_id=19984

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to