<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — FA 2.3 DB Fixes]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5687&amp;type=atom" />
	<updated>2015-04-08T23:12:31Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5687</id>
		<entry>
			<title type="html"><![CDATA[FA 2.3 DB Fixes]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=23180#p23180" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2015-04-08T23:12:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=23180#p23180</id>
		</entry>
</feed>
