-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/12/2005 17:20, Perica Veljanovski uttered:
ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory"
SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid --- Now I have no experience with postgressql, but have about 5 years of mysql experience, and this query doesn't make much since to me. There is no reference to netboxcategory in the FROM clause, but the SELECT uses it!?
Thanks for your analysis, but you didn't need to go through all this trouble :) As I said, there is a bug in EditDB which seems to appear when there are no netboxcategories (I cannot immediately confirm this claim, as I have no clean installation to test it on at the moment, and I don't see this error on our current installation). Since the SQL statement is generated in a number of steps, fixing the bug is not as simple as just rewriting a hard coded query in the code. That's why I said I'll have to look into it further (I didn't write the editdb code, but it seems to be monstrously big and all lumped into one single Python module).
Morten, I have a favor to ask. Since I have a deadline until Monday to get NAV running (or we will use cacti+kannel), could you look into my ip devices->edit problem. I'm more of a Perl guy, so Python is new to me.
I haven't been to work since Thursday, so I didn't read this until now. I'll be taking a closer look into this today, so we'll see what happens. - -- Morten Vold, ITEA, NTNU A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDpnW/XxIl0kpcOkQRAoQ8AJ0dU6ksiY+xH+X98+kL4mE3zsFqSgCfcAlT gCxjwpf7vmLZ3FBrPL1IWqE= =5jPB -----END PGP SIGNATURE-----
From morten.vold at ntnu.no Mon Dec 19 10:28:35 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Mon Dec 19 10:28:34 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <CARMENbC8wSA1XvpFVj00000042@carmen.akton.si> References: <CARMENbC8wSA1XvpFVj00000042@carmen.akton.si> Message-ID: <43A67D43.3090707@ntnu.no>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/12/2005 17:20, Perica Veljanovski uttered:
ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory"
SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid
Having looked slightly closer at it now, I would like to know which PostgreSQL version you are running? I realize that this piece of SQL still has errors in it, but both PostgreSQL 7.4 and PostgreSQL 8.0 seem to be very forgiving in this situation. When I issue this statement on these databases, PostgreSQL tells me: NOTICE: adding missing FROM-clause entry for table "netboxcategory" This tells me that the bug probably isn't related to the contents of any table at all, but to PostgreSQL version or configuration. The reason we've never discovered the bug before is that our PostgreSQL installations have fixed the SQL statement for us. - -- Morten Vold, ITEA, NTNU A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDpn1CXxIl0kpcOkQRAuUcAJ4+JWsgkdx1SCPBU7KsqXa6wKEDXACcCgEu li2UFbNeRMV7WR93viRyuZs= =E03s -----END PGP SIGNATURE-----
From perica at akton.com.mk Mon Dec 19 10:54:46 2005 From: perica at akton.com.mk (Perica Veljanovski) Date: Mon Dec 19 10:54:59 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: <43A67D43.3090707@ntnu.no> Message-ID: <CARMENtIIZS2TRqf69a0000011f@carmen.akton.si>
-----Original Message----- From: Morten Vold [mailto:morten.vold@ntnu.no] Sent: Monday, December 19, 2005 10:29 To: Perica Veljanovski Cc: nav-users@itea.ntnu.no Subject: Re: [Nav-users] missing FROM-clause entry for table netboxcategory
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 15/12/2005 17:20, Perica Veljanovski uttered:
ProgrammingError: ERROR: missing FROM-clause entry for table "netboxcategory"
SELECT netboxid,netboxcategory.category FROM netbox WHERE netboxcategory.netboxid=netboxid
Having looked slightly closer at it now, I would like to know which PostgreSQL version you are running?
I realize that this piece of SQL still has errors in it, but both PostgreSQL 7.4 and PostgreSQL 8.0 seem to be very forgiving in this situation. When I issue this statement on these databases, PostgreSQL tells me:
NOTICE: adding missing FROM-clause entry for table "netboxcategory"
This tells me that the bug probably isn't related to the contents of any table at all, but to PostgreSQL version or configuration. The reason we've never discovered the bug before is that our PostgreSQL installations have fixed the SQL statement for us.
- -- Morten Vold, ITEA, NTNU
A: Because it messes up the order in which people normally read text. Q: Why is it such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet and in e-mail? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDpn1CXxIl0kpcOkQRAuUcAJ4+JWsgkdx1SCPBU7KsqXa6wKEDXACcCgEu li2UFbNeRMV7WR93viRyuZs= =E03s -----END PGP SIGNATURE-----
Thanks for taking the time mate! postgresql-server-8.1.0 postgresql-client-8.1.0