You should run setup.pl again against your existing database, as you have
missing column:
DBD::Pg::st execute failed: ERROR: column a.crdate does not exist
I use the same version of lsmb, with some additional patches, but could you
explain, how to reproduce this error?
Cheers,
István
----------------eredeti üzenet-----------------
Feladó: "M Lubratt" mplubr...@gmail.com
Címzett: "ledger-smb-users" ledger-smb-users@lists.sourceforge.net
Dátum: Wed, 29 Jan 2014 08:55:41 -0600
----------------------------------------------------------
>
>
>Thanks, Chris! That part is now working again and I see my error now. I did
>encounter the
>following regression on 1.3.37-rc3 when I tried to view a specific invoice.
>
>
>
>From the Apache error.log:
>
>
>
>
>[Wed Jan 29 08:46:24 2014] [error] [client 192.168.1.108] Math::BigInt:
>couldn't
>load specified math lib(s), fallback to Math::BigInt::Calc at
>LedgerSMB/Form.pm line
>61., referer:
>[http://192.168.1.127/ledgersmb/ap.pl?login=mpl&action=search&module=ap.p
>l&nextsub=transactions&
>
>[Wed Jan 29 08:46:26 2014] [error] [client 192.168.1.108] Math::BigInt:
>couldn't
>load specified math lib(s), fallback to Math::BigInt::Calc at
>LedgerSMB/Form.pm line
>61., referer: http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] DBD::Pg::st execute
>failed: ERROR: column a.crdate does not exist, referer:
>http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] LINE 12: a.on_hold,
>a.crdate, referer: http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] ^ at
>LedgerSMB/Form.pm
>line 2630., referer: http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] DBD::Pg::st execute
>failed: ERROR: current transaction is aborted, commands ignored until end of
>transaction
>block at LedgerSMB.pm line 833., referer: http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] 2014/01/29 08:46:27 -
>ERROR - LedgerSMB::dberror LedgerSMB.pm (1099) -- Logging SQL State 25P02,
>error 7, string
>ERROR: current transaction is aborted, commands ignored until end of
>transaction block,
>referer: http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Can't use string
>("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at
>LedgerSMB.pm line 941., referer:
>http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Compilation failed in
>require at /usr/local/ledgersmb/ir.pl line 7., referer:
>http://192.168.1.127/ledgersmb/ap.pl
>
>[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Premature end of
>script
>headers: ir.pl, referer: http://192.168.1.127/ledgersmb/ap.pl
>
>
>
>
>-Mark
>
>
>
>
>On Tue, Jan 28, 2014 at 8:49 PM, Chris Travers chris.trav...@gmail.com wrote:
>
>
>On the AR/AP transaction reports, I see your bug report. This was fixed in
>1.3.37-rc1 I
>think. I am getting 1.3.37-rc3 out today and am hoping for a full release on
>Monday if no other
>regressions are found.
>
>
>
>Best Wishes,
>
>Chris Travers
>
>
>
>
>
>
>On Tue, Jan 28, 2014 at 6:44 PM, Chris Travers chris.trav...@gmail.com wrote:
>
>
>
>
>
>
>On Tue, Jan 28, 2014 at 3:12 PM, M Lubratt mplubr...@gmail.com wrote:
>
>
>Good afternoon!
>
>
>
>I'm trying to receive inventory. I used the Shipping | Receive screen. When I
>try to look
>at the current inventory, the received inventory doesn't show up.
>
>
>
>
>
>
>Correct. Inventory numbers are not adjusted until invoices are posted. You
>have to
>invoice. Then the inventory will show up.
>
>
>
>This is necessary because otherwise, the old SQL-Ledger code can't handle very
>well
>what happens when you combine an invoice for received goods with line items
>for additional
>ones. In theory this shouldn't happen frequently, but in practice it does and
>was throwing
>the onhand numbers off.
>
>
>
>
>
>
>Then I went to the Report | Inventory Activity report. That report shows all
>of the
>inventory I received is showing sold.
>
>
>
>
>
>
>I don't think that can happen. these reports only hit the invoice table. If
>you click
>through you should get a list of ar or ap invoices with the relevant portions.
>
>
>
>
>
>
>I'm at a loss for how this happened. I'm trying to run AP and AR reports to
>see if there's a
>weird transaction that happened, but those report aren't working for me under
>LSMB 1.3.36.
>
>
>
>
>
>
>What is happening there?
>
>
>
>
>
>
>Does anyone have a suggestion?
>
>
>
>Thanks!
>
>Mark
>
>
>
>Perl 5.14.2
>
>LSMB 1.3.36
>
>Ubuntu 12.04.4
>
>
>
>
>
>-------------------------------------------------------------------------
>-----
>WatchGuard Dimension instantly turns raw network data into actionable
>security intelligence. It gives you real-time visual feedback on key
>security issues and trends. Skip the complicated setup - simply import
>a virtual appliance and go from zero to informed in seconds.
>
>http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clk
>trk
>_______________________________________________
>Ledger-smb-users mailing list
>Ledger-smb-users@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
>
>
>
>
>
>--
>
>Best Wishes,
>
>Chris Travers
>
>
>
>Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
>
>http://www.efficito.com/learn_more.shtml
>
>
>
>
>
>
>
>
>--
>
>Best Wishes,
>
>Chris Travers
>
>
>
>Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
>
>http://www.efficito.com/learn_more.shtml
>
>
>
>
>
>
>-------------------------------------------------------------------------
>-----
>WatchGuard Dimension instantly turns raw network data into actionable
>security intelligence. It gives you real-time visual feedback on key
>security issues and trends. Skip the complicated setup - simply import
>a virtual appliance and go from zero to informed in seconds.
>
>http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clk
>trk
>_______________________________________________
>Ledger-smb-users mailing list
>Ledger-smb-users@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ->
>http://192.168.1.127/ledgersmb/ap.pl?login=mpl&action=search&module=ap.pl
>&nextsub=transactions&]
>
>
>
>
>__________________________________________________
>
>
>
>-------------------------------------------------------------------------
>-----
>WatchGuard Dimension instantly turns raw network data into actionable
>security intelligence. It gives you real-time visual feedback on key
>security issues and trends. Skip the complicated setup - simply import
>a virtual appliance and go from zero to informed in seconds.
>
>http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clk
>trk
>
>__________________________________________________
>
>
>_______________________________________________
>Ledger-smb-users mailing list
>Ledger-smb-users@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
>
>
>
>
------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends. Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
