• From: Canada, Kitchener, Ontario
  • Registered: 02/03/2009
  • Posts: 24

Topic: Purchase Order Entry Error

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.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Purchase Order Entry Error

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

  • From: Canada, Kitchener, Ontario
  • Registered: 02/03/2009
  • Posts: 24

Re: Purchase Order Entry Error

Thanks that solved it.