>>> Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> 07.12.2005 10:09:33
I think we have the same problem. I have made a public filter, but when
include this in my personal filter group I don't receive alerts that
filter. If I make my own filters or filtergroups things works as
Perhaps it has something to do with settings in the "Public Access"
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
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
output = editPage(req,pageList[table](),request,unicodeError)
File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 524, in
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
ProgrammingError: ERROR: missing FROM-clause entry for table
SELECT netboxid,netboxcategory.category FROM netbox WHERE
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
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.