Hi Richard,
It's a typo.
Line 1515 reads:
WHERE accno = >),
But should have read
WHERE accno = ?),
Note the question mark instead of the '>'.
Hope that fixes it. If it does, I'll commit the fix to be released.
Bye,
Erik.
On Tue, Jan 8, 2013 at 8:10 PM, Michael Richardson <[email protected]> wrote:
>
> 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.plHTTP/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.plHTTP/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.plHTTP/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.plHTTP/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 [
> ] [email protected] 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
