FrontAccounting forum — DATABASE ERROR : could not get location info error code : 1064

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

2010-12-12T19:26:15Z

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

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

2010-12-12T16:57:23Z

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

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

2010-12-12T06:36:10Z

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