Error when running migrate products types

When i’m trying to run “migrate products” I have this error :
DbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘created_at’ at row 1. The SQL statement executed was: INSERT INTO `catalog_product_entity` (`attribute_set_id`, `type_id`, `has_options`, `required_options`, `entity_id`, `sku`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
 
Trace:
migratecontroller problem at
if ($product2->save()) {

5 answers

Profile photo of ubdev Staff 98030.00 $tone February 16, 2019
Public

Hi Janos Kovacs, 
We wonder which Lite version you’re using? We have an old script on Github which we no longer maintain. We also have another Lite version at Ubertheme, however it comes with many limitations: 

  • It uses an outdated codebase which might lead to unexpected issues
  • It is available for Magento 2.0.7 only, and your M2 must be a fresh instance
  • It does not support Nginx

Thus, please consider moving forward with our newer UB Data Migration Pro version. It will save you pretty much time. 
You can check out a few case studies below to learn more about our Pro version: 

-- Migrating 15,000+ Sales Orders to Magento 2 Using UB Data Migration Pro
-- We did use the Pro version ourself to help Winetasting.com – Migrate 382,047 customer entities to Magento 2
-- And this case study as well -- Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2
-- Case StudySuccessful Magento 2 Data Migration for Kwaaijongens.nl

 
Regards,
Ubertheme team

#1
Profile photo of János Kovács 30.00 $tone February 16, 2019
Public

I downloaded the latest from this site.
I found solution with old phpcode in migrationstep5 file: https://www.ubertheme.com/question/error-when-running-migrate-products/
Now, I need the new verison of this solution 🙂

#2
Profile photo of ubdev Staff 98030.00 $tone February 17, 2019
Public

Hi Janos Kovacs,
We wonder you did download the Lite version at Ubertheme?
If that is the case, please consider using our Pro version instead. Due to our limited resources, we hardly find a chance to update our Lite version which might lead to bugs. 
Thanks for your understanding.
Regards,
Ubertheme team

#3
Profile photo of ubdev Staff 98030.00 $tone February 17, 2019
Public

Hi Janos Kovacs, 
It’s pity we have no release of the Lite version around the date 22-05-07 as you mentioned. For the Lite version at Ubertheme, you can check out this link
In case you’re interested in our UB Data Migration Pro, you can check this link
Regards,
Ubertheme team 

#5

Please login or Register to Submit Answer

Written By

Comments