500 internal server error when opening ub tool

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

Profile photo of ubdev Staff 98590.00 $tone August 3, 2018
Public

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
 

#1
Profile photo of hitech 350.00 $tone August 3, 2018
Public

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.

#2
Profile photo of Mall Staff 184060.00 $tone August 3, 2018
Public

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.

#3
Profile photo of hitech 350.00 $tone August 3, 2018
Public

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

#4
Profile photo of Mall Staff 184060.00 $tone August 3, 2018
Public

Hi there,
Yeah, let’s continue with steps of data migration as our guide. And contact me if you need further assistance.
Regards,
Mall.

#5
Profile photo of hitech 350.00 $tone August 8, 2018
Public

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,

#6
Profile photo of Mall Staff 184060.00 $tone August 9, 2018
Public

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.

#7
Profile photo of hitech 350.00 $tone August 9, 2018
Public

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

#8
Profile photo of Mall Staff 184060.00 $tone August 9, 2018
Public

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.

#9
Profile photo of hitech 350.00 $tone August 9, 2018
Public

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.

#11
Profile photo of Mall Staff 184060.00 $tone August 10, 2018
Public

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.

#12
Profile photo of hitech 350.00 $tone August 10, 2018
Public

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,

#13
Profile photo of Mall Staff 184060.00 $tone August 10, 2018
Public

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.

#14
Profile photo of Mall Staff 184060.00 $tone August 13, 2018
Public

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.

#17
Profile photo of Mall Staff 184060.00 $tone August 13, 2018
Public

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.

#19
Profile photo of hitech 350.00 $tone August 13, 2018
Public

 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?

#20
Profile photo of Mall Staff 184060.00 $tone August 14, 2018
Public

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.
 

#22
Profile photo of hitech 350.00 $tone October 10, 2018
Public

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?

#23
Profile photo of Mall Staff 184060.00 $tone October 11, 2018
Public

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.

#24
Profile photo of ubdev Staff 98590.00 $tone October 11, 2018
Public

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

#26
Profile photo of ubdev Staff 98590.00 $tone October 12, 2018
Public

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

#27
Profile photo of Mall Staff 184060.00 $tone October 13, 2018
Public

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.

#29
Profile photo of hitech 350.00 $tone October 13, 2018
Public

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.

#30
Profile photo of Mall Staff 184060.00 $tone October 15, 2018
Public

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.
 

#31
Profile photo of hitech 350.00 $tone October 18, 2018
Public

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.

#32
Profile photo of Parimal Makwana 50.00 $tone June 3, 2019
Public

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.

#34
Profile photo of ubdev Staff 98590.00 $tone June 3, 2019
Public

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

#35
Profile photo of Parimal Makwana 50.00 $tone June 3, 2019
Public

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 

#36
Profile photo of ubdev Staff 98590.00 $tone June 3, 2019
Public

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

#37
Profile photo of Parimal Makwana 50.00 $tone June 3, 2019
Public

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.

#38
Profile photo of ubdev Staff 98590.00 $tone June 3, 2019
Public

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

#39

Please login or Register to Submit Answer

Written By

Comments