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 —   [ Ignore ]  
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]
Warning1265 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 error1364 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 —   [ Ignore ]   [ # 1 ]  
Newbie
Rank
Total Posts:  2
Joined  2017-08-25

Me too different Field but same message.

Profile
 
 
Posted: 13 October 2017 07:38 PM —   [ Ignore ]   [ # 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 —   [ Ignore ]   [ # 3 ]  
Newbie
Rank
Total Posts:  2
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