...

...

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