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
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 Study: Successful Magento 2 Data Migration for Kwaaijongens.nl
Regards,
Ubertheme team
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 🙂
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
If you could give a migration lite link of version around date 22-05-2017 with migration step 5 controller, it will be good for me 🙂 Can you?