[freeside] postgresql error : ExecAppend: Fail to add null value in not null attribute

[Timothy M. Butkiewicz]

Prior to 1.4.1rc1 I was at 1.4.1beta6. Was there that much diff in the schema? 
between these versions?


Quoting ivan at 420.am:

> You upgraded from a prerelease development snapshot prior to
> 1.4.0 and did not make the necessary schema changes.
> 
> I attempt to maintain schema compatibility across major versions
> (1.4.0->1.4.1 etc.) but you should be prepared to track schema changes
> if you're going to run development snapshots.
> 
> You might try the the CVS Attic for upgrade instructions
> <http://www.sisd.com/cgi-bin/viewcvs.cgi/freeside/Attic/>.
> 
> Good luck.
> 
> -- 
> _ivan
> 
> 
> On Tue, May 06, 2003 at 11:50:02AM -0400, Timothy M. Butkiewicz wrote:
> > 
> > Running:
> > Postgresql 7.2.1
> > Apache 1.3.27
> > Redhat 7.2
> > Freeside 1.4.1rc1
> > 
> > Recently updated Freeside to 1.4.1rc1 as well as Postgresl to 7.2.1 (used 
> > pg_dump etc)
> > 
> > First noticed that there was an issue during the freeside-daily cron job
> run. 
> > When customers were being billed, an invoice would generate, but the
> account 
> > would not be paid.
> > 
> > When manually running "Bill Now", the following error is displayed:
> > WARNING: Event run but database not updated - error inserting
> cust_bill_event, 
> > invnum #20483, eventpart 2: ERROR: ExecAppend: Fail to add null value in
> not 
> > null attribute eventnum 
> > 
> > I have checked the postgresql Db and the eventnum field is not read-only.
> Nor 
> > was it set to read-only in the dump. 
> > 
> > During various updates throught Freeside, error are returned when trying to
> 
> > update the database - 
> > 
> > When modifying a DNS entry
> > ERROR: value too long for type character varying(80) 
> > (Apache reports - DBD::Pg::st execute failed: ERROR:  value too long for
> type 
> > character varying(80) at /usr/lib/perl5/site_perl/5.6.1//FS/Record.pm line
> 689.)
> > 
> > Any help would be greatly appreciated.
> > 
> > ----------------------------------------
> > This mail sent through cyberMIND webMAIL
> > 	webmail.cybermind-usa.net
> 
> -- 
> _ivan
> 


+---------------------------- 
Timothy M. Butkiewicz 
 Director of Office Technologies 
 cyberM.I.N.D. 
 877.373.6680 x 20 
 269.373.6680 x 20 
 www.cybermind.biz 
 www.cybermind-usa.net 

Domain Name Sale!!
.COM, .NET and .ORG registrations for $19.95 per year!
.US and .BIZ are on sale for $8.95 per year! 
Transfers are only $13.95 and include a 1 year extension!
http://www.cybermind-usa.net/dns/

----------------------------------------
This mail sent through cyberMIND webMAIL
	webmail.cybermind-usa.net