[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: setup.pl fails in ledgersmb on squeeze when set up through apt-get install ledgersmb
- Subject: Re: setup.pl fails in ledgersmb on squeeze when set up through apt-get install ledgersmb
- From: ario <..hidden..>
- Date: Sun, 11 Nov 2012 15:15:47 +0000
Yes, I was restoring from a 1.2.21 backup, found the problem with the
already created company/database, deleted it and created/pg_restored it
Another problem was 'operator error': while creating the new database, I
had created a new user with a name different from the original 1.2
Corrected that with a psql statement:
ALTER role 'wrong_name' NAME 'correct_name' ENCRYPTED PASSWORD
And it works now!
Thanks for your help.
One (at least I hope I won't find any more) remaining problem: after
importing the database in 1.3, I tried to compare the balance sheets,
but found out that in one account (asset: cash) there is one entry with
an AP | Payments | Amount which is "NaN.00".
Don't know how it got there, I probably swapped Source and Amount
entries while entering the payment in 1.2.21, coz the Source field
contains the Amount now.
However, all balance sheet aggregates now say: "NaN.00".
The other accounts on the balance sheet are the same as in 1.2, so the
conversion 'an sich' was successful, but the database still contains a
'NaN.00' in one AP Invoice's Payment field where it shouldn't.
Could you kindly suggest a (probably psql) way to correct that?
Thanks in advance!
On Sun, 2012-11-11 at 04:26 -0800, Chris Travers wrote:
> On Sat, Nov 10, 2012 at 11:53 AM, ario <..hidden..>
> Yes, that did something! Thanks.
> I have been able now to log into the setup.pl script and
> create a
> database. Then I read that for the manual import
> pg_restore -U user -C database.sql
> I take it you are trying to restore a backup?
> createdb -U user dbanme && pg_restore -U user -d dbname
> Chances are your import failed because you had already populated key
> parts of the db.
> Best Wishes,
> Chris Travers
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> _______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users