davewave 0 Posted March 26, 2014 1062; Duplicate entry '292' for key 'PRIMARY';INSERT INTO `ps_category` (`id_category`, `id_parent`, `id_shop_default`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES (292, 290, 1, 0, 0, 0, 1, '2014-03-27 00:00:22', '2014-03-27 00:00:22', 2, 0);1062; Duplicate entry '292-1-1' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (292, 1, 1, 'Bluetooth', NULL, 'bluetooth', '', '', '');1062; Duplicate entry '292-1-2' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (292, 1, 2, 'Bluetooth', NULL, 'bluetooth', '', '', '');1062; Duplicate entry '292-1-3' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (292, 1, 3, 'Bluetooth', NULL, 'bluetooth', '', '', '');1062; Duplicate entry '7' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (7, 'Plantronics', '2014-03-27 00:01:49', '2014-03-27 00:01:49', 1);1062; Duplicate entry '7-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (7, 1, NULL, NULL, 'Plantronics', 'Plantronics', 'Plantronics');1062; Duplicate entry '7-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (7, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '7-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (7, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '8' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (8, 'Alcatel onetouch', '2014-03-27 00:02:15', '2014-03-27 00:02:15', 1);1062; Duplicate entry '8-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (8, 1, NULL, NULL, 'Alcatel onetouch', 'Alcatel onetouch', 'Alcatel onetouch');1062; Duplicate entry '8-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (8, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '8-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (8, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '9' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (9, 'Belkin', '2014-03-27 00:02:29', '2014-03-27 00:02:29', 1);1062; Duplicate entry '9-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (9, 1, NULL, NULL, 'Belkin', 'Belkin', 'Belkin');1062; Duplicate entry '9-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (9, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '9-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (9, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '10' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (10, 'Bluestar', '2014-03-27 00:02:40', '2014-03-27 00:02:40', 1);1062; Duplicate entry '10-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (10, 1, NULL, NULL, 'Bluestar', 'Bluestar', 'Bluestar');1062; Duplicate entry '10-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (10, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '10-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (10, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '11' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (11, 'bugatti', '2014-03-27 00:02:53', '2014-03-27 00:02:53', 1);1062; Duplicate entry '11-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (11, 1, NULL, NULL, 'bugatti', 'bugatti', 'bugatti');1062; Duplicate entry '11-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (11, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '11-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (11, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '12' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (12, 'Case-Mate', '2014-03-27 00:03:08', '2014-03-27 00:03:08', 1);1062; Duplicate entry '12-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (12, 1, NULL, NULL, 'Case-Mate', 'Case-Mate', 'Case-Mate');1062; Duplicate entry '12-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (12, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '12-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (12, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '13' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (13, 'Jabra', '2014-03-27 00:03:20', '2014-03-27 00:03:20', 1);1062; Duplicate entry '13-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (13, 1, NULL, NULL, 'Jabra', 'Jabra', 'Jabra');1062; Duplicate entry '13-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (13, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '13-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (13, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '14' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (14, 'Kensington', '2014-03-27 00:03:37', '2014-03-27 00:03:37', 1);1062; Duplicate entry '14-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (14, 1, NULL, NULL, 'Kensington', 'Kensington', 'Kensington');1062; Duplicate entry '14-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (14, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '14-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (14, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '15' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (15, 'LG', '2014-03-27 00:03:49', '2014-03-27 00:03:49', 1);1062; Duplicate entry '15-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (15, 1, NULL, NULL, 'LG', 'LG', 'LG');1062; Duplicate entry '15-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (15, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '15-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (15, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '16' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (16, 'Motorola', '2014-03-27 00:04:00', '2014-03-27 00:04:00', 1);1062; Duplicate entry '16-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (16, 1, NULL, NULL, 'Motorola', 'Motorola', 'Motorola');1062; Duplicate entry '16-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (16, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '16-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (16, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '17' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (17, 'Otterbox', '2014-03-27 00:04:12', '2014-03-27 00:04:12', 1);1062; Duplicate entry '17-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (17, 1, NULL, NULL, 'Otterbox', 'Otterbox', 'Otterbox');1062; Duplicate entry '17-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (17, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '17-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (17, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '18' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (18, 'Ozaki', '2014-03-27 00:04:24', '2014-03-27 00:04:24', 1);1062; Duplicate entry '18-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (18, 1, NULL, NULL, 'Ozaki', 'Ozaki', 'Ozaki');1062; Duplicate entry '18-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (18, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '18-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (18, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '19' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (19, 'Pierre Cardin', '2014-03-27 00:04:36', '2014-03-27 00:04:36', 1);1062; Duplicate entry '19-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (19, 1, NULL, NULL, 'Pierre Cardin', 'Pierre Cardin', 'Pierre Cardin');1062; Duplicate entry '19-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (19, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '19-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (19, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '20' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (20, 'power star', '2014-03-27 00:04:51', '2014-03-27 00:04:51', 1);1062; Duplicate entry '20-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (20, 1, NULL, NULL, 'power star', 'power star', 'power star');1062; Duplicate entry '20-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (20, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '20-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (20, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '21' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (21, 'Star-Case', '2014-03-27 00:05:06', '2014-03-27 00:05:06', 1);1062; Duplicate entry '21-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (21, 1, NULL, NULL, 'Star-Case', 'Star-Case', 'Star-Case');1062; Duplicate entry '21-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (21, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '21-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (21, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '22' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (22, 'SwitchEasy', '2014-03-27 00:05:24', '2014-03-27 00:05:24', 1);1062; Duplicate entry '22-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (22, 1, NULL, NULL, 'SwitchEasy', 'SwitchEasy', 'SwitchEasy');1062; Duplicate entry '22-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (22, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '22-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (22, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '3' for key 'PRIMARY'; INSERT INTO `ps_supplier` (`id_supplier`, `name`, `date_add`, `date_upd`, `active`) VALUES (3, 'Wegatrade', '2014-03-27 00:07:24', '2014-03-27 00:07:24', 0);1062; Duplicate entry '3-1' for key 'PRIMARY'; INSERT INTO ps_supplier_lang (id_supplier, id_lang, description, meta_title, meta_keywords, meta_description) VALUES (3, 1, ' http://www.wegatrade.de \r wegacell ', '', '', '');1062; Duplicate entry '3-2' for key 'PRIMARY'; INSERT INTO `ps_supplier_lang` (`id_supplier`, `id_lang`, `description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (3, 2, NULL, NULL, NULL, NULL);1062; Duplicate entry '3-3' for key 'PRIMARY'; INSERT INTO `ps_supplier_lang` (`id_supplier`, `id_lang`, `description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (3, 3, NULL, NULL, NULL, NULL);1062; Duplicate entry '293' for key 'PRIMARY'; INSERT INTO `ps_category` (`id_category`, `id_parent`, `id_shop_default`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES (293, 290, 1, 0, 0, 0, 1, '2014-03-27 00:08:32', '2014-03-27 00:08:32', 3, 0);1062; Duplicate entry '293-1-1' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (293, 1, 1, 'Bluetooth Lautsprecher', NULL, 'bluetooth-lautsprecher', '', '', '');1062; Duplicate entry '293-1-2' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (293, 1, 2, 'Bluetooth Lautsprecher', NULL, 'bluetooth-lautsprecher', '', '', '');1062; Duplicate entry '293-1-3' for key 'PRIMARY'; INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (293, 1, 3, 'Bluetooth Lautsprecher', NULL, 'bluetooth-lautsprecher', '', '', '');1062; Duplicate entry '23' for key 'PRIMARY'; INSERT INTO `ps_manufacturer` (`id_manufacturer`, `name`, `date_add`, `date_upd`, `active`) VALUES (23, 'BeeWi', '2014-03-27 00:10:12', '2014-03-27 00:10:12', 1);1062; Duplicate entry '23-1' for key 'PRIMARY'; INSERT INTO ps_manufacturer_lang (id_manufacturer, id_lang, description, short_description, meta_title, meta_keywords, meta_description) VALUES (23, 1, NULL, NULL, 'BeeWi', 'BeeWi', 'BeeWi');1062; Duplicate entry '23-2' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (23, 2, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '23-3' for key 'PRIMARY'; INSERT INTO `ps_manufacturer_lang` (`id_manufacturer`, `id_lang`, `description`, `short_description`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (23, 3, NULL, NULL, NULL, NULL, NULL);1062; Duplicate entry '11' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (11, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 0, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 2, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:11:40', '2014-03-27 00:11:40', 0);1062; Duplicate entry '11-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (11, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '11-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (11, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '11-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (11, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '12' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (12, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 99, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:12:04', '2014-03-27 00:12:04', 0);1062; Duplicate entry '12-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (12, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '293-12' for key 'PRIMARY'; INSERT INTO ps_category_product (id_category, id_product, position) VALUES (293, 12, 1);1062; Duplicate entry '12-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (12, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '12-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (12, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '13' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (13, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 99, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:12:10', '2014-03-27 00:12:10', 0);1062; Duplicate entry '13-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (13, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '293-13' for key 'PRIMARY'; INSERT INTO ps_category_product (id_category, id_product, position) VALUES (293, 13, 2);1062; Duplicate entry '13-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (13, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '13-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (13, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '14' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (14, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 99, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:12:14', '2014-03-27 00:12:14', 0);1062; Duplicate entry '14-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (14, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '293-14' for key 'PRIMARY'; INSERT INTO ps_category_product (id_category, id_product, position) VALUES (293, 14, 3);1062; Duplicate entry '14-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (14, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '14-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (14, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '15' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (15, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 99, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:12:20', '2014-03-27 00:12:20', 0);1062; Duplicate entry '15-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (15, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '293-15' for key 'PRIMARY'; INSERT INTO ps_category_product (id_category, id_product, position) VALUES (293, 15, 4);1062; Duplicate entry '15-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (15, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '15-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (15, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '16' for key 'PRIMARY'; INSERT INTO `ps_product` (`id_product`, `id_supplier`, `id_manufacturer`, `id_category_default`, `id_shop_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ean13`, `upc`, `ecotax`, `quantity`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `out_of_stock`, `quantity_discount`, `customizable`, `uploadable_files`, `text_fields`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `cache_default_attribute`, `date_add`, `date_upd`, `advanced_stock_management`) VALUES (16, 3, 23, 293, 1, 0, 0, 0, '', '', 0, 99, 1, 0, 0, '', 0, 0, '', '', '', 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, '', 0, 1, '2014-03-27', 'new', 1, 0, 'both', 0, 0, 0, 0, '2014-03-27 00:12:22', '2014-03-27 00:12:22', 0);1062; Duplicate entry '16-1-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (16, 1, 1, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '293-16' for key 'PRIMARY'; INSERT INTO ps_category_product (id_category, id_product, position) VALUES (293, 16, 5);1062; Duplicate entry '16-1-2' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (16, 1, 2, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL);1062; Duplicate entry '16-1-3' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (16, 1, 3, NULL, NULL, 'aaa', '', '', '', 'AAA', NULL, NULL); Share this post Link to post Share on other sites
Luca01 130 Posted March 27, 2014 Hallo davewave, warum spammst Du hier rum? Das ist sehr unhöflich. Der sql-Fehler steht doch da. duplicate entry = doppelter Eintrag for key primary = des Primärschlüssels insert into ps_product_lang = beim Eintragen in die Tabelle ps_product_lang Viele Grüße Share this post Link to post Share on other sites
davigo 8 Posted March 27, 2014 Hallo, diese Form der Anfrage finde ich auch äußerst ungewöhnlich und freilich sinnlos lang. Trotzdem ist das mal ein interessanter Einblick; so verhält sich der „Store Manager“ … der Versuch von „Insert“ vor jeglicher Prüfung z.B. auf Möglichkeit „Update“? Dann habe ich starke Zweifel daran, dass das Teil mit wirklich großen Datenmengen umgehen kann. MfG Share this post Link to post Share on other sites
davewave 0 Posted March 27, 2014 hatte nur 5 Artikel drin die ich online stellen wollte, nur einer ging online von den 5, aber nicht alles dazu.... grrrr sorry für den Spam hier :-/ Share this post Link to post Share on other sites
davigo 8 Posted March 28, 2014 5 Artikel, Oh! Mal abgesehen von dem konkreten Problem „duplicate entry = doppelter“ Eintrag: Zum Testen würde ich die Verwendung möglichst weniger Felder empfehlen, z.B. ohne Angaben für die Tabellen manufacturer, supplier … in der Hoffnung, dass diese Tabellen/Felder von dem Tool dann nicht trotzdem in SQL-Command eingebaut werden (wie leider hier sichtbar - diese ganzen leeren Felder). -Die lokale Erstellung eines optimalen SQL-Command erfordert letztlich viel weniger Laufzeit als das DB - Execute mit einheitlich sinnlos-langen Commands! Ansonsten könnten wir ja gelich alles im BO (mit PHP) machen, oder? MfG Share this post Link to post Share on other sites