But if you edit /usr/local/nav/etc/report/front.html and replaces trunk=1 with trunk=t in line 80 the report works.
Yes, this should be changed. '1' is not a valid value for a boolean field.
GROUP BY roomid,sysname,host(ip),catid,orgid,val,netbox.netboxid,netbox.ip,prefix id";
Someone probably forgot to include the netbox.ip column in the query. Morten, can you check in these two changes (I could too, but I am not sure what the current state of the subversion tree is)?
-- Kristian