<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Purchase Order Entry Error]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=1765&amp;type=atom" />
	<updated>2010-12-22T14:05:13Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=1765</id>
		<entry>
			<title type="html"><![CDATA[Re: Purchase Order Entry Error]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=7809#p7809" />
			<content type="html"><![CDATA[<p>Thanks that solved it.</p>]]></content>
			<author>
				<name><![CDATA[harshalc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=301</uri>
			</author>
			<updated>2010-12-22T14:05:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=7809#p7809</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Purchase Order Entry Error]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=7804#p7804" />
			<content type="html"><![CDATA[<p>Please upload latest tarball 2.3.0a - this ugly bug was fixed and just after initial 2.3.0 release.<br />Janusz</p>]]></content>
			<author>
				<name><![CDATA[itronics]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=89</uri>
			</author>
			<updated>2010-12-22T07:23:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=7804#p7804</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Purchase Order Entry Error]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=7800#p7800" />
			<content type="html"><![CDATA[<p>Hi Admins,</p><p>Thank you for a wonderful piece of software. I had earlier entered alot of Purchase Orders but when I moved to 2.3 I get the following error:</p><p>DATABASE ERROR : could not get location info<br />error code : 1064<br />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 &#039;DEF&#039;&#039;&#039; at line 1<br />sql that failed was : SELECT delivery_address, phone FROM 0_locations WHERE loc_code=&#039;&#039;DEF&#039;&#039;</p><p>When I set the go_debug to 1 following is the sql that i guess is problematic.</p><p>SELECT delivery_address, phone FROM 0_locations WHERE loc_code=&#039;&#039;DEF&#039;&#039;</p><p>Steps to reproduce:<br />Clicking the Purchase module -&gt; PO Entry link.</p><p>Can someone please help.</p>]]></content>
			<author>
				<name><![CDATA[harshalc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=301</uri>
			</author>
			<updated>2010-12-21T22:01:51Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=7800#p7800</id>
		</entry>
</feed>
