[SL] Syntax Error

[Peter D. <mer...@ma...>]

Hi,
Upgraded my mandriva to 2008.1 spring from 2008 and got this error 
during posting sales invoice.
Database postgresql 8.27 previous was 8.26 DBD pg was updated too by 
increment.
I was running sql-ledger 8.13 upgraded to 8.14 but no change. Should 
I move to postgres 8.3 ?

DBD::Pg::db do failed: ERROR: syntax error at or near ")"
LINE 4: '11/05/2008', NULL, )
^ at SL/IS.pm line 1077.
Error!

INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate, project_id, id)
VALUES (11246, 10032, 138.17,
'11/05/2008', NULL, )
ERROR: syntax error at or near ")"
LINE 4: '11/05/2008', NULL, )
^

Thanks
Peter


-- 
Mail.com Autos- Powered by Oncars.com: Drive By Today!
http://www.oncars.com