[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

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?


On Sun, 2012-11-11 at 17:15 -0800, Chris Travers wrote:
> On Sun, Nov 11, 2012 at 7:15 AM, ario <..hidden..>
> 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 ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users