Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E54C1476114 for ; Wed, 1 May 2002 13:04:24 -0400 (EDT) Received: from VL-MS-MR004.sc1.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 7F57647602D for ; Wed, 1 May 2002 12:56:39 -0400 (EDT) Received: from pippo.videotron.ca ([24.201.226.11]) by VL-MS-MR004.sc1.videotron.ca (Netscape Messaging Server 4.15) with ESMTP id GVFZ2J03.LHR; Wed, 1 May 2002 12:56:43 -0400 Message-Id: <5.1.0.14.2.20020501124852.00aab2b0@pop.videotron.ca> X-Sender: vltazczw@pop.videotron.ca X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Wed, 01 May 2002 12:56:45 -0400 To: "Rod Taylor" From: "P. Jourdan" Subject: Re: sql commands Cc: pgsql-php@postgresql.org In-Reply-To: <215c01c1f12e$8ad614c0$ad02000a@jester> References: <5.1.0.14.2.20020501120049.00a82388@mail.host45.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200205/3 X-Sequence-Number: 1135 At 12:37 PM 5/1/2002 -0400, you wrote: >sqlconnect / sqlget, etc. must be an extension that the original >author used. It's not standard with php, but is a good idea. > >I'm guessing the SELECT is an sql statement, not a function correct? yes >What are the errors returned by the script when it runs? I just accessed the local site & I get the following: ERROR: Relation 'visits'does not have attribute 'path' ERROR: Bad boolean external representation 'YES>' ERROR: Relation "mustdie" does not exist NOTICE: Adding missing FROM-clause entry for table "customer" ERROR: No such atribute or function 'pcustomer_id' I believe I understand that some fields or columns are missing as well as variables or other elements... but what is strange, is that this happens only in the administrative end and not on the site pages. I can send a snippet of the php file or the whole file, for that matter. They are not very big. I have also gotten this: FATAL 1: Database :"template0" is not currently accepting connections I do not understand what is the use of the "template0" - is it the base "model" for newly created databases? I was under the impression that that was template1... Thanks for your help Philip