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 [ ] [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
