AnsweredAssumed Answered

upgrade error Sugar 8.0.1 to 8.0.3

Question asked by Aravind Kumar on May 28, 2019
Latest reply on May 30, 2019 by Aravind Kumar

I'm trying to upgrade SugarCRM from SugarCRM 8.0.1 to SugarCRM 8.0.3

 

- using sugar silent upgrade following the document from SugarCRM here

 

when Performing the Health Check (Command Line Upgrader)

 

MAC 2019-05-28 18:48:48: /Volumes/Git/sugarupgrade

$ php CliUpgrader.php -z /Volumes/Git/silentUpgrade-PRO-8.0.3.zip -l ./silentUpgrade_803.log -s /Volumes/Git/apps/crm/src/ -u admin -S healthcheck

When running the above I am getting the following error: silentUpgrade_803.log

Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - Setting context to: array (
'zip' => '/Volumes/Git/silentUpgrade-PRO-8.0.3.zip',
'log' => '/Volumes/Git/sugarupgrade/silentUpgrade_803.log',
'source_dir' => '/Volumes/Git/apps/crm/src',
'admin' => 'admin',
'stage' => 'healthcheck',
'zip_as_dir' => false,
'php' => '/usr/local/Cellar/php/7.3.1/bin/php',
'script' => '/Volumes/Git/sugarupgrade/CliUpgrader.php',
'argv' =>
array (
0 => 'CliUpgrader.php',
1 => '-z',
2 => '/Volumes/Git/silentUpgrade-PRO-8.0.3.zip',
3 => '-l',
4 => './silentUpgrade_803.log',
5 => '-s',
6 => '/Volumes/Git/apps/crm/src/',
7 => '-u',
8 => 'admin',
9 => '-S',
10 => 'healthcheck',
),
)
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - CliUpgrader v.8.0.3 (build 259) starting
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - Stage unpack starting
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - Checking preflight: PHP
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - Checking preflight: SugarFiles
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - Initializing SugarCRM environment
Tue, 28 May 2019 13:18:48 +0000 [Upgrader] - ERROR: Exception: An exception occurred while executing 'SELECT category, name, value, platform FROM config WHERE category = ?' with params ["tracker"]:

Connection refused

This is the one of the Error Message I get in the Command line:

 

PHP Warning:  Doctrine\DBAL\Driver\Mysqli\MysqliConnection::getServerVersion(): Property access is not allowed yet in /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliConnection.php on line 104

PHP Stack trace:

PHP   1. {main}() /Volumes/Git/sugarupgrade/CliUpgrader.php:0

PHP   2. CliUpgrader->start() /Volumes/Git/sugarupgrade/CliUpgrader.php:667

PHP   3. CliUpgrader->run() /Volumes/Git/sugarupgrade/CliUpgrader.php:437

PHP   4. CliUpgrader->run() /Volumes/Git/sugarupgrade/CliUpgrader.php:649

PHP   5. CliUpgrader->run() /Volumes/Git/sugarupgrade/CliUpgrader.php:654

PHP   6. CliUpgrader->verify() /Volumes/Git/sugarupgrade/UpgradeDriver.php:1852

PHP   7. CliUpgrader->verify() /Volumes/Git/sugarupgrade/CliUpgrader.php:636

PHP   8. CliUpgrader->initSugar() /Volumes/Git/sugarupgrade/UpgradeDriver.php:934

PHP   9. DBManagerFactory::getInstance() /Volumes/Git/sugarupgrade/UpgradeDriver.php:1298

PHP  10. MysqliManager->connect() /Volumes/Git/apps/crm/src/include/database/DBManagerFactory.php:122

PHP  11. MysqliManager->registerError() /Volumes/Git/apps/crm/src/include/database/MysqliManager.php:303

PHP  12. sugar_die() /Volumes/Git/apps/crm/src/include/database/DBManager.php:512

PHP  13. sugar_cleanup() /Volumes/Git/apps/crm/src/include/utils.php:1754

PHP  14. TrackerManager::getInstance() /Volumes/Git/apps/crm/src/include/utils.php:3155

PHP  15. TrackerManager->setup() /Volumes/Git/apps/crm/src/modules/Trackers/TrackerManager.php:78

PHP  16. Administration::getSettings() /Volumes/Git/apps/crm/src/modules/Trackers/TrackerManager.php:42

PHP  17. Administration->retrieveSettings() /Volumes/Git/apps/crm/src/modules/Administration/Administration.php:381

PHP  18. Sugarcrm\Sugarcrm\Dbal\Query\QueryBuilder->execute() /Volumes/Git/apps/crm/src/modules/Administration/Administration.php:91

PHP  19. Sugarcrm\Sugarcrm\Dbal\Connection->executeQuery() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206

PHP  20. Sugarcrm\Sugarcrm\Dbal\Connection->executeQuery() /Volumes/Git/apps/crm/src/src/Dbal/Connection.php:63

PHP  21. Sugarcrm\Sugarcrm\Dbal\Connection->executeQuery() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Portability/Connection.php:120

PHP  22. Sugarcrm\Sugarcrm\Dbal\Connection->connect() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:833

PHP  23. Sugarcrm\Sugarcrm\Dbal\Connection->connect() /Volumes/Git/apps/crm/src/src/Dbal/Connection.php:30

PHP  24. Sugarcrm\Sugarcrm\Dbal\Connection->connect() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Portability/Connection.php:63

PHP  25. Sugarcrm\Sugarcrm\Dbal\Connection->detectDatabasePlatform() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:364

PHP  26. Sugarcrm\Sugarcrm\Dbal\Connection->getDatabasePlatformVersion() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:389

PHP  27. Sugarcrm\Sugarcrm\Dbal\Mysqli\Connection->getServerVersion() /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:436

 

Warning: Doctrine\DBAL\Driver\Mysqli\MysqliConnection::getServerVersion(): Property access is not allowed yet in /Volumes/Git/apps/crm/src/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliConnection.php on line 104

I checked my config.php and the credentials are correct.

'dbconfig' =>
array (
'db_host_name' => '127.0.0.1',
'db_host_instance' => 'SQLEXPRESS',
'db_user_name' => 'sugarcrm',
'db_password' => 'sugarcrm',
'db_name' => 'sugarcrm',
'db_type' => 'mysql',
'db_port' => '',
'db_manager' => 'MysqliManager',
),

Not sure what was the issue. Can someone help if you get a similar issue?

Outcomes