SQL error on cash receipt - missing chart_id
Stephen Beynon <stephen-+mvoWcRrPuhtdF/[email protected]> Sun, 14 May 2006 11:22:29 +0100
| Newsgroups | gmane.comp.web.sql-ledger.user |
|---|---|
| Organization | Octopus Technologies |
| Message-ID | <[email protected]> |
I have just updated to 2.6.10 and I noticed in Dieter's announcement the strong advice not to repost an invoice (which I have done in the past) and to use the cash receipt link instead. When I try to use the cash receipt link I get the following error DBD::Pg::db do failed: ERROR: syntax error at or near "," at character 114 Error! INSERT INTO acc_trans (trans_id, chart_id, transdate, amount) VALUES (10313, , '14/05/2006', 1480.5 * 1) ERROR: syntax error at or near "," at character 114 I have almost certainly done something stupid on the setup of my accounts. Does anyone have an idea what it is and how I can fix it ? Thanks Stephen