• 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 Final. But I am getting the below error when I was trying 'Purchase order entry' or 'Direct invoice' or 'Direct GRN Entry' 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''

  • 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.