On Tue, 2011-02-01 at 08:24 -0800, Chris Travers wrote: > On Mon, Jan 31, 2011 at 10:14 PM, ario <[email protected]> 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. ar account: Account type: Asset Is this a summary...: AR account to be debited: Account: 1010 Account type: Asset Is this a summary...: none Receivables: Payment Payables: Payment I hope this helps. thanks, ario > > > > 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 <[email protected]> > >> 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 > >> [email protected] > >> 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
