I just found another probably related bug, which I don't think is subcat related at all.

I can reproduce kind of the same error with http://nav.foo.com/report/modules?typeid=XXX:

"Configuration error! The report generator is not able to do such things. column "typeid" does not exist LINE 1: ...duleid) tempaggr2 USING (moduleid)) AS foo WHERE typeid = '... ^"

-Vidar

-----Opprinnelig melding----- Fra: nav-users-request@uninett.no [mailto:nav-users-request@uninett.no] På vegne av Ingeborg Hellemo Sendt: 14. desember 2011 11:13 Til: nav-users@uninett.no Emne: Bug in reports, subcategories

We use subcategories extensively. There is a bug in the report generator related to subcats.

Howto reproduce:

• Goto Home > Report > Server (or some other category with

subcategories).

• Click on subcats for a server which belongs to a subcategory. You are

now in https://nav.uit.no/report/netboxinfo?netboxid=(#ofnetbox).

• Click on the name of a subcategory
• You will now enter

https://nav.uit.no/report/netboxinfo?category=(Name of subcat)>

Lo and behold:

Netboxinfo Configuration error! The report generator is not able to do such things. column "category" does not exist LINE 1: ...IN netboxcategory USING (netboxid)) AS foo WHERE category =... ^

-- Ingeborg Østrem Hellemo -- ingeborg.hellemo@uit.no Dep. of Information Technology --- Univ. of Tromsø