- Posts: 13
- Thank you received: 0
import data from feed
9 years 3 months ago #3490
by ricardo15
import data from feed was created 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
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.
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?
I will fix this for future versions
bram
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.
Time to create page: 0.465 seconds