Upgrade to Magento 2.3.1 and php 7.2

Before going live we upgraded magento to 2.3 (and to a newer server) and that needs php 7.2, so everything works now in the new environment, but… I only wanted to do the last step, a delta migration with UB Data Migration Pro (3.1.4).. and that crashes, seems that my version in not working with php 7.2 (or magento 2.3)? This should be my last step before going live.. ;-(
Can you help me fixing this problem?
Thanks in advance

  1. And with compiling we get: Fatal error: Declaration of Ubertheme\Ubdatamigration\Model\Indexer\Product\Category\Action\Full\Interceptor::execute(): Ubertheme\Ubdatamigration\Model\Indexer\Product\Category\Action\Full must be compatible with Magento\Catalog\Model\Indexer\Category\Product\Action\Full::execute(): Magento\Catalog\Model\Indexer\Category\Product\Action\Full in /var/www/vhosts/prod/public_html/generated/code/Ubertheme/Ubdatamigration/Model/Indexer/Product/Category/Action/Full/Interceptor.php on line 7

11 answers

Profile photo of Mall Staff 184060.00 $tone May 7, 2019
Public

Hi there,
After upgrading to Magento 2.3, you need to upgrade to the latest UB Data Migration Pro version 3.1.9 before you can continue with delta migration with our migration tool.
Our old migration tool versions are not compatible with Magento 2.3.1. 

Regards,
Mall.

#1
Profile photo of Mall Staff 184060.00 $tone May 7, 2019
Public

Hi there,

I see it says Magento ver. 2.2.5 is this a problem?

No, that is corrected information.

CDbException
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] Connection timed out

That is a server’s issue, you should re-check the database credentials and contact to system admin or hosting provider to get more help on that issue.
Regards,
Mall.

#3
Profile photo of web.support 280.00 $tone May 9, 2019
Public

With PHPMyadmin i can connect with the same credentials as in the table “ub_migrate_step” 
Problem:
The older version i had installed it under Magento 2.2.8 and PHP 7.0, i migrated it to newer server, and upgraded it to magento 2.3.1 with PHP 7.2, and just bought and installed the latest version of ub.
now while compiling (php bin/magento setup:di:compile) i get ..
Compilation was started.
Interceptors generation… 4/7 [===============>———--] 57% 26 secs 253.0 MiBPHP Fatal error: Declaration of Ubertheme\Ubdatamigration\Model\Indexer\Product\Category\Action\Full\Interceptor::execute(): Ubertheme\Ubdatamigration\Model\Indexer\Product\Category\Action\Full must be compatible with Magento\Catalog\Model\Indexer\Category\Product\Action\Full::execute(): Magento\Catalog\Model\Indexer\Category\Product\Action\Full in /var/www/vhosts/prod/public_html/generated/code/Ubertheme/Ubdatamigration/Model/Indexer/Product/Category/Action/Full/Interceptor.php on line 7
Thats why i think it’s not a database issue. Do i have to clean /pub/ub-tool/   or something?
Thanks in advance
Ed de Heus
KBITE

#4
Profile photo of Mall Staff 184060.00 $tone May 9, 2019
Public

Hi Ed de Heus,

Do i have to clean /pub/ub-tool/   or something?

No, you should not do that.

now while compiling (php bin/magento setup:di:compile) i get ..
Compilation was started.
Interceptors generation… 4/7 [===============>———--] 57% 26 secs 253.0 MiBPHP Fatal error: Declaration of 

Please open the SSH terminal, get to your M2 folder and then run the following commands to solve that issue:
rm -rf app/code/Ubertheme/Ubdatamigration/Model
rm -f app/code/Ubertheme/Ubdatamigration/etc/di.xml
php -f bin/magento cache:clean
php -f bin/magento setup:di:compile

And let me know how it goes then.
Regards,
Mall.
 

#6
Profile photo of web.support 280.00 $tone May 9, 2019
Public

Hi Mall. yes that solved the problem with compiling thanks!
But now, still have problems connecting to the database.
Opening in the backend magento the UB Data module gives:
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] Connection timed out
/var/www/vhosts/prod/public_html/pub/ub-tool/yii-1.1.19/db/CDbConnection.php(399)

  1. Can it possible be something with the NGINX settings?

2. The database is also changed, so i changed the connection credentials in the database table is that OK? Or do i have to do it somewhere else also (file system)? 
 
 

#7
Profile photo of web.support 280.00 $tone May 9, 2019
Public

I changed the nginx setting but didnt help, i can connect with phpmyadmin en can connect to mysql at the cli. How do you connect to the database? are the tables en settings still ok?

#8
Profile photo of Mall Staff 184060.00 $tone May 10, 2019
Public

Hi Ed de Heus,

2. The database is also changed,

You can check the databases’ credentials in the configuration file of our migration tool at: pub/ub-tool/protected/config/db.php

If all credentials are correct and the database connection issue still persists, we highly recommend you contact your system admin or hosting provider to get further help on this issue.

Meanwhile, please provide me information of your instance, I will help to check further as well: 

  • URL and Admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let me know the path to your M2 folder

PS. Make sure you mark your reply private or switch this ticket to private mode, then it’s safe to share your site info. Only you and our technical team can access.
Regards,
Mall.

#9
Profile photo of web.support 280.00 $tone May 14, 2019
Public

Hi Mall,
This solved my problem, i did not expect that there was another location with connection credentials, i saw the connection in the database table and changed it. After changing the credentials in the file you recommend, it solved the problem.
Thanks again.. now i can continue to the next step!
Ed de Heus
KBITE

#10
Profile photo of ubdev Staff 98590.00 $tone May 14, 2019
Public

Hi Ed de Heus, 
Glad that it helps. 
Please move forward with the migration process. If you come across any unexpected issue, please get back to us here or submit a new ticket, we will help you out.
PS. Make sure you strictly follow all required steps in the Readme manual that comes packed with your download package. 
Regards,
Ubertheme team

#11

Please login or Register to Submit Answer

Written By

Comments