Partial csv import error

[flexbueno]

Hello,

 

I'm currently having problems importing products using csv files. I had a csv file with 10.000 products, I separated them into files of 200 a piece. The first import only saved 55 products the rest were errors and could not be saved. Now when I try to import another csv they're all errors and manually adding products gives me an 503 error.

 

Is there someone who had a similar issue? If there's more information needed please let me know.

[Dh42]

What errors are you getting?

[flexbueno]

What errors are you getting?

Whenever I'm manually importing a new product I get different errors.. They are all the same kind (error 503 tabs:) but one time it may be Tab : Shipping (503) the next time it's Tab : Categories (503)... So basically I'm getting an error while loading all the tabs.. It does say it's a server error though..

[Dh42]

You should consult with your host about those errors. It is more likely than not a server resource issue.

[flexbueno]

You should consult with your host about those errors. It is more likely than not a server resource issue.

 

Ok I just activated error reporting debug mode, tried to manually import a product and got this error:

 

Duplicate entry '4294967295' for key 'PRIMARY'

INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '2', '1', '0', '0', '0', '1', '0', '0', '', '0', '0', '0', '0', '0', '1', '404', '0', '1', '0000-00-00', 'new', '1', '0', 'both', '0', '0', '2015-10-11 22:07:55', '2015-10-11 22:07:55', '3')

I have a feeling something is not going well in MYSQL