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

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

null@example.com (messi7) — Sun, 12 Dec 2010 19:30:03 +0000

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

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

null@example.com (itronics) — Sun, 12 Dec 2010 16:57:43 +0000

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

null@example.com (kerrsmith) — Sat, 11 Dec 2010 14:04:15 +0000

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

null@example.com (messi7) — Sat, 11 Dec 2010 10:48:55 +0000

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