[Treebase-guts] [ treebase-Bugs-2931592 ] submissions with orphaned records cannot be deleted

[SourceForge.net <no...@so...>]

Bugs item #2931592, was opened at 2010-01-13 15:32
Message generated for change (Tracker Item Submitted) made by sfrgpiel
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2931592&group_id=248804

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: data
Group: None
Status: Open
Priority: 8
Private: No
Submitted By: William Piel (sfrgpiel)
Assigned to: Mark Dominus (mjdominus)
Summary: submissions with orphaned records cannot be deleted

Initial Comment:
Study_id 22 and 23 have treeblock records that lack phylotree records. This causes errors in the unit tests. But additionally, we cannot delete these submission. (i.e. http://treebasedb-dev.nescent.org:8180/treebase-web/user/deleteStudy.html?submissionid=22 throws and error). Either the orphans should be deleted separately (e.g. with a SQL statement), or the deletion feature should be make capable for deleting them.  The orphaned records can be found like so:

SELECT tb.treeblock_id 
FROM study st JOIN submission sub ON (st.study_id = sub.study_id)
JOIN sub_treeblock stb ON (sub.submission_id = stb.submission_id)
JOIN treeblock tb ON (stb.treeblock_id = tb.treeblock_id)
LEFT JOIN phylotree pt ON (pt.treeblock_id = tb.treeblock_id)
WHERE pt.phylotree_id IS NULL
AND st.study_id = 22


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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2931592&group_id=248804