Suitecrm: Upgrade 7.8.31 to 7.11.7 fails, no update possible

[gunnicom]

Issue

Upgrade 7.8.31 to 7.11.7 fails

Expected Behavior

Upgrade should work

Actual Behavior

Upgrade fails, Upgrade wizard page only shows blank in the content area.
[Mon Aug 05 09:42:28.619975 2019] [proxy_fcgi:error] [pid 31838:tid 139744787097344] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/DOMAINNAME/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php on line 73PHP message: PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/DOMAINNAME/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php on line 971PHP message: PHP Warning: include_once(/var/www/DOMAINNAME/modules/UpgradeWizard/../../include/Imap/ImapHandlerFactory.php): failed to open stream: No such file or directory in /var/www/DOMAINNAME/modules/UpgradeWizard/uw_utils.php on line 45PHP message: PHP Warning: include_once(): Failed opening '/var/www/DOMAINNAME/modules/UpgradeWizard/../../include/Imap/ImapHandlerFactory.php' for inclusion (include_path='/var/www/DOMAINNAME/include/HTMLPurifier/standalone:/var/www/DOMAINNAME/vendor/phpunit/php-code-coverage:/var/www/DOMAINNAME/vendor/phpunit/php-token-stream:/var/www/DOMAINNAME/vendor/phpunit/phpunit:/var/www/DOMAINNAME/vendor/symfony/yaml:/var/www/DOMAINNAME/vendor/phpunit/phpunit-mock-objects:/var/www/DOMAINNAME/include/..:.:/usr/share/php') in /var/www/DOMAINNAME/modules/UpgradeWizard/uw_utils.php on line 45PHP message: PHP Notice: Undefined index: schema_change in /var/www/DOMAINNAME/modules/UpgradeWizard/commit.php on line 83PHP message: PHP Fatal error: Uncaught Error: Call to undefined method EmailAddress::getSendConfirmOptInEmailActionLinkDefs() in /var/www/DOMAINNAME/cache/upgrades/temp/b99Ojm/SuiteCRM-Upgrade-7.8.x-to-7.11.7/modules/Accounts/metadata/detailviewdefs.php:51\nStack trace:\n#0 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/EditViewMerge.php(724): require()\n#1 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/EditViewMerge.php(776): EditViewMerge->loadData('Accounts', 'modules/Account...', '/var/www/crmnem...', 'custom/modules/...')\n#2 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/SugarMerge.php(217): EditViewMerge->merge('Accounts', 'modules/Account...', '/var/www/crmnem...', 'custom/modules/...', true)\n#3 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/SugarMerge.php(185): SugarMerge->mergeFile('Accounts', 'detailviewdefs....', true, true)\n#4 /var/www/DOMAINNAME/modules/Upg...', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:28.955103 2019] [proxy_fcgi:error] [pid 31838:tid 139744711563008] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:28.966945 2019] [proxy_fcgi:error] [pid 31838:tid 139744711563008] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:28.970572 2019] [proxy_fcgi:error] [pid 31838:tid 139744711563008] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:28.972094 2019] [proxy_fcgi:error] [pid 31838:tid 139744787097344] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:28.973594 2019] [proxy_fcgi:error] [pid 31838:tid 139744778704640] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:31.059539 2019] [proxy_fcgi:error] [pid 31838:tid 139744778704640] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ [Mon Aug 05 09:42:31.062428 2019] [proxy_fcgi:error] [pid 31838:tid 139744778704640] [client IPADDRESS:52141] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /var/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/

Possible Fix

Steps to Reproduce

1. Go to upgrade wizard
2. Try to upgrade 7.8.31 to 7.11.7
3. Fail

Context

EOL and not able to update is not really an option
High prio

Your Environment

• SuiteCRM Version used: 7.8.31
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Firefox 67
• Environment name and version (e.g. MySQL, PHP 7): MariaDB 10.2, PHP 7.3.7
• Operating System and version (e.g Ubuntu 16.04): Ubuntu 18.04

[dursuntosun]

Same issue for me. Try it from 7.8.x to 7.10.x to 7.11.x

[Dillon-Brown]

Confirmed, looks like an issue with the merge layouts step. You should only encounter this problem if you have customisations to any of the detailviewdefs in Accounts, Contacts, Prospects, Leads. A temporary solution would be to copy over include/SugarEmailAddress/SugarEmailAddress.php first before running the upgrade.

[gunnicom]

Maybe you should remove the upgrade package until it is fixed.

[gunnicom]

