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 1292Incorrect 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