I have this message when I wish to import a database
Erreur
Requête SQL:
-- -- Contenu de la table `bx_ads_category` -- INSERT INTO `bx_ads_category` (`ID`, `Name`, `CEntryUri`, `Description`, `CustomFieldName1`, `CustomFieldName2`, `Unit1`, `Unit2`, `Picture`) VALUES (1, 'Jobs', 'Jobs', 'There is Jobs description', 'salary', 'salary', 'EUR', 'EUR', 'bx_ads.png'), (2, 'Music Exchange', 'Music-Exchange', 'music exchange desc', 'price', 'price', '$', '$', 'bx_ads.png'), (4, 'Housing & Rentals', 'Housing-Rentals', 'Housing & Rentals desc', 'rental', '', '$', '$', 'bx_ads.png'), (5, 'Services', 'Services', 'Services desc', 'price', '', '$', '$', 'bx_ads.png'), (7, 'Casting Calls', 'Casting-Calls', 'Casting Calls desc', '', '', '$', '$', 'bx_ads.png'), (8, 'Personals', 'Personals', 'Personals desc', 'payment', '', '$', '$', 'bx_ads.png'), (9, 'For Sale', 'For-Sale', 'For Sale desc', 'price', 'price', '$', '$', 'bx_ads.png'), (10, 'Cars For Sale', 'Cars-For-Sale', 'Cars For Sale desc', 'price', 'price', '€', '€', 'bx_ads.png'), (11, 'Sport', 'Politiques', [...]
MySQL a répondu:
#1062 - Duplicate entry '1' for key 1