Re: [SL] Syntax Error

[Mark J. S. <ms...@ea...>]

On May 26, 2008, Peter Dabrowski wrote:
> 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

I had the same problem last week, though I misidentified it as from a perl 
upgrade.  I'm pretty sure that it was dbd-pg.  I posted about it on this list 
and got the usual silence for a response.  Other people have had the same 
problem over the last few months, and nobody has posted a proper fix.

I "fixed" it by migrating the database to an older computer running debian 
stable, so it has an old version of dbd-pg, perl, and other helper stuff.  
Not a practical solution for everybody, but it was something I had planned on 
for a long time anyway.  

If you can't downgrade the helper stuff, my only advice would be to pay Dieter 
to make this issue a big priority.  

Mark