Advanced search in reports crashes in Internet Explorer

[Vidar Stokkenes]

Internet Explorer seems to be handling the "Advanced Search" scheme a bit different than Mozilla Firefox (I haven't tried with other browsers yet)

If you pop up Advanced Search in any Report view (All IP Devices, for example) and define a custom search (in any variable name search) NAV will return an error similar to this one:

Configuration error! The report generator is not able to do such things. ERROR: column "r4g3n53nd" does not exist SELECT locationid,roomid,sysname,ip,catid,sub,typeid,typename,orgid,netbox.up,modules,swport,gwport,prefixcount,CASE WHEN Mem THEN 'Mem' ELSE NULL END AS Mem,snmp,sw_ver AS Software,serial,val AS Function,netbox.netboxid,prefixid FROM type RIGHT OUTER JOIN netbox USING (typeid) LEFT JOIN room USING (roomid) LEFT JOIN (SELECT netboxid,count(netboxid) AS gwport FROM gwport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM netboxsnmpoid GROUP BY netboxid) tempaggr5 USING (netboxid) LEFT JOIN (SELECT netboxid, count(netboxid) > 0 AS Mem FROM mem GROUP by netboxid) tempaggr6 USING (netboxid) LEFT JOIN (SELECT netboxid, count(gwportid) AS prefixcount FROM gwportprefix JOIN gwport USING (gwportid) JOIN module USING (moduleid) GROUP BY netboxid) tempaggr7 USING (netboxid) LEFT JOIN device ON (netbox.deviceid=device.deviceid) LEFT JOIN netboxinfo ON (netbox.netboxid=netboxinfo.netboxid AND var='function') WHERE r4g3n53nd = 'Search' AND locationid = 'SW' ORDER BY locationid,roomid

It doesn't seem to matter what you search specifically for (Room, Org, Type, etc) it will return a similar error anyway. It seems like Internet Explorer sends the "Search" button name (r4g3n53nd) inside the URI while other readers (such as Mozilla Firefox) ignores it.

So I guess that needs some fixage.

[Vidar Stokkenes (vidarst)]

I forgot to mention the URI differences from MS Internet Explorer to Mozilla Firefox.

If you search specifically ( = ) for the "SW" category, the Internet Explorer URI will appear like this:

https://nav.domain.fqdn/report/netbox?catid=SW&r4g3n53nd=Search&op_catid=eq

While using Mozilla Firefox, the URI appears like this:

https://nav.domain.fqdn/report/netbox?catid=SW&op_catid=eq

As mentioned in the original post, the error appears no matter what you search for and if you're using ~, =, =>, =<, etc.

[Vidar Stokkenes (vidarst)]

Sigh,

The debug message above doesn't match the scenario of the example URIs. If using the example criterias, the error debug msg looks like this:

Configuration error! The report generator is not able to do such things. ERROR: column "r4g3n53nd" does not exist SELECT locationid,roomid,sysname,ip,catid,sub,typeid,typename,orgid,netbox.up,modules,swport,gwport,prefixcount,CASE WHEN Mem THEN 'Mem' ELSE NULL END AS Mem,snmp,sw_ver AS Software,serial,val AS Function,netbox.netboxid,prefixid FROM type RIGHT OUTER JOIN netbox USING (typeid) LEFT JOIN room USING (roomid) LEFT JOIN (SELECT netboxid,count(netboxid) AS gwport FROM gwport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM netboxsnmpoid GROUP BY netboxid) tempaggr5 USING (netboxid) LEFT JOIN (SELECT netboxid, count(netboxid) > 0 AS Mem FROM mem GROUP by netboxid) tempaggr6 USING (netboxid) LEFT JOIN (SELECT netboxid, count(gwportid) AS prefixcount FROM gwportprefix JOIN gwport USING (gwportid) JOIN module USING (moduleid) GROUP BY netboxid) tempaggr7 USING (netboxid) LEFT JOIN device ON (netbox.deviceid=device.deviceid) LEFT JOIN netboxinfo ON (netbox.netboxid=netboxinfo.netboxid AND var='function') WHERE r4g3n53nd = 'Search' AND catid = 'SW' ORDER BY locationid,roomid

[Morten Brekkevold (mbrekkevold)]

I can confirm this on IE6, at least. As I mentioned on nav-users, this bug appears to be fixed on the default branch, so I can guess that it's just a matter of backporting the fix to the stable 3.5.x branch.

[Vidar Stokkenes (vidarst)]

IE7 as well. Opera and Firefox however seems to handle the button just fine.

[Morten Brekkevold (mbrekkevold)]

Fix committed and pushed to series/3.5.x: http://metanav.uninett.no/hg/series/3.5.x/rev/dfb43af66910