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

acc_trans error with 1.3.27-ish



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    [