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 —  
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, , , , , , ))

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:

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



Posted: 14 November 2019 02:29 PM —   [ # 1 ]  
Total Posts:  1
Joined  2019-11-13

Ran and all boxes are run for the fluctuation for the terms. The total aspects of the programs and essaypro com are introduced for all kids. The management of the block is done for the approval of the documents. The turn is done for the attachment in themed of the documents.


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

Select A Theme