Product Type Book (by moku)

[mlindi]

Yep, that's correct. But what do I actually do about it?

Is it supposed to be there only once? If so, which one do I remove?

Or do I have to change something in the sql patch code?

Thanks,

Jeroen

Ahh - I think I understand what's going on here. Methinks you forgot to DROP the get_terms_to_filter table before adding it.

try this:

-- 
-- Table structure for table `zc_get_terms_to_filter`
-- 

DROP TABLE IF EXISTS `zc_get_terms_to_filter`;
CREATE TABLE `zc_get_terms_to_filter` (
  `get_term_name` varchar(255) NOT NULL default '',
  `get_term_table` varchar(64) NOT NULL default '',
  `get_term_name_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`get_term_name`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `zc_get_terms_to_filter`
-- 

INSERT INTO `zc_get_terms_to_filter` VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('music_genre_id', 'TABLE_MUSIC_GENRE', 'music_genre_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('record_company_id', 'TABLE_RECORD_COMPANY', 'record_company_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_genre_id', 'TABLE_BOOK_GENRE_DESCRIPTION', 'book_genre_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_type_id', 'TABLE_BOOK_TYPE_DESCRIPTION', 'book_type_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_authors_id', 'TABLE_BOOK_AUTHORS', 'book_authors_name');

-- --------------------------------------------------------

(don' t forget to replace the 'zc_' with your actual prefix)

HTH