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 allSELECT * FROM OKM_NODE_CATEGORY where NCT_CATEGORY='6a63897f-3476-4d4e-b693-eb48023332f7';