Hey, I'm switching hosts so I'm trying to transfer my mySQL database. When I import my old database in phpmyadmin, I get this:
Error
SQL query:
--
-- Dumping data for table `pligg_categories`
--
INSERT INTO `pligg_categories` ( `category__auto_id` , `category_lang` , `category_id` , `category_parent` , `category_name` , `category_safe_name` , `rgt` , `lft` , `category_enabled` , `category_order` , `category_color` )
VALUES ( 0, 'en', 0, 0, 'all', 'all', 11, 0, 2, 0, '000000' ) , ( 1, 'en', 1, 0, 'free', 'free', 2, 1, 1, 1, '000000' ) , ( 4, 'en', 4, 0, '$0.01 to $5', '0.01to5', 4, 3, 1, 2, '000000' ) , ( 3, 'en', 3, 0, '$5.01 to $10 ', '5.01to10', 6, 5, 1, 3, '000000' ) , ( 5, 'en', 5, 0, '$10.01 to $15', '10.01to15', 8, 7, 1, 4, '000000' ) , ( 6, 'en', 6, 0, '$15.01 to $20 ', '15.01to20', 10, 9, 1, 5, '000000' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '0' for key 1
Any ideas?



Reply With Quote



