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 <ledger-smb-us...@infopower.nl> > 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 > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------------ 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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
