Page 1 of 1

Remove categories

PostPosted:Mon Jan 11, 2016 2:26 pm
by welcomeweb
Good day,
i would like to know how i can remove categories.
Not on a single document, but in the whole system OpenKM.

Thank you
Best regards
Elena

Re: Remove categories

PostPosted:Mon Jan 11, 2016 2:37 pm
by welcomeweb
I don't have any document or folder, but when i try to remove categories i have an error message:
OKM-001009(Delete): Access to folder denied
Cant' delete a category in use
How can I unlock access?

Re: Remove categories

PostPosted:Wed Jan 13, 2016 3:26 pm
by jllort
This behavior is caused by a feature to ensure data integrity. The problem is that you can not remove categories what are still assigned to an objects ( documents, folders etc... ) first must be removed these relations. For doing it, could create a minimal script, or do a database update, or go to categories view and remove one by one ( I do not know about how many do you have ).

Re: Remove categories

PostPosted:Fri Jan 15, 2016 7:52 am
by welcomeweb
Good day,
thank you for your reply.
There is not any document or folder assigned to categories, this is the problem.

Can you write to me some script to resolve my problem.

Thank you

Best regards.
Elena

Re: Remove categories

PostPosted:Sun Jan 17, 2016 11:11 am
by jllort
Are you administrator ? could be a document assigned hidden to you ( or in trash ).

Go to administration database query and execute ( uuid is the node uuid category folder, you can copy from properties tab when folder is selected ):
Code: Select all
SELECT * FROM OKM_NODE_CATEGORY where NCT_CATEGORY='6a63897f-3476-4d4e-b693-eb48023332f7';