Re: my first real problem, cash receipt

[ario <..hidden..>]

I have given this problem some time to resolve itself, hoping it would
be one of those glitches that remind us we are/might be living in a
matrix, but it didn't. It belongs to the real world and came back today.

I enter a payment, in an outstanding account receivable under Cash|
Payment and then it replies with:

DBD::Pg::st execute failed: ERROR: null value in column "chart_id"
violates not-null constraint at LedgerSMB/CP.pm line 426.

The log file, after a fres restart of the whole (virtual) server, says
somewhere: "incomplete startup packet", so I will copy the complete
contents of the log file here, hoping it might help in finding what's
wrong:

----- start log file -----
2011-03-08 05:56:35 GMT LOG: received fast shutdown request
2011-03-08 05:56:35 GMT LOG: aborting any active transactions
2011-03-08 05:56:35 GMT LOG: autovacuum launcher shutting down
2011-03-08 05:56:36 GMT LOG: shutting down
2011-03-08 05:56:36 GMT LOG: database system is shut down
2011-03-08 05:57:28 GMT LOG: database system was shut down at 2011-03-08
05:56:36 GMT
2011-03-08 05:57:28 GMT LOG: incomplete startup packet
2011-03-08 05:57:29 GMT FATAL: the database system is starting up
2011-03-08 05:57:28 GMT LOG: autovacuum launcher started
2011-03-08 05:57:30 GMT LOG: database system is ready to accept
connections
2011-03-08 06:01:52 GMT LOG: null value in column "chart_id" violates
not-nul constraint
2011-03-08 06:01:52 GMT LOG: STATEMENT:
  INSERT INTO acc_trans
              (trans_id, chart_id, transdate, 
               amount)
       VALUES ($1, $2, 
               $3,
               $4)
----- end log file-----

I hope that the lines mentioning the 'incomplete packet' and 'FATAL'
might give somebody a hint.

Thanks,
ario



On Sun, 2011-01-30 at 06:22 +0000, ario wrote:
> Hi, I'm trying to input a cash receipt of 1,000 into a list of
> outstanding accounts receivable, but something goes wrong.
> Here's what I do:
> 
> In the list of invoices I select one by clicking the select box, which
> shows checked from then on. Then, in the form 'amount' field next to the
> checked 'select' box, on the left of which the 'amount' and 'amount due'
> both show the number '1,248' , I type '1000' (of course without the
> ''s).
> Then, after clicking 'update', the 'amount' field above the blue
> 'Invoices' bar, shows the amount I entered: '1,000'.
> After clicking 'post' (no matter how many times I clicked on 'update',
> because I know that has an 'issue') he (LedgerSMB :) answers with:
> 
> 
> DBD::Pg::st execute failed: ERROR: null value in column "chart_id"
> violates not-null constraint at LedgerSMB/CP.pm line 426.
> 
> Error!
> 
> INSERT INTO acc_trans 
> (trans_id, chart_id, transdate, 
> amount)
> VALUES (?, ?, 
> ?, 
> ?)
> ERROR: null value in column "chart_id" violates not-null constraint
> 
> 
> All fields above the blue 'Invoises' bar are properly filled out, except
> the 'source' field is left empty by me.
> 
> Any suggestion?
> 
> thanks
> 
> 
> 
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
> February 28th, so secure your free ArcSight Logger TODAY! 
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users