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:30:03Z

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:43Z

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

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

2010-12-11T14:04:15Z

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)

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

2010-12-11T10:48:55Z

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