Hi
I am trying to import the categories descriptions using phpmyadmin and have the following text file:
--
-- Table structure for table `categories_description`
--
CREATE TABLE `categories_description` (
`categories_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL default '1',
`categories_name` varchar(32) NOT NULL default '',
`categories_description` text NOT NULL,
PRIMARY KEY (`categories_id`,`language_id`),
KEY `idx_categories_name_zen` (`categories_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `categories_description`
--
INSERT INTO `categories_description` (`categories_id`, `language_id`, `categories_name`, `categories_description`)
VALUES
(1, 1, 'Acid Techno', ''),
(2, 1, 'Breakbeat', ''),
(3, 1, 'Classic Rave', ''),
(4, 1, 'Commercial Trance', ''),
(5, 1, 'Deep House', ''),
(6, 1, 'Deep Techno', ''),
(7, 1, 'Downtempo', ''),
(8, 1, 'Drum & Bass', ''),
(9, 1, 'Electro House', ''),
(10, 1, 'Euro Trance', ''),
(11, 1, 'Funky House', ''),
(12, 1, 'Funky Techno', ''),
(13, 1, 'Gabba', ''),
(14, 1, 'Hard House', ''),
(15, 1, 'Hard Core', ''),
(16, 1, 'Test1', ''),
(17, 1, 'Hard Techno', ''),
(18, 1, 'Hard Trance', ''),
(19, 1, 'Test2', ''),
(20, 1, 'Hardstyle', ''),
(21, 1, 'Hardtrance / Techno', ''),
(22, 1, 'Progressive House', ''),
(23, 1, 'Scratchtools', ''),
(24, 1, 'Tech/Hard/Euro/Vocal', ''),
(25, 1, 'Tech House', ''),
(26, 1, 'Tech Trance', ''),
(27, 1, 'Tech/US House', ''),
(28, 1, 'Techno', ''),
(29, 1, 'Tribal House', ''),
(30, 1, 'US/Tech House', ''),
(31, 1, 'US House', ''),
(32, 1, 'Vocal House', ''),
(33, 1, 'Vocal Trance', ''),
(34, 1, 'US/25', '');
Once run, the only categories that actually appear in my sites admin area are numbers 4 & 5.
I am running Zencart 1.3.7 with mysql 5.0
Any ideas why please?
Cheers
Claire



