Re: [SL] Syntax Error

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

On May 26, 2008 04:54:56 pm Rolf Stöckli wrote:
> 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
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


Well,  several other folks have had these problems after 
perl/dbd-pg/distrubution upgrades.  There have been various errors: syntax 
errors because of a missing parameter in a database lookup, bizarre array 
copies, unreferenced hash things.  I've seen all three since the 
perl/dbd-pg-dbi upgrade.

http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941

http://sourceforge.net/mailarchive/forum.php?thread_name=200804171345.34024.archdist%40mts.net&forum_name=sql-ledger-users

http://sourceforge.net/mailarchive/forum.php?thread_name=200805211043.57773.msmall%40eastlink.ca&forum_name=sql-ledger-users

The last one is my post from last week.

Mark