Hello!
I am currently using v1.3.9h ( I am currently working on upgrading on a test Data base but still keeping main one alive and new items just arrived!)
I didn't have problems with this before... so I don't know why I suddenly am now.
ERROR MESSAGE
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
checking the debug log, it said
PHP Code:
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO zen_products SET
products_model = '251193_blue' ,
products_price = '49.99' ,
products_image = 'newArrivals/251193_blue.jpg' ,
products_weight = '0.8' ,
products_weight_type = 'lbs' ,
products_dim_type = 'in' ,
products_length = '10' ,
products_width = '10' ,
products_height = '8' ,
products_ready_to_ship = '0' ,
products_tax_class_id = '2' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '1' ,
master_categories_id = '121' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '1',
metatags_products_name_status = '1',
metatags_model_status = '1',
metatags_price_status = '1',
metatags_title_tagline_status = '1'
SO then I added a new column called v_date_avail
and added 10/26/2016 23:45
still import problems with same error message
So then I replaced v_date_avail with v_date_available
10/26/2016 23:45
STILL doesn't work.... same error message
Warning An SQL error has occurred. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
I have troubled shoot as many angles as I can. I changed date formats
2016/10/26 23:45
10/26/2016 23:45
26/10/2016 23:45
I tried to set 1 item with a date available so I can export it and see how easy populate shows the date format... but it doesn't show up in the excel for me to take a look...
Any suggestions would be great! Thanks so much
Bookmarks