On Fri, 26 Oct 2007, marcos.sandrini@embryo.com.br wrote:

Bom dia!

Bom dia, to you, too!

- Vidar

From Ingeborg.Hellemo at cc.uit.no Mon Oct 29 13:22:00 2007

From: Ingeborg.Hellemo at cc.uit.no (Ingeborg Hellemo) Date: Mon Oct 29 13:22:02 2007 Subject: [Nav-users] Home > IP Device Center > Services - "We're terribly sorry" Message-ID: 200710291222.l9TCM0oV047496@barnetv.cc.uit.no

NAV 3.3.0

https://<nav-host>/browse/service/ looks like this:

All services dns (3) ftp (1) http (15) https (4) ...

If i click one of the services with a count larger than 1 i get

We're terribly sorry, but something went wrong.. :( Traceback (most recent call last): File "/usr/local/nav/lib/python/nav/web/devBrowser/dispatcher.py", line 104, in handler result = handler.process(request) File "/usr/local/nav/lib/python/nav/web/devBrowser/service.py", line 91, in process return getNetboxes(handler, sort) File "/usr/local/nav/lib/python/nav/web/devBrowser/service.py", line 182, in getNetboxes table = servicetable.ServiceTable(servicenames=(servicename,), sort=sort) File "/usr/local/nav/lib/python/nav/web/devBrowser/servicetable.py", line 95, in __init__ self._findDataSources() File "/usr/local/nav/lib/python/nav/web/devBrowser/servicetable.py", line 114, in _findDataSources cursor.execute(allDataSourcesSQL) ProgrammingError: ERROR: IN types character varying and integer cannot be matched

SELECT rrd_datasourceid, value AS serviceid, name AS ds FROM rrd_datasource JOIN rrd_file ON (rrd_file.rrd_fileid=rrd_datasource.rrd_fileid) WHERE key='serviceid' and value IN (21,26,32,34,20,27,33,29,36,41,2 3,25,35,37,43)

Please fix.

--Ingeborg