Skip to main content

import data from feed

More
9 years 3 months ago #3490 by ricardo15
Hello,
I tried to import data into datafeed component from xml file. I created a new parser and the fields from xml linked to fields in datafeed.

When I try to import I get this:

Start previous 2001-01-01 01:01:01 : 0.001
Field 'Select10' doesn't have a default valueinsert LOW_PRIORITY into rknp_dataitems ( url, status, description, data, feed,Select0,title,Prijs, image, id, feed_id, adddate ) values ( ' pesklub.cz/brit-premium-dog-adult-m-3-kg...kg-21#/hmotnost-1_kg ', 1, '', 'a:0:{}', 'PesKlub','all','Brit Premium Dog Adult M 1 kg',55, ' pesklub.cz/36-large_default/brit-premium-dog-adult-m.jpg ', '1a35fcda03d3d34c8dde0dee2e521a98', '23', now()) on duplicate key update status=1,url=' pesklub.cz/brit-premium-dog-adult-m-3-kg...',prijs=55,data='a:0 :{}'
Cleanup of unpublised feed items : 0.000
0 items in database : 0.001
Optimize start : 0.001
Clean End : 0.001
0 items in database : 0.002


Can you help me with this please?

Thank you
Regards
Tomas

Please Log in to join the conversation.

More
9 years 3 months ago - 9 years 3 months ago #3491 by redactie
Replied by redactie on topic import data from feed
ok,

i think you mysql server is running in strict mode.

can you alter the database?
Code:
ALTER TABLE `rknp_dataitems` CHANGE `Select10` `Select10` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select11` `Select11` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select12` `Select12` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select13` `Select13` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', CHANGE `Select14` `Select14` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select15` `Select15` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select16` `Select16` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select17` `Select17` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select18` `Select18` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `Select19` `Select19` VARCHAR(55) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';

I will fix this for future versions

bram
Last edit: 9 years 3 months ago by redactie.
The following user(s) said Thank You: ricardo15

Please Log in to join the conversation.

More
9 years 3 months ago - 9 years 3 months ago #3496 by ricardo15
Replied by ricardo15 on topic import data from feed
It works, thank you bram.
Last edit: 9 years 3 months ago by ricardo15.

Please Log in to join the conversation.

Time to create page: 0.465 seconds