Re: [dspace-tech] dspace 6.1 delete community foreignkey-constraint community2community_child_comm_id_fkey

2017-11-29 Thread Paul Warner 
Hi,

Just in case it helps someone, I ended up deleting the row in the
community2community table for each of the collections I needed to delete.
Then I could delete them from the admin interface.  I can confirm that
there does not seem to be any fallout from doing this, and now my site is
reorganized in the way the client wanted.

Here is a tip for anyone faced with this situation.  The uuid you need to
find the right row in the community2community table is a uuid, not a
string.  But you can still find it in postgresql by converting it to a
string and comparing it to the beginning of the uuid using like:

select * from community2community where child_comm_id::varchar like '06f%';
delete from community2community where child_comm_id::varchar like '06f%';

Best regards,
Paul

On Thu, Nov 23, 2017 at 10:39 AM, Paul Warner  wrote:

> Thanks for this, Terry.  That is exactly what I am doing.  I sign on to
> the web ui, in our case jspui, and try to delete the community.  I get an
> error message in the browser that there was a system error, and if it
> continues, I should contact the administrator.  When I look in the dspace
> log, I can see the exception about the foreign key constraint, etc.
>
> I should say, I deleted a few communities just before I tried this one,
> and they went away quietly, without error messages.  Then this community
> threw this error, and any other community deletions that I try now throw
> the same error.  I can see the entry for this community in the
> community2community table as the child of the top level community.
>
> Best regards,
> Paul
>
> On Wed, Nov 22, 2017 at 4:51 PM, Terry Brady 
> wrote:
>
>> This does not directly answer your question, but it might be helpful.
>>
>> I sign into the UI as a repository administrator when I want to delete
>> communities, collections, and items.  The code handles all of the
>> dependencies when deleting.
>>
>> On Wed, Nov 22, 2017 at 6:19 AM, Paul Warner 
>> wrote:
>>
>>> Hi all,
>>>
>>> I am running DSpace 6.1 on Suse.
>>>
>>> I have tried to delete a community I just created, since I found a
>>> different way to solve my organization problem.  I got an error that the
>>> update or delete in the table 'community' violates foreignkey-constraint
>>> 'community2community_child_comm_id_fkey' from the table
>>> 'community2community'.
>>>
>>> I have seen some posts from earlier versions of dspace saying that these
>>> constraints and even the tables themselves are no longer needed.  Should I
>>> be seeing this error then with DSpace 6.1?  I will alter or delete the
>>> tables if that is what I should do - but I just want to make sure that is
>>> still the right thing to do.  I presume it is irreversible, and I don't
>>> want to damage my installation.
>>>
>>> Thanks!
>>>
>>> Best regards,
>>> Paul
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "DSpace Technical Support" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to dspace-tech+unsubscr...@googlegroups.com.
>>> To post to this group, send email to dspace-tech@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/dspace-tech.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Terry Brady
>> Applications Programmer Analyst
>> Georgetown University Library Information Technology
>> https://github.com/terrywbrady/info
>> 425-298-5498 <(425)%20298-5498> (Seattle, WA)
>>
>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "DSpace Technical Support" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/dspace-tech/Ihb0hInEqFU/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] dspace 6.1 delete community foreignkey-constraint community2community_child_comm_id_fkey

2017-11-23 Thread Paul Warner 
Thanks for this, Terry.  That is exactly what I am doing.  I sign on to the
web ui, in our case jspui, and try to delete the community.  I get an error
message in the browser that there was a system error, and if it continues,
I should contact the administrator.  When I look in the dspace log, I can
see the exception about the foreign key constraint, etc.

I should say, I deleted a few communities just before I tried this one, and
they went away quietly, without error messages.  Then this community threw
this error, and any other community deletions that I try now throw the same
error.  I can see the entry for this community in the community2community
table as the child of the top level community.

Best regards,
Paul

On Wed, Nov 22, 2017 at 4:51 PM, Terry Brady 
wrote:

> This does not directly answer your question, but it might be helpful.
>
> I sign into the UI as a repository administrator when I want to delete
> communities, collections, and items.  The code handles all of the
> dependencies when deleting.
>
> On Wed, Nov 22, 2017 at 6:19 AM, Paul Warner 
> wrote:
>
>> Hi all,
>>
>> I am running DSpace 6.1 on Suse.
>>
>> I have tried to delete a community I just created, since I found a
>> different way to solve my organization problem.  I got an error that the
>> update or delete in the table 'community' violates foreignkey-constraint
>> 'community2community_child_comm_id_fkey' from the table
>> 'community2community'.
>>
>> I have seen some posts from earlier versions of dspace saying that these
>> constraints and even the tables themselves are no longer needed.  Should I
>> be seeing this error then with DSpace 6.1?  I will alter or delete the
>> tables if that is what I should do - but I just want to make sure that is
>> still the right thing to do.  I presume it is irreversible, and I don't
>> want to damage my installation.
>>
>> Thanks!
>>
>> Best regards,
>> Paul
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Terry Brady
> Applications Programmer Analyst
> Georgetown University Library Information Technology
> https://github.com/terrywbrady/info
> 425-298-5498 <(425)%20298-5498> (Seattle, WA)
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "DSpace Technical Support" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/dspace-tech/Ihb0hInEqFU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] dspace 6.1 delete community foreignkey-constraint community2community_child_comm_id_fkey

2017-11-22 Thread Terry Brady 
This does not directly answer your question, but it might be helpful.

I sign into the UI as a repository administrator when I want to delete
communities, collections, and items.  The code handles all of the
dependencies when deleting.

On Wed, Nov 22, 2017 at 6:19 AM, Paul Warner  wrote:

> Hi all,
>
> I am running DSpace 6.1 on Suse.
>
> I have tried to delete a community I just created, since I found a
> different way to solve my organization problem.  I got an error that the
> update or delete in the table 'community' violates foreignkey-constraint
> 'community2community_child_comm_id_fkey' from the table
> 'community2community'.
>
> I have seen some posts from earlier versions of dspace saying that these
> constraints and even the tables themselves are no longer needed.  Should I
> be seeing this error then with DSpace 6.1?  I will alter or delete the
> tables if that is what I should do - but I just want to make sure that is
> still the right thing to do.  I presume it is irreversible, and I don't
> want to damage my installation.
>
> Thanks!
>
> Best regards,
> Paul
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Terry Brady
Applications Programmer Analyst
Georgetown University Library Information Technology
https://github.com/terrywbrady/info
425-298-5498 (Seattle, WA)

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] dspace 6.1 delete community foreignkey-constraint community2community_child_comm_id_fkey

2017-11-22 Thread Paul Warner 
Hi all,

I am running DSpace 6.1 on Suse.

I have tried to delete a community I just created, since I found a 
different way to solve my organization problem.  I got an error that the 
update or delete in the table 'community' violates foreignkey-constraint 
'community2community_child_comm_id_fkey' from the table 
'community2community'.

I have seen some posts from earlier versions of dspace saying that these 
constraints and even the tables themselves are no longer needed.  Should I 
be seeing this error then with DSpace 6.1?  I will alter or delete the 
tables if that is what I should do - but I just want to make sure that is 
still the right thing to do.  I presume it is irreversible, and I don't 
want to damage my installation.

Thanks!

Best regards,
Paul

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.