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?
