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

Re: Errors on upgrade from 1.1.12 to 1.2.5



This is a known issue.  1.2.6 validation is scheduled to begin shortly.

In the mean time, you have two options:
Download Form.pm from svn branches/1.2
or
email me and I will email you the Perl Module.
Best Wishes,
Chris Travers

On 6/18/07, Mark Clarke <..hidden..> wrote:
Hi all,

I get this error when trying to get a report on ap->reports->transactions

DBD::Pg::st execute failed: ERROR: column "customer_id" does not exist
Error!


SELECT ct.name AS vendor, ct.curr AS currency, ct.id AS vendor_id,
current_date + ct.terms AS duedate,
ct.notes,
ct.curr AS currency
FROM vendor ct
WHERE ct.id = (select customer_id from ap where 1 = 1 AND vendor_id IS
NOT NULL order by id DESC limit 1)
ERROR: column "customer_id" does not exist

===========================================
Cyber Designs - Put your business on the net
http://www.CyberDesigns.co.za

Jumping Bean - Your Java and Linux Experts
http://www.JumpingBean.co.za

Tel: 011-781 80 14
Fax: 011-781 80 15
===========================================
Disclaimer

Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Employees of Cyber Designs are expressly required not to make defamatory statements and not to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is contrary to company policy and outside the scope of the employment of the individual concerned. The company will not accept any liability in respect of such communication, and the employee responsible will be personally liable for any damages or other liability arising.


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users