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 <[email protected]>
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 [
> ] [email protected] 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
