Hi, purchased UB Data Migration Pro (CE) -- 3.1.5
installed in fresh installation of magento 2, however, when try to access in admin link the following error appears:
500 -- Internal Server Error
This is a temporary server error.
Please try to reload the webpage later.
If you are the webmaster of this site please log in to Cpanel and check the Error Logs. You will find the exact reason for this error there.
Common reasons for this error are:
- Incorrect file/directory permissions: Above 755.
In order files to be processed by the webserver, their permissions have to be equal or below 755. You can update file permissions with a FTP client or through cPanel’s File Manager. - Incorrect Apache directives inside .htaccess file.
Make sure you have not specified unsupported directives inside the local .htaccess file. Such include PHP settings and Apache module settings.
Please advise at your earliest as our project delivery deadline is just approaching.
Kind regards,
39 answers
Hi there,
The 500 error indicates that you have wrong folders/files permission for our migration tool to work at: app/code/Ubertheme/Ubdatamigration
Please help to re-update folders/files permission at your end following steps below:
+ Open your terminal and go to your M2 web root folder.
+ Re-update the folders/files permission by running the commands:
find . -type d -exec chmod 755 {} +;
find . -type f -exec chmod 644 {} +;
Please let us know how it goes then.
Regards,
Ubertheme team
we updated permissions as advised, however, now the error says:
CMemCache requires PHP memcache extension to be loaded.
/pub/ub-tool/yii-1.1.19/caching/CMemCache.php(116)
I’ve checked with our datacenter and got confirmation that memcached is installed and configured.
Please advise.
Hi there,
CMemCache requires PHP memcache extension to be loaded.
/pub/ub-tool/yii-1.1.19/caching/CMemCache.php(116)
It seems you have customized settings for cache options in our tool.
As there is no stable php memcache version for PHP7 at the moment, please switch to the file cache option as per default settings of our tool in the cache configuration file at:
pub/ub-tool/protected/config/cache.php
Regards,
Mall.
Many thnx Mall, it opens the interface now for database credentials with default settings of cache config file cache.php as per your instructions. Will proceed now for data migration to see how it goes. Cheers
Hi there,
Yeah, let’s continue with steps of data migration as our guide. And contact me if you need further assistance.
Regards,
Mall.
Hi Mall, data migration up to step 4 is fine, however, it is stuck on step 5 (importing products). When I looked into database only few items were imported and thats it. I reset this step and tried to run the tool from command line, again the same number of products were imported then error. The log is attached.
Please advise.
Kind regards,
Hi there,
The log is attached.
That issue was because you have not installed our tool successfully yet. The error message indicates that a required PHP file was missing in your instance. To solve that issue, please follow steps below:
+ Download the php at HERE
+ Upload the downloaded file to the path: pub/ub-tool/protected/models/mage2/Mage2CatalogProductEntityMediaGalleryValueToEntity.php
+ Once done, you could continue with data migration in the step #5 of our migration tool.
I’m not sure why only one PHP file was missing in your instance. If possible, please consider reinstalling our migration tool in a new Magento 2 instance.
Regards,
Mall.
Thnx Mall, uploaded the file and tried step5 again and faced the error:
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘22045’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `media_type`, `disabled`, `value_id`, `value`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)
You can see error screeshot HERE
Hi there,
1062 Duplicate entry ‘22045’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `media_type`, `disabled`, `value_id`, `value`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)
You can see error screeshot HERE
It seem your M2 has product sample data and you have checked to ‘KEEP ORIGINAL IDs’ checkbox in settings in step #5 of our tool?
Regards,
Mall.
yes, there were few products we created as sample, I’ve deleted them now and will try again to see how it goes. Cheers
now after deleting sample products, we have configured the import of products to keep the IDs and tried step 5, face the error after import of same few number of prouducts:
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘22045’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `media_type`, `disabled`, `value_id`, `value`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)
The error appears on the same product every time so far.
Hi there,
Let’s try with steps below:
+ Reset data migration in the step #5 of our migration tool by run CLI command:
php -f bin/ubdatamigration reset --step=5
+ Empty the table catalog_product_entity_media_gallery in your M2 database by run SQL command:
DELETE FROM `catalog_product_entity_media_gallery`
+ Once done, restart data migration in the step #5 of our tool.
Regards,
Mall.
Hi Mall, we tried with keep IDs for products unchecked and worked fine, however, most of the categories are not showing products under them, though all products are pulled in. Do we need to change/remove the word MIGRATED from the title of each attribute set. We are moving the cats/subcats to default category anyway. We will also try as per your instructions above and to keep the prod IDs to see how it goes (for sure we will do this in a fresh installation) 🙂
Many thanks for your help.
Regards,
Hi there,
We will also try as per your instructions above and to keep the prod IDs to see how it goes (for sure we will do this in a fresh installation)
Yeah, let’s continue with that option and contact me if you need further assistance.
Regards,
Mall.
Hi, we tried to import, till step4 OK with fresh installation, keeping the IDs, however, at step 5 faced THIS ERROR
Hi, we tried to import, till step4 OK with fresh installation, keeping the IDs, however, at step 5 faced THIS ERROR
Hi there,
Error: Class ‘Mage2CatalogProductEntityMediaGalleryValue’ not found in /home/hitechso/retrodesignerwear.co.uk/pub/ub-tool/protected/controllers/Step5Controller.php:745
That because you have not installed our tool successfully yet. The required PHP file was missing in your instance (Mage2CatalogProductEntityMediaGalleryValue.php).
Let’s provide me information about your current M2 instance as below:
+ Admin credentials and URL to back-end
+ SSH credentials and path to M2 folder
I will help to check further and help you out.
Regards,
Mall.
sent email with details pls advise
Hi there,
Error: Class ‘Mage2CatalogProductEntityMediaGalleryValue’ not found in /home/hitechso/retrodesignerwear.co.uk/pub/ub-tool/protected/controllers/Step5Controller.php:745
I’m stay at home now. And i couldn’t access to your instance via SSH. Let’s try steps below to solve that issue:
+ Download the php at HERE
+ Upload the downloaded file to the path: pub/ub-tool/protected/models/mage2/Mage2CatalogProductEntityMediaGalleryValue.php
+ Once done, you could continue with data migration in the step #5 of our migration tool.
If possible, please consider reinstalling our migration tool in a new Magento 2 instance.
Regards,
Mall.
Many Thnx Mall, yes, it worked fine this time. Just a quick question regarding the word merged in front of main category and attribute sets. Should we delete the word or leave it and it would not be displayed anywhere in front end?
and can we run same process to update products on the date before going live to have update products and their stock quantities?
Hi there,
regarding the word merged in front of main category and attribute sets. Should we delete the word or leave it and it would not be displayed anywhere in front end?
Yes, you could edit them to remove the words ‘migrated’ after you complete migration.
and can we run same process to update products on the date before going live to have update products and their stock quantities?
Yes you can. You should refer to the delta migration process as explained in the Readme.html (included in your downloaded package).
Regards,
Mall.
Hi Mall, after data migration successfully, we realised that the items on sale i.e. with special prices are showing now at full prices in M2. We have almost 3k of such products and to assign special prices to all of them manually is very difficult. Can you advise how best can we import products so that the products with the special prices should also hold that special price in M2?
Hi there,
after data migration successfully, we realised that the items on sale i.e. with special prices are showing now at full prices in M2.
That is a strange issue. It seems your product’s special prices have something wrong or special setting cases. I need to take a closer look into that issue, please provide me information of your instance:
- Admin credentials and URL to your M2 back-end
- SSH credentials and let me know the path to your M2 folder
- phpMyadmin credenitals of your M1 and M2 databases
- And some product’s SKU that have the issue you mentioned.
I will help to check further and get back you then.
Regards,
Mall.
sent details via email
Hi Ilyas,
We’ve checked and see the admin and SSH credentials you provided on Aug 13. Since you have our office IPs whitelisted, please give us sometime, we will check right after we’re back to work tomorrow.
Meanwhile, please help to provide the following info as well:
- phpMyadmin credenitals of your M1 and M2 databases
- And some product’s SKU that have the issue you mentioned.
Sincerely,
Ubertheme team
Hi Ilyas,
It seems our timezone is different.
Please help to provide the following info at your earliest convenience so that we can check:
- phpMyadmin credenitals of your M1 and M2 databases
- And some product’s SKU that have the issue you mentioned.
It is friday here, and our team will be off during the weekend. So we hope you can get back as soon as possible.
Sincerely,
Ubertheme team
I’ve responded twice via email with all the details, please check and let me know if any further detail is required
Hi there,
after data migration successfully, we realised that the items on sale i.e. with special prices are showing now at full prices in M2.
I have checked in your instance and I saw the product you mentioned is a configurable product: https://prnt.sc/l5iya4
And the pricing of the configurable products are disabled on M2, prices of this product type calculating on children associated products only.
And this is new working rules of M2 on configurable products. This is different with M1 function on price of configurable product too.
And that is root of issue you mentioned.
Regards,
Mall.
so, what is the solutions for this, can’t you tweak the extension code to address the issue with sales price of each variation of any configurable product to retain as it is? Please advise the solution as we are stuck now in a situation with the client. The project deadline is almost there, however, now client wants all 3k+ products to be imported with sales (offer) prices as well.
Hi there,
Converting special price of configurable product in M1 to special price of associated simple product in M2 is beyond the current feature of our migration tool. It will need paid customization service for this custom tweak.
If this is what you will consider, please let us know additional info below:
if a configurable product with multiple simple products, will you need to convert special price (if any) and apply to a specific associated simple product, or all associated simple product?
Regards,
Mall.
Hi, we have done all the steps as per instructions but still even your tweaked code is not migrating special prices at all. We have spent almost two full days in migration and testing, it honestly seems waste of time and resources. We have provided you the full access to our servers to get your newly tweaked code testing for which we have even paid extra $300 but still standing at the same place from where we started. Please get it sorted or otherwise let us know what is the best way out of this loop.
Hi Ilyas,
Our technical team will debug and get back to you shortly.
Regards,
Ubertheme team
Hello Uberteam,
I have faced an issue in “catalog_product_entity_media_gallery_value” table.
Not migrated all media based on store means I can only see entries for store id 0 BUT we have 2 separate store and different media assignment for all products.
NOTE: we already tried to re-migrate.
Waiting for your reply.
Hi Parimal Makwana,
Please let us know which UB Data Migration Pro version you’re using. We have an outdated script on Github which we no longer maintain.
Meanwhile, we wonder if you have another paid profile at Ubertheme? We could not keep track of your purchase information.
PS. If you have another paid profile here, please submit a new ticket under such account. Our technical support requires active subscription though.
Regards,
Ubertheme team
Hello Uberthem Team,
Thanks for the quick reply!
We are using UB Data Migration Pro v3.1.3.
And yea we have another paid client profile from where we purchase an extension.
As we do not have access of that so I’ll ask the client to do this meanwhile could you please help me on my issue.
Regards,
Parimal
Hi Parimal,
Please instruct your client to submit a ticket under the paid profile, we will follow up further there.
Thanks for your understanding.
Regards,
Ubertheme team
Hello Ubertheme team,
Yea I’ll ask them but it’ll take some time as they belong in the diferetn timezone.
We have depended on this issue could you please give us a hint so we can look into this error.
Hope you understood.
Hi Parimal,
We’re afraid you will need to submit a new ticket under the paid profile at Ubertheme. This is applied to all users.
Thanks for your understanding.
Regards,
Ubertheme team