It's in one row only. And I agree it shouldn't be possible because I thought lsmb would check the string entered in the Amount field and refuse it if it weren't a valid number.
I don't know what exactly was entered erroneously there and why. If it is the string that should have been entered in the Source field, it must have been something like 100-3658, identifying the file with the picture taken of the receipt. Or if more pictures are involved it might be a set of numbers like that, separated by a slash, as in: 100-3658 / 100-3659 Maybe it might be worthwhile to check whether this kind of input would make it past the filter which checks its validity? regards, ario On Sun, 2012-11-11 at 17:15 -0800, Chris Travers wrote: > > > On Sun, Nov 11, 2012 at 7:15 AM, ario <ledger-smb-us...@infopower.nl> > wrote: > 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". > > > Yeah, I am looking into whether this is still possible in 1.3. I > don't think it is but want to verify. > > 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. > > > How many rows are we talking about? > > > 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
