Import problems csv

More
11 years 3 weeks ago #378 by Michel van den Ban
HI,

Can you help me i get the following error when i want to import.

Error
Duplicate entry '' for key 'id' SQL=INSERT INTO `ixb_dataitems` (`description`,`title`,`url`,`image`,`Prijs`,`Select1`,`Select2`,`Select3`,`Select4`,`Select5`,`Select6`,`Select7`,`Select8`) VALUES ('Nieuw in ons programma! De vrolijk gekleurde appartementen van Valsami geven het een complex een gezellige ambiance. Net als het grote zwembad, zijn de...','Aparthotel Valsami',' www.vakantiereisdiscounter.nl/tt/tradetr...land','Zuid-Egeïsche Eilanden','Kremasti','Hotel','4 sterren','zonder eten','Met de auto')

Regards Michel

Please Log in to join the conversation.

More
11 years 3 weeks ago #379 by Daniel
Replied by Daniel on topic Import problems csv
Hi,

Apologies for the issue. It seems the primary key 'id' is not set as auto_increment. So either you need to make it auto increment or import the data with primary key...

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 3 weeks ago #380 by Michel van den Ban
HI it is on auto_incement.

I have a new problem there are no table fields on te new profile. See atachement

Please Log in to join the conversation.

More
11 years 3 weeks ago #381 by Daniel
Replied by Daniel on topic Import problems csv
I think you forgot to attach the screenshot. Thought It seems to be a conflict with some other plugin. Can you please disable the error reporting in global configuration and then try again. Or Please disable the code cleanup plugin if you've installed any....

Thanks
Daniel

Please Log in to join the conversation.

Cron Job Starts