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
]]>### 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
]]>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
]]>