Ingeborg Hellemo Ingeborg.Hellemo@cc.uit.no 07.12.2005 10:09:33
I think we have the same problem. I have made a public filter, but when I include this in my personal filter group I don't receive alerts that match the filter. If I make my own filters or filtergroups things works as expected.
Perhaps it has something to do with settings in the "Public Access" page?
--Ingeborg
Do mean that alerts based on Sub category works with your own filters/filter? I did not get it to work at, all based on Sub category
Peder Sefland
From perica at akton.com.mk Fri Dec 9 14:32:28 2005
From: perica at akton.com.mk (Perica Veljanovski) Date: Fri Dec 9 14:32:41 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory Message-ID: CARMENKicUbvBDxroC600000068@carmen.akton.si
Hi,
I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble setting everything up :) and apparently still have some troubles.
Some parts of the web interface show errors, and because I'm just starting to seed the db I will begin from there:
So, I added some locations, rooms, organizations, vendors, types. Everything worked fine until I tried to add an ip device. Then I got this error:
---
Mod_python error: "PythonHandler editdb"
Traceback (most recent call last):
File "/usr/local/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch
result = object(req)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler
output = editPage(req,pageList[table](),request,unicodeError)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 524, in editPage
listView.fill(req)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 798, in fill
tooltipDef[2] = executeSQLreturn(sql)
File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 45, in executeSQLreturn
database.execute(sql)
ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory"
SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid
---
The same error appears when I try to edit ip devices. I did a select * query to manage.netbox and my device is there! Netboxcategory is empty, so I gather that the problem lies there but don't know what should be in it? Is this because I missed a step or maybe because I started to seed with a new device type.
Also I've read the mailing lists archive and see that you've reported a "unexpected EOF on client connection" error from postgresql, which I also have! I didn't find a reference on how to confront this problem though? I haven't got to that point yet, but it would be nice to have some input. Note: my /alertprofiles/ doesn't work at all :) when I click it from /toolbox/ I get a blank screen.
Thanks ahead