Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 06DC6476169 for ; Wed, 1 May 2002 13:27:54 -0400 (EDT) Received: from squire.barchord.com (squire.barchord.com [216.194.67.18]) by postgresql.org (Postfix) with ESMTP id 09C0F47622D for ; Wed, 1 May 2002 13:04:48 -0400 (EDT) Received: from jester (nat.inquent.com [216.6.14.45]) by squire.barchord.com (Postfix) with SMTP id 52E12B3; Wed, 1 May 2002 13:04:47 -0400 (EDT) Message-ID: <216601c1f132$22f0f4c0$ad02000a@jester> From: "Rod Taylor" To: "P. Jourdan" Cc: References: <5.1.0.14.2.20020501120049.00a82388@mail.host45.com> <5.1.0.14.2.20020501124852.00aab2b0@pop.videotron.ca> Subject: Re: sql commands Date: Wed, 1 May 2002 13:03:37 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/4 X-Sequence-Number: 1136 > >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 ' color=red>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. Yes, it's quite obvious that you are missing some of the columns / relations the code expects. The reason it works on the client side is probably that the columns / relations are not being used in it. I'd need more than just the php code. It interacts with the database. I'll need a dump of it as well. Please send directly, not to the list. > 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... template0 is like an emergency backup to template1. Template1 can be mucked with. If you want it back to original you drop it and recreate it with template0. There is no reason you should be connecting to it.