• alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Topic: DATABASE ERROR : could not retreive quick entries

Here is one I just got when I hit the Journal Entry in Banking and GL, I have not looked at the DB yet...

DATABASE ERROR : could not retreive quick entries
error code : 1054
error message : Unknown column 'type' in 'where clause'
sql that failed was : SELECT id FROM 0_quick_entries WHERE type='3'

What do think?

AM

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: DATABASE ERROR : could not retreive quick entries

This is a strange error. In FA 2.1.X the table for quick entries is:

### 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 '0',
  `description` varchar(60) NOT NULL,
  `base_amount` double NOT NULL default '0',
  `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 ('1', '1', 'Maintenance', '0', 'Amount');
INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');

So the type should be there. Please check your db structure.
There should be no changes in 2.2 Beta for the quick entries (only a small change in quick entry lines regarding tax)

/Joe

  • alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Re: DATABASE ERROR : could not retreive quick entries

Thanks Joe

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.

Thanks

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.