<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — small bug item units db]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7973&amp;type=atom" />
	<updated>2019-01-27T15:00:55Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=7973</id>
		<entry>
			<title type="html"><![CDATA[Re: small bug item units db]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=34108#p34108" />
			<content type="html"><![CDATA[<p>This has been fixed and committed. Thanks @anoopmb.</p><p>We will see later if the function is needed or not.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2019-01-27T15:00:55Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=34108#p34108</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: small bug item units db]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=34103#p34103" />
			<content type="html"><![CDATA[<p>@anoopmb: good catch. Needs to be corrected in FA 2.3 as well. Where did you have to use this function?</p><p>Whether a new field is necessary and whether the function name should be changed accordingly needs to be ascertained.</p><p>Note that this function is not used in FA 2.3.26 and in FA 2.4.6 as well and see if it needs to be removed. Neither is it used in any official theme / extension and those in my FA24extensions repo.</p><p>@joe: can commit it.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2019-01-27T14:08:04Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=34103#p34103</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[small bug item units db]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=34101#p34101" />
			<content type="html"><![CDATA[<p>the function get_unit_descr($unit) on line no 44 defined in <strong>inventory/includes/db/item_units_db.inc</strong> file</p><p>instead of name you are selecting description column which does not exist in db </p><div class="codebox"><pre><code>function get_unit_descr($unit)
{
    $sql = &quot;SELECT description FROM &quot;.TB_PREF.&quot;item_units WHERE abbr=&quot;.db_escape($unit);
    $result = db_query($sql, &quot;could not unit description&quot;);
    $row = db_fetch_row($result);
    return $row[0];
}</code></pre></div><br /><p>change to </p><div class="codebox"><pre><code>function get_unit_descr($unit)
{
    $sql = &quot;SELECT name FROM &quot;.TB_PREF.&quot;item_units WHERE abbr=&quot;.db_escape($unit);
    $result = db_query($sql, &quot;could not retrieve unit name&quot;);
    $row = db_fetch_row($result);
    return $row[0];
}</code></pre></div>]]></content>
			<author>
				<name><![CDATA[anoopmb]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=18207</uri>
			</author>
			<updated>2019-01-26T19:17:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=34101#p34101</id>
		</entry>
</feed>
