<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — FA 2.3 DB Fixes]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=5687</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5687&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in FA 2.3 DB Fixes.]]></description>
		<lastBuildDate>Wed, 08 Apr 2015 23:12:31 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[FA 2.3 DB Fixes]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=23180#p23180</link>
			<description><![CDATA[<p>FA 2.3 database fixes and notes:</p><p>1. <strong>0_comments</strong> table has no primary key. Correct it with:<br /></p><div class="codebox"><pre><code>ALTER TABLE `0_comments` ADD PRIMARY KEY (`type`, `id`), DROP INDEX `type_and_id`;</code></pre></div><p>2. Table field <strong>0_gl_trans.<span style="color: red">person_id</span></strong> is <strong>tinyblob</strong> Nullable. In some cases it is a <strong>blank</strong> string and in others it is <strong>0 </strong>when not a valid integer.</p><p>3. Table field <strong>0_gl_trans.<span style="color: red">person_type_id</span></strong> is 1, 2, or 3 and NULL.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 08 Apr 2015 23:12:31 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=23180#p23180</guid>
		</item>
	</channel>
</rss>
