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