<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — DATABASE ERROR : could not retreive quick entries]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=889</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=889&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in DATABASE ERROR : could not retreive quick entries.]]></description>
		<lastBuildDate>Wed, 21 Oct 2009 17:59:29 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: DATABASE ERROR : could not retreive quick entries]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=3707#p3707</link>
			<description><![CDATA[<p>Thanks Joe </p><p>I took a look at the data base, and the table was empty? Got no idea how this could have happened, but with the three rows, or records added it works. </p><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (alvin)]]></author>
			<pubDate>Wed, 21 Oct 2009 17:59:29 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=3707#p3707</guid>
		</item>
		<item>
			<title><![CDATA[Re: DATABASE ERROR : could not retreive quick entries]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=3703#p3703</link>
			<description><![CDATA[<p>This is a strange error. In FA 2.1.X the table for quick entries is:</p><div class="codebox"><pre><code>### Structure of table `0_quick_entries` ###

DROP TABLE IF EXISTS `0_quick_entries`;

CREATE TABLE `0_quick_entries` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL default &#039;0&#039;,
  `description` varchar(60) NOT NULL,
  `base_amount` double NOT NULL default &#039;0&#039;,
  `base_desc` varchar(60) default NULL,
  PRIMARY KEY  (`id`),
  KEY `description` (`description`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;


### Data of table `0_quick_entries` ###

INSERT INTO `0_quick_entries` VALUES (&#039;1&#039;, &#039;1&#039;, &#039;Maintenance&#039;, &#039;0&#039;, &#039;Amount&#039;);
INSERT INTO `0_quick_entries` VALUES (&#039;2&#039;, &#039;4&#039;, &#039;Phone&#039;, &#039;0&#039;, &#039;Amount&#039;);
INSERT INTO `0_quick_entries` VALUES (&#039;3&#039;, &#039;2&#039;, &#039;Cash Sales&#039;, &#039;0&#039;, &#039;Amount&#039;);</code></pre></div><p>So the type should be there. Please check your db structure.<br />There should be no changes in 2.2 Beta for the quick entries (only a small change in quick entry lines regarding tax)</p><p>/Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 21 Oct 2009 08:11:55 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=3703#p3703</guid>
		</item>
		<item>
			<title><![CDATA[DATABASE ERROR : could not retreive quick entries]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=3700#p3700</link>
			<description><![CDATA[<p>Here is one I just got when I hit the Journal Entry in Banking and GL, I have not looked at the DB yet...</p><p>DATABASE ERROR : could not retreive quick entries<br />error code : 1054<br />error message : Unknown column &#039;type&#039; in &#039;where clause&#039;<br />sql that failed was : SELECT id FROM 0_quick_entries WHERE type=&#039;3&#039;</p><p>What do think?</p><p>AM</p>]]></description>
			<author><![CDATA[null@example.com (alvin)]]></author>
			<pubDate>Tue, 20 Oct 2009 19:12:29 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=3700#p3700</guid>
		</item>
	</channel>
</rss>
