Hello,
Must deleting:
_content
_flexicontent_fields_item_relations
_flexicontent_items_ext
_flexicontent_cats_item_relations
I still test 10 items, and some item failed yet
example, Here 3 items failed:
Code:
Failed item no: 1. titled as: 'Autriche, au fil des quatre saisons, ciné-conférence' :
Imported item no: 2. titled as: 'Bourg-en-Bresse - Denain, Pro B, basket-ball'
Imported item no: 3. titled as: 'Bourg-en-Bresse - Poitiers, Pro B, basket-ball'
Imported item no: 4. titled as: 'Bourg-en-Bresse - Saint-Vallier, Pro B, basket-ball'
Imported item no: 5. titled as: 'Bourg-en-Bresse - Châlons-Reims, Pro B, basket-ball'
Imported item no: 6. titled as: 'Bourg-en-Bresse - Hyères-Toulon, Pro B, basket-ball'
Imported item no: 7. titled as: 'Bourg-en-Bresse - Rouen, Pro B, basket-ball'
Failed item no: 8. titled as: 'Bourg-en-Bresse - Fos-sur-Mer, Pro B, basket-ball' :
Failed item no: 9. titled as: 'Bourg-en-Bresse - Aix-Maurienne, Pro B, basket-ball' :
Imported item no: 10. titled as: 'Bourg-en-Bresse - Evreux, Pro B, basket-ball'
I don't understand.
To solve the problem. After import csv, I decided to do sql query that delete items with an asset_id = '0'
With a csv ( 620 items) and Items per import step:2
there is 542 Failed ????
After deleting items with asset_id=0. I try to create a item manually on backend and I have message: Error content storage.
I repeat this three times before it works ??? Strange
May be that the problem comes from my sql query that do reinitialization of the auto-increment (id) of content after delete items ?
Code:
"ALTER TABLE #_content AUTO_INCREMENT = $id_max";
Regards
