Import Categories Description Mysql

[cjsmiff]

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

[kobra]

This is the correct structure for this:

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_image` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `categories_status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`categories_id`),
  KEY `idx_parent_id_cat_id_zen` (`parent_id`,`categories_id`),
  KEY `idx_status_zen` (`categories_status`),
  KEY `idx_sort_order_zen` (`sort_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`, `categories_status`) VALUES 
(1, 'categories/category_hardware.gif', 0, 1, '2003-12-23 03:18:19', '2004-05-21 00:32:17', 1),
(2, 'categories/category_software.gif', 0, 2, '2003-12-23 03:18:19', '2004-05-22 21:14:57', 1),

[cjsmiff]

Many thanks!