• Registered: 10/22/2010
  • Posts: 8

Topic: DATABASE ERROR : could not get location info error code : 1064

I was trying the new version 2.3 stable. But I am getting the below error when I was trying 'Purchase order entry' or 'Direct invoice' under purchase. The new version I just downloaded from the net, I am not edited anything.

The error is

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''

2 Reply by kerrsmith (edited by kerrsmith 12/11/2010 03:01:03 pm)

  • From: UK
  • Registered: 10/11/2009
  • Posts: 50

Re: DATABASE ERROR : could not get location info error code : 1064

I am also getting the same error message on the following screens after an update from 2.2.11 to 2.3 stable version:

Purchase Order Entry
Direct GRN Entry
Direct Purchase Invoice Entry

(I have added this error to Mantis)

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

Re: DATABASE ERROR : could not get location info error code : 1064

Unfortunately we have introduced this bug during last fixes before 2.3.0 release. Please download changed file from Mantis. It is attached to bug report 0000318.

Janusz

  • Registered: 10/22/2010
  • Posts: 8

Re: DATABASE ERROR : could not get location info error code : 1064

The issue is solved. Thank you very much for your support.