[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
acc_trans error with 1.3.27-ish
- Subject: acc_trans error with 1.3.27-ish
- From: Michael Richardson <..hidden..>
- Date: Tue, 08 Jan 2013 14:10:11 -0500
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=edit&id=912128&path=bin/mozilla&login=mcr&sessionid=&callback=ar.pl%3faction%3dtransactions%26direction%3dDESC%26oldsort%3dtransdate%26till%3d%26outstanding%3d%26path%3dbin%2fmozilla%26login%3dmcr%26sessionid%3d%26summary%3d1%26title%3dAR%2520Transactions%26transdatefrom%3d2012-05-01%26open%3dY%26closed%3dY%26l_transdate%3dY%26l_invnumber%3dY%26l_name%3dY%26l_amount%3dY%26l_paid%3dY%26sort%3dtransdate" "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 [