So I copy-to-new and created a new invoice, and posted a payment with
the correct FX value. (See my email to users)
INSERT INTO acc_trans
(trans_id, chart_id, amount,
transdate, source,
fx_transaction, cleared)
VALUES (?, (SELECT id FROM chart
WHERE accno = >),
?, ?, ?, '1', ?)
called with 6 bind variables when 5 are needed
I don't think this log helps:
2607:f0b0:f:2::247 - - [08/Jan/2013:14:06:49 -0500] "POST /ledgersmb/is.pl HTTP/1.1" 200 6181 "https://marlin.sandelman.ca/ledgersmb/is.pl?action="">" "Mozilla/5.0 (X11; Linux x86_64; rv:10.0.11) Gecko/20100101 Firefox/10.0.11 Iceweasel/10.0.11"
2607:f0b0:f:2::247 - - [08/Jan/2013:14:07:02 -0500] "POST /ledgersmb/is.pl HTTP/1.1" 200 6085 "https://marlin.sandelman.ca/ledgersmb/is.pl" "Mozilla/5.0 (X11; Linux x86_64; rv:10.0.11) Gecko/20100101 Firefox/10.0.11 Iceweasel/10.0.11"
2607:f0b0:f:2::247 - - [08/Jan/2013:14:07:39 -0500] "POST /ledgersmb/is.pl HTTP/1.1" 200 8158 "https://marlin.sandelman.ca/ledgersmb/is.pl" "Mozilla/5.0 (X11; Linux x86_64; rv:10.0.11) Gecko/20100101 Firefox/10.0.11 Iceweasel/10.0.11"
2607:f0b0:f:2::247 - - [08/Jan/2013:14:07:47 -0500] "POST /ledgersmb/is.pl HTTP/1.1" 200 1221 "https://marlin.sandelman.ca/ledgersmb/is.pl" "Mozilla/5.0 (X11; Linux x86_64; rv:10.0.11) Gecko/20100101 Firefox/10.0.11 Iceweasel/10.0.11"
Maybe this helps:
[Tue Jan 08 14:07:47 2013] [error] [client 2607:f0b0:f:2::247] DBD::Pg::st execute failed: called with 6 bind variables when 5 are needed at LedgerSMB/IS.pm line 1519., referer: https://marlin.sandelman.ca/ledgersmb/is.pl
Investigating.
--
] Never tell me the odds! | ipv6 mesh networks [
] Michael Richardson, Sandelman Software Works | network architect [
] ..hidden.. http://www.sandelman.ca/ | ruby on rails [
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel