Import problems csv
- Michel van den Ban
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
11 years 3 weeks ago #378
by Michel van den Ban
Import problems csv was created 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
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.
11 years 3 weeks ago #379
by Daniel
Thanks
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...
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.
- Michel van den Ban
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
11 years 3 weeks ago #380
by Michel van den Ban
Replied by Michel van den Ban on topic Import problems csv
HI it is on auto_incement.
I have a new problem there are no table fields on te new profile. See atachement
I have a new problem there are no table fields on te new profile. See atachement
Please Log in to join the conversation.
11 years 3 weeks ago #381
by Daniel
Thanks
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.