Forum GLPI-Project

musd

Member

Registered: 2012-02-07

Posts: 4

is_recursive and glpi_itilcategories and glpi_locations,

Hello,

We recently updated our category lists and were able to keep and hide our old categories by changing the Visible flags in the Dropdowns > Ticket Categories.

There was an issue with only two of the new categories showing up for us, however when creating a new ticket or editing one submitted via email.

I did a little digging in the MySQL backend and discovered that is_recursive happened to be set to 1 on the items that showed up. These were part of the categories that were not hidden.

I was able to get the new categories to show up by changing is_recursive from 0 to 1. All categories now show up as we expect.

Would anyone be able to explain what this is the case and how I would allow is_recursive to be 1.

**edit** it seems that the is_recursive is set by Child entities = Yes (results in 1) or No (results in 0)

Is there any danger in setting this to 1 via MySQL. I did notice that on some of the categories that were hidden, I get a "linked categories exist. flag change forbidden" and there is no dropdown, only text.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,273

Re: is_recursive and glpi_itilcategories and glpi_locations,

Is-recursive set to 1 means that all sub-entities will see this category

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)