Re: setup.pl fails in ledgersmb on squeeze when set up through apt-get install ledgersmb

[ario <..hidden..>]

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

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
database.
Corrected that with a psql statement: 
  ALTER role 'wrong_name' NAME 'correct_name' ENCRYPTED PASSWORD
'new_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!

ario



On Sun, 2012-11-11 at 04:26 -0800, Chris Travers wrote:
> 
> 
> On Sat, Nov 10, 2012 at 11:53 AM, ario <..hidden..>
> wrote:
>         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?
> 
> 
> Instead:
> 
> 
> 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:
> http://p.sf.net/sfu/appdyn_d2d_nov
> _______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users