Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Major import Errors in EE3  
Posted: 17 August 2016 12:58 PM —  
Newbie
Rank
Total Posts:  7
Joined  2011-08-29

Using Datagab 2.0.2 with EE3.4.1, I can get through the import setup without any problems, but it throws errors when trying to import. Have tried with csv and xml with the same result:

Exception Caught
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'field_id_6' at row 1:
INSERT INTO `exp_channel_data` (`entry_id`, `channel_id`, `site_id`, `field_id_20`, `field_ft_20`, `field_id_21`, `field_ft_21`, `field_id_22`, `field_ft_22`, `field_id_23`, `field_ft_23`, `field_id_26`, `field_ft_26`, `field_ft_1`, `field_id_1`, `field_ft_2`, `field_id_2`, `field_ft_3`, `field_id_3`, `field_ft_4`, `field_id_4`, `field_ft_5`, `field_id_5`, `field_ft_6`, `field_id_6`, `field_ft_7`, `field_id_7`, `field_ft_8`, `field_id_8`, `field_ft_9`, `field_id_9`, `field_ft_10`, `field_id_10`, `field_ft_11`, `field_id_11`, `field_ft_12`, `field_id_12`, `field_ft_13`, `field_id_13`, `field_ft_14`, `field_id_14`, `field_ft_15`, `field_id_15`, `field_ft_16`, `field_id_16`, `field_ft_17`, `field_id_17`, `field_ft_18`, `field_id_18`, `field_ft_19`, `field_id_19`, `field_ft_24`, `field_id_24`, `field_ft_25`, `field_id_25`, `field_ft_27`, `field_id_27`, `field_ft_28`, `field_id_28`, `field_ft_29`, `field_id_29`, `field_ft_30`, `field_id_30`) VALUES ('32', '7', '1', '1000', 'none', 'Test Entry', 'none', 'Test Entry', 'none', '601.123.4567', 'none', 'Purple', 'br', 'xhtml', '', 'br', '', 'xhtml', '', 'none', '', 'br', '', 'none', '', 'br', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '', 'none', '', 'br', '', 'none', '', 'xhtml', '', 'xhtml', '', 'none', '', 'br', '', 'none', '', 'none', '', 'none', '', 'xhtml', '', 'none', '', 'none', '')

ee/legacy/database/drivers/mysqli/mysqli_connection.php:119

If I try to run it with Categories applied, it doesn’t even get that far. All I get is this error message:

SQLSTATE[HY000]: General error: 1364 Field 'cat_order' doesn't have a default value:
INSERT INTO `exp_categories` (`group_id`, `site_id`, `cat_name`, `cat_url_title`, `cat_image`, `parent_id`) VALUES ('1', '1', 'Hotel', 'hotel', '', 0)

ee/legacy/database/drivers/mysqli/mysqli_connection.php:119
Profile
 
Posted: 25 August 2017 10:02 PM —   [ # 1 ]  
Newbie
Rank
Total Posts:  3
Joined  2017-08-25

Me too different Field but same message.

Profile
 
Posted: 13 October 2017 07:38 PM —   [ # 2 ]  
Newbie
Rank
Total Posts:  1
Joined  2017-10-13

Same here. Any solutions or help on this one??

Profile
 
Posted: 27 October 2017 11:09 PM —   [ # 3 ]  
Newbie
Rank
Total Posts:  3
Joined  2017-08-25

So this turned out to be an issue with one of my fields. Simple Text field; allowed content being ‘integer”. I changed it to all and the import was smooth.

Profile
 

‹‹ CSV Check box Imports      Data Import Error for non published field ››

Select A Theme