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

Errors on upgrade from 1.1.12 to 1.2.5



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.