Hi Michael,
1.4.29 will have a fix for this. If you want to patch your local install in
order to be able to proceed your upgrade / accounting, this is the fix you
can apply. It won't interfere with a regular 1.4.29 upgrade:
https://github.com/ledgersmb/LedgerSMB/pull/1489/commits/8d28270f04c7cb8b9d41e9e3331bc799789528c2#diff-f88b8621d08ab919bdcb0771f374583bR1471
Regards,
Erik.
On Wed, May 4, 2016 at 3:29 AM, Michael Richardson <m...@sandelman.ca> wrote:
> with both 1.4.27 and 1.4.28, having run setup.pl to upgrade each time, I
> get the following when attempting to pay (post+print PDF/screen) a payment
> to
> an open invoice.
>
> Does not happen with just POST.
> I can't recall last time I successfully printed a checque in 1.4: I know I
> have been writing them manually because of template issues that I hadn't
> resolved.
>
> Error!
>
> 42703:ERROR: column ac.project_id does not exist
> LINE 3: ...ate, ac.source, ac.cleared_on, ac.fx_transaction, ac.project...
> ^ QUERY: SELECT pl.payment_id, ac.entry_id, pl.type as link_type,
> ac.trans_id, a.invnumber as invoice_number, ac.chart_id, ch.accno as
> chart_accno, ch.description as chart_description, ch.link as chart_link,
> ac.amount, ac.transdate as trans_date, ac.source, ac.cleared_on,
> ac.fx_transaction, ac.project_id, ac.memo, ac.invoice_id, ac.approved,
> ac.cleared_on, ac.reconciled_on FROM acc_trans ac JOIN payment_links pl ON
> (pl.entry_id = ac.entry_id ) JOIN chart ch ON (ch.id = ac.chart_id) LEFT
> JOIN (SELECT id,invnumber FROM ar WHERE in_account_class = 2 UNION SELECT
> id,invnumber FROM ap WHERE in_account_class = 1 ) a ON (ac.trans_id = a.id)
> WHERE pl.payment_id = in_payment_id CONTEXT: PL/pgSQL function
> "payment_gather_line_info" line 4 at FOR over SELECT rows at LedgerSMB.pm
> line 770.
>
> dbversion: 1.4.28, company: sswbooks
>
>
>
> --
> ] Never tell me the odds! | ipv6 mesh
> networks [
> ] Michael Richardson, Sandelman Software Works | network
> architect [
> ] m...@sandelman.ca http://www.sandelman.ca/ | ruby on
> rails [
>
>
>
> ------------------------------------------------------------------------------
> Find and fix application performance issues faster with Applications
> Manager
> Applications Manager provides deep performance insights into multiple
> tiers of
> your business applications. It resolves application problems quickly and
> reduces your MTTR. Get your free trial!
> https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
