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ø