[freeside] Adding Export -->Fail to add null value in not null attribute deprecated

[jbd]

Ivan - I removed the column and continued to get the same error. Any
ideas

-----Original Message-----
From: ivan at 420.am [mailto:ivan at 420.am] 
Sent: Tuesday, July 29, 2003 1:25 PM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] Adding Export -->Fail to add null value in not
null attribute deprecated

On Tue, Jul 29, 2003 at 12:21:05PM -0400, jbd wrote:
> I'm having issues adding a new export. The error I'm getting is :
> 
> Error: ERROR: ExecAppend: Fail to add null value in not null attribute
> deprecated
> 
> The exportnum is not being generated, and is trying to insert the new
> export without this information, hence the error. 
> 
> Server Details
> OS - Debian Woody
> PSQL -7.1.3
> Apache 1.3.26
> Freeside 1.4.1rc3
> 
> I also have a dev server running the exact same thing, except using
> Freeside 1.4.0 and do not have this problem. 
> 
> I have compared the two over and over, the part_export.cgi,
> part_export.pm, etc and can't figure out why I can't get it to work on
> the newer version of Freeside. 
> 
> Side notes;
> Couple of differences I have found, that I have been unable to confirm
> in docs as Freeside version differences are :
> 
> a) My 1.4.1rc3 has an extra field part_export.deprecated. This field
is
> not present in my 1.4.0 server, I found it strange as the error
mentions
> :deprecated. 

part_export.deprecated is a relic from running a database from a 1.4.0
prerelease.  Remove the column from your database.

> b) Can anyone confirm that Freeside 1.4.1rc3 works 100% with psql
7.1.3.
> 
> I ask because FAQ's state that 1.4.0 has a few flaws with the new psql
> 7.3, was curious if the reverse setup (fs1.4.1x no longer worked with
> older psql versions as it was changed to work with psql 7.3)

1.4.1 works with all PostgreSQL 7.x versions.

-- 
_ivan