Re: Purchase Order Entry Error

null@example.com (harshalc) — Wed, 22 Dec 2010 14:05:13 +0000

Thanks that solved it.

Re: Purchase Order Entry Error

null@example.com (itronics) — Wed, 22 Dec 2010 07:23:21 +0000

Please upload latest tarball 2.3.0a - this ugly bug was fixed and just after initial 2.3.0 release.
Janusz

Purchase Order Entry Error

null@example.com (harshalc) — Tue, 21 Dec 2010 22:01:51 +0000

Hi Admins,

Thank you for a wonderful piece of software. I had earlier entered alot of Purchase Orders but when I moved to 2.3 I get the following error:

DATABASE ERROR : could not get location info
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEF''' at line 1
sql that failed was : SELECT delivery_address, phone FROM 0_locations WHERE loc_code=''DEF''

When I set the go_debug to 1 following is the sql that i guess is problematic.

SELECT delivery_address, phone FROM 0_locations WHERE loc_code=''DEF''

Steps to reproduce:
Clicking the Purchase module -> PO Entry link.

Can someone please help.

FrontAccounting forum — Purchase Order Entry Error

Re: Purchase Order Entry Error

Re: Purchase Order Entry Error

Purchase Order Entry Error