Feng Forum

Support => Feng Office 2 => : interazioni April 06, 2012, 09:00:06 PM

: Cannot delete member, "it contains objects"
: interazioni April 06, 2012, 09:00:06 PM
I'm trying to delete a workspace.
Nothing is linked to it, it seems completely empty, but I cannot delete it!

is there a way to check which objects are really existing linked to it?
Otherwise, how to force deletion?
Thanks.
: Re: Cannot delete member, "it contains objects"
: printguy April 17, 2012, 11:19:12 AM
I am having the same issue. I have deleted all "objects" from both the member and trash but cannot remove the member itself.

Does anyone have a solution? Is there anyway to force deletion?

Thanks in advance.
: Re: Cannot delete member, "it contains objects"
: interazioni April 17, 2012, 11:31:27 AM
In my case I made a SQL SELECT on project  tables, and found the ID of the project (231 in my case)  then I looked for in other tables and found a linked comment.

SELECT * FROM fo_object_members where member_id = 231;

Found a linked item, id = 471

SELECT * FROM fo_objects where id=471;

DELETE FROM fo_object_members where member_id = 231;

DELETE FROM fo_objects where id=471;

It would be really useful to have an 'admin' function, which displays all items linked to a project (or task/event).

Anyway, when deleting a project, all these links should be deleted as well automatically.

Regards,

Tonino