sql-ledger-users

[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 

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

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

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

Re: [SL] Syntax Error

[Adrian B. <adr...@ie...>]

Last weekend I did the same upgrade, Mandriva 2008 to Mandriva 2008.1 (Spring).

First is did a backup from SQL-Ledger to create a file ¨arblake2-2.8.14-20080525.sql¨. I also did a complete copy of
/var/lib/pgsql and /usr/local/sql-ledger.

Next a total install of Mandriva 2008.1

I installed Postgres (version 8.3) and all software as in the SQL-Ledger  ¨README¨

Next installed SQL-Ledger and copied in my users and templates, just like doing an update of sql-Ledger, etc

Follow the ¨README¨

As user postgres:

createuser -d sql-ledger

createlang plpgsql template1

Follow the ¨README¨

http://localhost/sql-ledger/admin.pl

This should show the details of your old database. including the  dataset name, e.g. newdb

create a blank database and restore the data.

psql -U sql-ledger -c "create database newdb;" template1
psql -U sql-ledger newdb < arblake2-2.8.14-20080525.sql

Now all should be working.

I hope I have included all the steps.



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