I had to copy include/SugarEmailAddress/getEmailAddressWidget.php too
Got error 'PHP message: PHP Warning: require_once(/var/www/ttt/include/SugarEmailAddress/getEmailAddressWidget.php): failed to open stream: No such file or directory in /var/www/ttt/include/SugarEmailAddress/SugarEmailAddress.php on line 2409PHP message: PHP Fatal error: require_once(): Failed opening required '/var/www/ttt/include/SugarEmailAddress/getEmailAddressWidget.php' (include_path='/var/www/ttt/include/HTMLPurifier/standalone:/var/www/ttt/vendor/phpunit/php-code-coverage:/var/www/ttt/vendor/phpunit/php-token-stream:/var/www/ttt/vendor/phpunit/phpunit:/var/www/ttt/vendor/symfony/yaml:/var/www/ttt/vendor/phpunit/phpunit-mock-objects:/var/www/ttt/include/..:.:/usr/share/php') in /var/www/ttt/include/SugarEmailAddress/SugarEmailAddress.php on line 2409'

[gunnicom]

But still no success. No it breaks after clicking next on the preflight step:

[Mon Aug 05 11:46:38.248137 2019] [proxy_fcgi:error] [pid 78923:tid 139744627635968] [client IPADDRESS:57089] AH01071: Got error 'PHP message: PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/DOMAINNAME/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php on line 73PHP message: PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/DOMAINNAME/cache/smarty/templates_c/%%F6^F60^F609237E%%_headerModuleList.tpl.php on line 971PHP message: PHP Fatal error: Uncaught Error: Call to undefined method Configurator::isConfirmOptInEnabled() in /var/www/DOMAINNAME/include/SugarEmailAddress/SugarEmailAddress.php:2048\nStack trace:\n#0 /var/www/DOMAINNAME/cache/upgrades/temp/i0kQiK/SuiteCRM-Upgrade-7.8.x-to-7.11.7/modules/Accounts/metadata/detailviewdefs.php(51): SugarEmailAddress::getSendConfirmOptInEmailActionLinkDefs('Accounts')\n#1 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/EditViewMerge.php(724): require('/var/www/crmnem...')\n#2 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/EditViewMerge.php(776): EditViewMerge->loadData('Accounts', 'modules/Account...', '/var/www/crmnem...', 'custom/modules/...')\n#3 /var/www/DOMAINNAME/modules/UpgradeWizard/SugarMerge/SugarMerge.php(217): EditViewMerge->merge('Accounts', 'modules/Account...', '/var/www/crmnem...', 'custom/modules/...', true)\n#4 /var/www/DOMAINNAME/modul...', referer: https://DOMAINNAME/

[Dillon-Brown]

@gunnicom Interesting, I haven't seen that one before. I've updated the upgrade packs so they should be working correctly now. I think it might be worth leaving this open even if the latest upgrade packs do resolve the issue though. We either need to update documentation involving function calls in viewdefs or reconsider how merge layouts work.

[gunnicom]

I tried the new version. Well, it is on new version,now, but script timed out after some time. Can not see the exact error in all the notices the suite instances on this system throw.

Here are some:

[Mon Aug 05 12:21:24.253511 2019] [proxy_fcgi:error] [pid 31838:tid 139744711563008] [client IPADDRESS:58669] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined method SugarTheme::getMimeType() in /var/www/DOMAINNAME/include/SugarTheme/getImage.php:82\nStack trace:\n#0 /var/www/DOMAINNAME/include/MVC/preDispatch.php(52): include()\n#1 /var/www/DOMAINNAME/index.php(45): include('/var/www/crmnem...')\n#2 {main}\n thrown in /va r/www/DOMAINNAME/include/SugarTheme/getImage.php on line 82', referer: https://DOMAINNAME/ ... [Mon Aug 05 12:22:54.052576 2019] [proxy_fcgi:error] [pid 78923:tid 139744686384896] [client IPADDRESS:58680] AH01071: Got error 'ke.de/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message:PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Pro ducts_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items. php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_ Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 30PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_Products_Quotes/Line_Items.php on line 29PHP message: PHP Notice: Undefined index: aos in /var/www/DOMAINNAME/modules/AOS_ ... [Mon Aug 05 12:25:13.266739 2019] [proxy_fcgi:error] [pid 78923:tid 139744686384896] (104)Connection reset by peer: [client IPADDRESS:58680] AH01075: Error dispatching request to : , referer: https://DOMAINNAME/

[Dillon-Brown]

Hmm, that looks different from the merge layouts issue. I'm guessing this is a problem specific to the 7.8.x -> 7.11.7 upgrade pack.

[Dillon-Brown]

Updated the 7.8.x to 7.11.7 pack to hopefully fix this last fatal. Appreciate all the help debugging this @gunnicom

[gunnicom]

I will try the next days, if it works for me on a different instance.

[gunnicom]

I tried on a different instance, but i ran in the timeout again. php-fpm has a timeout of 300 now, so i will try to increase that on the next try.

[anothermouse]

Also hit this problem......however, uploading from 7.8.x to 7.10.21, and then carrying out the upgrade patch before moving on sidesteps this error....and update in steps rather than all in one go.
https://sourceforge.net/projects/suitecrm/files/
to find individual updates.