Warning: pg_exec() query failed: ERROR: Attribute "admin" not found

From: "Mark Quinn" <mdquinn(at)mail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Warning: pg_exec() query failed: ERROR: Attribute "admin" not found
Date: 2005-02-27 19:15:11
Message-ID: 20050227191511.626B54BDAA@ws1-1.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<P>Hello to all -</P>
<P>I am trying to get an application called "Keystone" working using Postgres as the DB. The app seems to be working (IE I can add records to the DB, etc.) , but I keep getting this error message: "Warning: pg_exec() query failed: ERROR: Attribute "admin" not found in /var/www/html/keystone2/postgres.php3 on line 47".&nbsp; (admin is the current user I am signed in to the app as). Here are the lines of code that are executed before and after line 47:</P>
<P>45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; function db_query ($qstring) {<BR>46&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; global $conn, $pg_curr_row;<BR>47&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $result = pg_Exec ($conn, "$qstring");<BR>48&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # This will break if different connections return the<BR>49&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # same query handle index (probable?).<BR>50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $pg_curr_row[$result] = 0;<BR>51&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $result;<BR>52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; };</P>
<P>I have tried to ask for help in the list for the app itself, but there does not appear to be any activity over there. I also tried to contact the developer of the app, but have been unsuccessful with that also. I know very little about Postgres, and hope someone out there can give me some suggestions as to what may be causing this error. Here are the particulars of the system the app is installed on: RedHat 9 with all the patches installed, Postgres 4.2.2, Apache 2.0.40, PHP 4.2.2.</P>
<P>Thanks very much in advance to anyone who can help!</P>
<P>Mark</P><BR>
--
<p>___________________________________________________________<br>Sign-up for Ads Free at Mail.com<br>
<a href="http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfreejump01" target="_blank">http://www.mail.com/?sr=signup</a></p>

Attachment Content-Type Size
unknown_filename text/html 2.2 KB

Browse pgsql-novice by date

  From Date Subject
Next Message Deepblues 2005-02-27 19:15:58 Import csv file into multiple tables in Postgres
Previous Message Wolfgang Keller 2005-02-27 15:59:14 PL/Pgsql or PL/Python?