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

ivan at 420.am ivan at 420.am
Tue Jul 29 14:51:18 PDT 2003


On Tue, Jul 29, 2003 at 05:17:24PM -0400, jbd wrote:
> Ivan - I removed the column and continued to get the same error.

Seems unlikely.  Can't hurt to try re-running dbdef-create.

-- 
_ivan


> 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

-- 
_ivan



More information about the freeside-users mailing list