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?
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
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
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
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 798, in fill
tooltipDef = executeSQLreturn(sql)
File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 45, in executeSQLreturn
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.