Author Topic: Cannot delete member, "it contains objects"  (Read 3668 times)

interazioni

  • Newbie
  • *
  • Posts: 4
    • View Profile
Cannot delete member, "it contains objects"
« on: 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.

printguy

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Cannot delete member, "it contains objects"
« Reply #1 on: 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.

interazioni

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Cannot delete member, "it contains objects"
« Reply #2 on: 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