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

Re: 1.4.28



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 <..hidden..> 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  [
]     ..hidden..  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
..hidden..
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel