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