Re: [SL] Syntax Error

[Rolf S. <in...@to...>]

Mark J. Small schrieb:
> 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.

Maybe the reason for the (unusual) silence is, that this error is very 
difficult to reproduce. Me personally, I've never seen it neither on 
SUSE, nor on Ubuntu. I've tried again on Ubuntu 8.04 after Peter's 
message, and everything works fine.

> 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.  

The error message Peter posted

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

doesn't seem to be a dbd or a Postres error. My conjecture (only a 
conjecture!) is that the source is in the foreach-loop following line 
823, where at line 1001 the id should be set. Is someone able to debug 
this area on a system that doesn't work properly?

Rolf