[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: error in 1.3.43rc while trying to update taxes



We need to clean up that error message.  But in the mean time, add the end date of the old tax in the valid to box, and for the new rate, leave that date blank.

On Fri, Sep 19, 2014 at 7:41 AM, Michael Richardson <..hidden..> wrote:

I realized the last decimal of Quebec TVQ was wrong, so I tried to update it:

2014/09/19 14:33:19 - INFO - LedgerSMB::new -- setting dbh from
argstr $self->{dbh}=DBI::db=HASH(0x9ce4fb8)
DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique
constraint "tax_pkey"
DETAIL:  Key (chart_id, validto)=(67, infinity) already exists.
CONTEXT:  SQL statement "INSERT INTO tax(chart_id, validto, rate, minvalue,
maxvalue, taxnumber,
                        pass, taxmodule_id)
         VALUES (in_chart_id, in_validto, in_rate, in_minvalue, in_maxvalue,
                in_taxnumber, in_pass, in_taxmodule_id)"
PL/pgSQL function "account__save_tax" line 16 at SQL statement at
LedgerSMB/AM.pm line 1972.
DBD::Pg::st execute failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB.pm line 834.
2014/09/19 14:37:28 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1102) --
Logging SQL State 25P02, error 7, string ERROR:  current transaction is
aborted, commands ignored until end of transaction block
Can't use string ("LedgerSMB::Setting") as a HASH ref while "strict refs" in
use at LedgerSMB.pm line 942.
Compilation failed in require at /usr/share/ledgersmb/am.pl line 7.
[Fri Sep 19 14:37:28 2014] [error] [client 2607:f0b0:c:101::40] Premature end
of script headers: am.pl, referer:
https://money13.gatineau.credil.org/ledgersmb/am.pl

--
]               Never tell me the odds!                 | ipv6 mesh networks [
]   Michael Richardson, Sandelman Software Works        | network architect  [
]     ..hidden..  http://www.sandelman.ca/        |   ruby on rails    [


------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel



--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel