On Tuesday 31 July 2007 00:10, Chris Travers wrote:
> On 7/30/07, Eduardo Huertas <[EMAIL PROTECTED]> wrote:
> > Seems there is a bug when trying to post a sale.
> >
> > DBD::Pg::st execute failed: ERROR: el valor null para
> > la columna «chart_id» viola la restricción not null
> > Error!
> >
> >
> > INSERT INTO acc_trans
> > (trans_id, chart_id, amount,
> > transdate, source, memo, cleared)
> > VALUES (?, (SELECT id FROM chart
> > WHERE accno = ?),
> > ?, ?, ?, ?, ?)
> > ERROR: el valor null para la columna «chart_id»
> > viola la restricción not null
For me this issues was because the file pos.conf.pl needed a default account
set for the till account. We do not use different accounts for each till
(like 1300.13) or whatnot like this file is set up, there is just one account
that all POS transactions go into, so we just set the value to that account
where the line:
$pos_config{till_accno} = "1200";
Exists.
Maybe that will give you some ideas of where to look.
> This does not sound like a bug. Instead it sounds like an issue with your
> chart of accounts. Which chart of accounts are you using? Have you made
> any modifications?
>
> Some background here: This error message is telling me that the subquery
> did not return a valid account id, and that our database rules prevent this
> from being inserted. SQL-Ledger does not do this and hence you can get
> invalid data in your database pretty easily.
>
> Best Wishes,
> Chris Travers
--
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous
F9B6 FEFE 080B 8299 D7EA 1270 005C EC73 47C9 B7A6
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
