Re: [SL] Syntax Error

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

Hi,
Thanks for advise. Tried to move to postgres 8.3 but in the end still got the same error posting sales invoice.
Reinstalled mandriva2008 and sql-ledger functioning fine without any errors.
I think that only significant changes in mandriva2008.1 affecting functionality of sql-ledger was upgrade of perl, perl-DBI and perl-DBD-pg. So as other people mentioned on this thread that there must be some incompatibility with above newer libraries

Thanks
Peter
> ----- Original Message -----
> From: "Adrian Blake" <adr...@ie...>
> To: sql...@li...
> Subject: Re: [SL] Syntax Error
> Date: Wed, 28 May 2008 20:53:59 +1000
> 
> 
> 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
> >
> >
> -------------------------------------------------------------------------
> 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

>


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