[freeside] freeside-daily question

[Erich Zigler]

On Friday 31 May 2002 03:31 pm, ivan wrote:

Patch applied.

Error Message:

$ freeside-daily erich
DBD::Pg::st execute failed: ERROR:  ExecAppend: Fail to add null value in not 
null attribute state at /usr/local/lib/perl5/site_perl/5.005/FS/Record.pm 
line 524.
NOTICE:  current transaction is aborted, queries ignored until end of 
transaction block
DBD::Pg::st fetchall_arrayref failed: no statement executing at 
/usr/local/lib/perl5/site_perl/5.005/FS/Record.pm line 280.
WARNING: Event run but database not updated - error inserting cust_bill_event, 
invnum #239, eventpart 2: Unknown invnum at 
/usr/local/lib/perl5/site_perl/5.005/FS/cust_main.pm line 1279.
Error collecting, custnum88: WARNING: Event run but database not updated - 
error inserting cust_bill_event, invnum #239, eventpart 2: Unknown invnum at 
/usr/local/bin/freeside-daily line 43.


> Apply this patch and report the error message.
>
> Index: cust_bill.pm
> ===================================================================
> RCS file: /home/cvs/cvsroot/freeside/FS/FS/cust_bill.pm,v
> retrieving revision 1.35
> diff -u -r1.35 cust_bill.pm
> --- cust_bill.pm        2002/05/18 09:51:30     1.35
> +++ cust_bill.pm        2002/05/31 20:30:07
> @@ -726,8 +726,10 @@
>      'payname'  => $cust_main->getfield('payname'),
>      'amount'   => $self->owed,
>    } );
> -  $cust_pay_batch->insert;
> +  my $error = $cust_pay_batch->insert;
> +  die $error if $error;
>
> +  '';
>  }
>
>  =item print_text [TIME];
>
> On Fri, May 31, 2002 at 02:53:41PM -0500, Erich Zigler wrote:
> > When I run freeside-1.4.0pre13's freeside-daily I get the following
> > error.... The only change I've made to my perl modules is the sqlradius
> > export patch Ivan posted a week ago.
> >
> > $ freeside-daily erich
> > DBD::Pg::st execute failed: ERROR:  ExecAppend: Fail to add null value in
> > not null attribute state at
> > /usr/local/lib/perl5/site_perl/5.005/FS/Record.pm line 524.
> > NOTICE:  current transaction is aborted, queries ignored until end of
> > transaction block
> > DBD::Pg::st fetchall_arrayref failed: no statement executing at
> > /usr/local/lib/perl5/site_perl/5.005/FS/Record.pm line 280.
> > WARNING: Event run but database not updated - error inserting
> > cust_bill_event, invnum #239, eventpart 2: Unknown invnum at
> > /usr/local/lib/perl5/site_perl/5.005/FS/cust_main.pm line 1279.
> > Error collecting, custnum88: WARNING: Event run but database not updated
> > - error inserting cust_bill_event, invnum #239, eventpart 2: Unknown
> > invnum at /usr/local/bin/freeside-daily line 43.
> >
> > Is this anything I should be concerned about? And if so, where should I
> > look for debugging?
> >
> > Thank you.
> >
> > --
> > Remember:  every member of your 'target audience' also owns a
> > broadcasting station.  These 'targets' can shoot back.
> > 			-- Michael Rathbun to advertisers, in nanae

-- 
If we're bringing up kids that are so stupid that they kill themselves 
  because of a song, what good are the kids in the first place?
                                  -- Mr. Manson, Marilyn Manson