From rudi@oasis.net.au Wed Feb 13 07:16:00 2002 Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1D7G0E78398 for ; Wed, 13 Feb 2002 02:16:00 -0500 (EST) (envelope-from rudi@oasis.net.au) Received: from sun (palm.oasis.net.au [210.8.139.3]) by water.oasis.net.au (8.9.3/100.1) with SMTP id RAA17602 for ; Wed, 13 Feb 2002 17:35:55 +1000 X-Authentication-Warning: water.oasis.net.au: Host palm.oasis.net.au [210.8.139.3] claimed to be sun Message-ID: <006301c1b45f$46f83910$0c00a8c0@sun> From: "rudi" To: Subject: php and Postgres 7.2 Date: Wed, 13 Feb 2002 17:23:04 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0060_01C1B4B3.18981410" 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: 200202/40 X-Sequence-Number: 946 This is a multi-part message in MIME format. ------=_NextPart_000_0060_01C1B4B3.18981410 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello friends, Just a quick email to let you know of my experience upgrading on php apps. using Postgres 7.1.3 to 7.2 The only problem I found was with phorum ( www.phorum.org ) I tried the last 2 releases and both would throw this error when creating a= new forum : Could not add forum to the main table (forums). Database error: ERROR: value too long for type character(1) . I'm not sure why this is occurring but the solution was to run everything o= n 7.2 except for this forum application which remains on another box using 7.1.3 I don't know if its : a) the phorum code b) php c) Postgres 7.2 But I though you may be interested so I've posted it anyway. Thanks for your time Kind regards=20 Rudi. ------=_NextPart_000_0060_01C1B4B3.18981410 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello friends,
 
Just a quick email to let you k= now of my=20 experience upgrading on php apps.
using Postgres 7.1.3 to 7.2
 
The only problem I found was wi= th phorum=20 ( www.phorum.org )
 
I tried the last 2 releases and= both=20 would throw this error when creating a new forum :
 
Could not add forum to the main= table=20 (forums).
Database error: ERROR: value too long for type character(1)=20 .
 
I'm not sure why this is occurr= ing but=20 the solution was to run everything on 7.2
except for this forum applicati= on which=20 remains on another box using 7.1.3
 
I don't know if its :
a) the phorum code
b) php
c) Postgres 7.2
 
But I though you may be interes= ted so=20 I've posted it anyway.
Thanks for your time
Kind regards
Rudi.
 

------=_NextPart_000_0060_01C1B4B3.18981410-- From andrew@catalyst.net.nz Wed Feb 13 09:17:29 2002 Received: from heidegger.catalyst.net.nz (203-96-145-196.adsl.paradise.net.nz [203.96.145.196]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1D9HTE17786 for ; Wed, 13 Feb 2002 04:17:29 -0500 (EST) (envelope-from andrew@catalyst.net.nz) Received: from 127.0.0.1 (ident=unknown) by heidegger.catalyst.net.nz with esmtp (MasqMail 0.1.16) id 16avWf-7S4-00; Wed, 13 Feb 2002 22:16:29 +1300 Subject: Re: php and Postgres 7.2 From: Andrew McMillan To: rudi Cc: pgsql-php@postgresql.org In-Reply-To: <006301c1b45f$46f83910$0c00a8c0@sun> References: <006301c1b45f$46f83910$0c00a8c0@sun> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2 Date: 13 Feb 2002 22:16:29 +1300 Message-Id: <1013591789.10410.116.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Archive-Number: 200202/41 X-Sequence-Number: 947 On Wed, 2002-02-13 at 20:23, rudi wrote: > Hello friends, > > Just a quick email to let you know of my experience upgrading on php apps. > using Postgres 7.1.3 to 7.2 > > The only problem I found was with phorum ( www.phorum.org ) > > I tried the last 2 releases and both would throw this error when creating a new forum : > > Could not add forum to the main table (forums). > Database error: ERROR: value too long for type character(1) . > > I'm not sure why this is occurring but the solution was to run everything on 7.2 > except for this forum application which remains on another box using 7.1.3 > > I don't know if its : > a) the phorum code > b) php > c) Postgres 7.2 > > But I though you may be interested so I've posted it anyway. Someone will correct me if I'm wrong, but 7.1 would silently truncate a value and insert it into the CHAR(1) field. I think what 7.2 is doing is throwing an error when you try to insert a value like 'fred' into such a field where 7.1 would have just put 'f' into the char(1) field. It is probably a bug in phorum for it to be trying to put multi-character values into a char(1) field, so I would tend to look there first. Regards, Andrew. -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Are you enrolled at http://schoolreunions.co.nz/ yet?