Problems upgrading from 7.13.4 to 7.14

📦 Install & Upgrade Help
1

I upgraded my suitecrm installation from 7.13.4 (php 7.4) to 7.14 (php 8.1) all seems to work fine but not the home page.

In the home page i have some dashlets and reports and after upgrading I’m receive a blank page and the next error:

[Fri Sep 01 20:49:02.638810 2023] [proxy_fcgi:error] [pid 84355] [client 192.168.72.2:53390] AH01071: Got error ‘PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxxxxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxxxxxxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxxxxxxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128PHP message: PHP Fatal error: Uncaught Error: Non-static method SugarWidgetReportField::_get_column_select() cannot be called statically in /var/www/crm.xxxxxxxxxxx.com/https/include/generic/SugarWidgets/SugarWidgetFieldname.php:231\nStack trace:\n#0 /var/www/crm.xxxxxxx.com/https/include/Dashlets/DashletGeneric.php(365): SugarWidgetFieldName->queryFilterone_of()\n#1 /var/www/crm.xxxxxxx.com/https/include/Dashlets/DashletGeneric.php(416): DashletGeneric->buildWhere()\n#2 /var/www/crm.xxxxxxxxxxx.com/https/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php(84): DashletGeneric->process()\n#3 /var/www/crm.xxxxxxxxx.com/https/modules/Home/index.php(244): MyOpportunitiesDashlet->process()\n#4 /var/www/crm.xxxxxxxx.com/https/modules/Home/views/view.list.php(55): include(’…‘)\n#5 /var/www/crm.xxxxxxxxxxx.com/https/include/MVC/View/SugarView.php(210): HomeViewList->display()\n#6 /var/www/crm.xxxxxxxxxxx.com/https/include/MVC/Controller/SugarController.php(432): SugarView->process()\n#7 /var/www/crm.xxxxxxxxx.co…’

i reseted my preferences and also my home page

What could be the problem?

regards

2

I also upgraded php to 8.2 and got

[Fri Sep 01 21:06:41.118808 2023] [proxy_fcgi:error] [pid 110477] [client 192.168.72.2:53559] AH01071: Got error ‘PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128; PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128; PHP message: PHP Fatal error: Uncaught Error: Non-static method SugarWidgetReportField::_get_column_select() cannot be called statically in /var/www/crm.xxxx.com/https/include/generic/SugarWidgets/SugarWidgetFieldname.php:231\nStack trace:\n#0 /var/www/crm.xxxx.com/https/include/Dashlets/DashletGeneric.php(365): SugarWidgetFieldName->queryFilterone_of()\n#1 /var/www/crm.xxxx.com/https/include/Dashlets/DashletGeneric.php(416): DashletGeneric->buildWhere()\n#2 /var/www/crm.xxxx.com/https/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php(84): DashletGeneric->process()\n#3 /var/www/crm.xxxx.com/https/modules/Home/index.php(244): MyOpportunitiesDashlet->process()\n#4 /var/www/crm.xxxx.com/https/modules/Home/views/view.list.php(55): include(’…‘)\n#5 /var/www/crm.xxxx.com/https/include/MVC/View/SugarView.php(210): HomeViewList->display()\n#6 /var/www/crm.xxxx.com/https/include/MVC/Controller/SugarController.php(432): SugarView->process()\n#7 /var/www/crm.xxxx.co…’, referer: https://crm.xxxxyyyy.lan/index.php?module=Accounts&action=index

3

Check out the fix on this link

4

Thank you

cat SugarWidgetField.php | sed -e ‘s/SugarWidgetFieldid::_get_column_select/$this->_get_column_select/’

i do a quick repair and the error still remains:

[Sat Sep 02 21:32:23.948527 2023] [proxy_fcgi:error] [pid 110483] [client 192.168.72.1:55847] AH01071: Got error ‘PHP message: PHP Deprecated: Using php-function “strpos” as a modifier is deprecated and will be removed in a future release. Use Smarty::registerPlugin to explicitly register a custom modifier. in /var/www/crm.xxxx.com/https/vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_private_modifier.php on line 112; PHP message: PHP Deprecated: Using php-function “strpos” as a modifier is deprecated and will be removed in a future release. Use Smarty::registerPlugin to explicitly register a custom modifier. in /var/www/crm.xxxx.com/https/vendor/smarty/smarty/libs/sysplugins/smarty_internal_compile_private_modifier.php on line 112; PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128; PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128; PHP message: PHP Fatal error: Uncaught Error: Non-static method SugarWidgetReportField::_get_column_select() cannot be called statically in /var/www/crm.xxxxxx.com/https/include/generic/SugarWidgets/SugarWidgetFieldname.php:231\nStack trace:\n#0 /var/www/crm.xxxxstrong text.com/https/include/Dashlets/DashletGeneric.php(365): SugarWidgetFieldName->queryFilterone_of()\n#1 /var/www/crm.xxxx.com/https/include/Dashlets/DashletGeneric.php(416): DashletGeneric->buildWhere()\n#2 /var/www/crm.xxxx.com/https/modules/Opportunities/Dashlets/MyOpportunitiesDashlet/MyOpportunitiesDashlet.php(84): DashletGeneric->process()\n#3 /var/www/crm.xxxx.com/https/modules/Home/index.php(244): MyOpportunitiesDashlet->process()\n#4 /var/www/crm.xxxx.com/https/modules/Home/views/view.list.php(55): include(’…‘)\n#5 /var/www/crm.xxxx.com/https/include/MVC/View/SugarView.php(210): HomeViewList->display()\n#6 /var/www/crm.xxxx.com/https/include/MVC/Controller/SugarController.php(432): SugarView->process()\n#7 /var/www/crm.xxxx.co…’, referer: https://crm.yyyyy.lan/index.php?module=Administration&action=repair

any suggestion on this?

thanks in advance

5

i did the same with include/generic/SugarWidgets/SugarWidgetFieldname.php

I mean

sed -e ‘s/SugarWidgetFieldid::_get_column_select/$this->_get_column_select/’

and now is working almost 100%

i still receiving

[Sat Sep 02 21:53:30.348894 2023] [proxy_fcgi:error] [pid 110478] [client 192.168.72.1:56453] AH01071: Got error ‘PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128; PHP message: PHP Warning: Array to string conversion in /var/www/crm.xxxx.com/https/include/Dashlets/DashletGenericChart.php on line 424; PHP message: PHP Warning: Undefined array key “labelsAndValues” in /var/www/crm.xxxx.com/https/modules/Charts/Dashlets/OutcomeByMonthDashlet/OutcomeByMonthDashlet.php on line 128’, referer: https://crm.innovery.lan/index.php?module=Home&action=index

and can’t add a new dashlet … apparently is not doing anything

Thanks!

6

worked for me thanks for that