Re: my first real problem, cash receipt

[Chris Travers <..hidden..>]

On Mon, Jan 31, 2011 at 10:14 PM, ario <..hidden..> wrote:
> I'm not in a terrible hurry and there is a workaround for this problem:
> cancellation and reposting with the new payment included.

Ick.....
>
> As for the log file: From startup to encountering the problem the file
> is empty, then the same errors as I pasted earlier from the browser
> window are exactly the same there in the log file:

Ok, what is happening is that somehow it is not picking up one of the
accounts.  The question is why.

The query that is failing is the one which inserts into the AR
account.  Can you do this in LSMB?

go to system/chart of accounts/list accounts
click on the account number for your ar account
tell me what checkboxes are checked.
>
> 2011-01-30 07:15:21 GMT STATEMENT:
> INSERT INTO acc_trans
>            (trans_id, chart_id, transdate,
>            amount)
>     VALUES ($1, $2,
>            $3,
>            $4)
> 2011-01-30 07:16:47 GMT ERROR:   null value in column "chart_id"
> violates not-null constraint
>
>
> These sequences are repeated various times as I have retried the same
> kind of transaction until I shut down the virtual machine with the
> LedgerSMB on it:
>
>
> 2011-01-30 07:23:22 GMT LOG:  incomplete startup packet
> 2011-01-30 07:23:22 GMT LOG:  received fast shutdown request
> 2011-01-30 07:23:22 GMT LOG:  aborting any active transactions
> 2011-01-30 07:23:22 GMT LOG:  autovacuum launcher shutting down
> 2011-01-30 07:23:22 GMT LOG:  shutting down
> 2011-01-30 07:23:22 GMT LOG:  database system is shut down
>
>
> Detail: I'm running 3 'company' databases with LedgerSMB on that virtual
> machine, nothing else, and the error occurrs in at least 2 of those. So
> it doesn't appear to be an error in one specific database.
>
>
> thanks,
> ario
>
>
> On Mon, 2011-01-31 at 09:48 -0800, Chris Travers wrote:
>> On Sun, Jan 30, 2011 at 11:47 PM, ario <..hidden..> wrote:
>> > AR: 1100 -- ACCOUNTS RECEIVABLE, with attribute AR set.
>> > Account: 1010 -- hw cash, with attributes AR_paid & AP_paid.
>>
>> Can you check your PostgreSQL log?  There may be more information as
>> far as what is being passed in over there.  I haven't seen this sort
>> of case very often.  It may be something specific to the invoice, or
>> it could be an issue with the setup.  It could be something else.  If
>> this is urgent, I'd recommend hiring someone (such as myself or
>> Command Prompt) for support so we can take a look at it, do some
>> debugging, and figure out what exactly is causing this issue.
>> Otherwise we could continue to try to gather information on the
>> problem in hopes of fixing it or, if paid support does become
>> necessary, reducing the effort to fix it.
>>
>> Best Wishes,
>> Chris Travers
>>
>> ------------------------------------------------------------------------------
>> 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
>
>
> ------------------------------------------------------------------------------
> 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
>