Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Exception error importing data into Store on local installation  
Posted: 06 February 2019 01:48 PM —  
Newbie
Rank
Total Posts:  18
Joined  2011-06-18

Hi Andrew

When importing CSV data that contains Expresso Store fields on my local installation I keep getting the following exception error:

Exception Caught
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ‘’ for column `exp_bluetiger`.`exp_store_products`.`free_shipping` at row 1:
insert into `exp_store_products` (`entry_id`, `price`, `weight`, `length`, `width`, `height`, `handling`, `free_shipping`) values (225, ‘129’, NULL, NULL, NULL, NULL, NULL, ‘’) (SQL: insert into `exp_store_products` (`entry_id`, `price`, `weight`, `length`, `width`, `height`, `handling`, `free_shipping`) values (225, 129, , , , , , ))
user/addons/store/vendor/illuminate/database/Illuminate/Database/Connection.php:555

However when i perform the same import on the live site (which is identical to the local site) it all works without issue. The only difference is that my local server runs PHP 7.3 and the live server is still on 5.6 (although soon to be upgraded to 7.2).

Any ideas what could be causing this?

EE 5.1.3
Store 4.1
DataGrab 3.0.3

Not sure if it’s related but I also get the following warning:

Warning
count(): Parameter must be an array or an object that implements Countable
user/addons/ajw_datagrab/datatypes/ajw_csv/dt.ajw_csv.php, line 129

Thanks

David

Profile
 

‹‹ Potential adjustments to Transcribe support      Structure url_titles are reset on import ››

Select A Theme