Report Dashlet Not Loading Report running SuiteCRM version 7.12.6

BenMore1320 · 19 September 2022 21:14

Trying to load a report into the Report Dashlet and nothing loads. Found the error below.

Any help would be appricated.

[Mon Sep 19 20:31:39.610428 2022] [proxy_fcgi:error] [pid 99270:tid 140059175831296] [client 10.40.10.129:50132] AH01071: Got error 'PHP message: PHP Warning: Undefined array key “parameter_value” in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php on line 142

PHP message: PHP Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php:142
Stack trace:
#0 /bitnami/suitecrm/include/MVC/Controller/SugarController.php(893): AORReportsDashlet->saveOptions()
#1 /bitnami/suitecrm/include/MVC/Controller/SugarController.php(522): SugarController->action_configuredashlet()
#2 /bitnami/suitecrm/include/MVC/Controller/SugarController.php(491): SugarController->do_action()
#3 /bitnami/suitecrm/include/MVC/Controller/SugarController.php(465): SugarController->handle_action()
#4 /bitnami/suitecrm/include/MVC/Controller/SugarController.php(361): SugarController->process()
#5 /bitnami/suitecrm/include/MVC/SugarApplication.php(101): SugarController->execute()
#6 /bitnami/suitecrm/index.php(52): SugarApplication->execute()
#7 {main}\n thrown in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php on line 142’, referer: http://10.10.39.1/index.php?module=Home&action=index

[Mon Sep 19 20:31:39.865035 2022] [proxy_fcgi:error] [pid 659:tid 140058816280320] [client 10.40.10.129:50133] AH01071: Got error ‘PHP message: PHP Warning: Attempt to read property “id” on null in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php on line 57’, referer: http://10.10.39.1/index.php?module=Home&action=index

[Mon Sep 19 20:31:44.318835 2022] [proxy_fcgi:error] [pid 99270:tid 140058648426240] [client 10.40.10.129:50134] AH01071: Got error ‘PHP message: PHP Warning: Attempt to read property “id” on null in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php on line 93PHP message: PHP Warning: Attempt to read property “name” on null in /bitnami/suitecrm/modules/AOR_Reports/Dashlets/AORReportsDashlet/AORReportsDashlet.php on line 94PHP message: PHP Warning: Undefined array key “LBL_DASHLET_SELECT_REPORT” in /bitnami/suitecrm/cache/smarty/templates_c/%%D7^D74^D74EEC47%%dashletConfigure.tpl.php on line 38PHP message: PHP Warning: Undefined array key “LBL_DASHLET_SELECT_REPORT” in /bitnami/suitecrm/cache/smarty/templates_c/%%D7^D74^D74EEC47%%dashletConfigure.tpl.php on line 39PHP message: PHP Warning: Undefined array key “LBL_DASHLET_CLEAR_REPORT” in /bitnami/suitecrm/cache/smarty/templates_c/%%D7^D74^D74EEC47%%dashletConfigure.tpl.php on line 57PHP message: PHP Warning: Undefined array key “LBL_DASHLET_CLEAR_REPORT” in /bitnami/suitecrm/cache/smarty/templates_c/%%D7^D74^D74EEC47%%dashletConfigure.tpl.php on line 59’, referer: http://10.10.39.1/index.php?module=Home&action=index

pgr · 20 September 2022 09:29

Check that your PHP version is within the Matrix:

BenMore1320 · 20 September 2022 17:07

Thanks for the suggestion but we are on version 8 of PHP which the matrix says is correct for SuiteCRM 7.12

pgr · 20 September 2022 17:11

Can you try this fix?

github.com/salesagility/SuiteCRM

Closing count bracket before relational operator PHP 8.0 count throwing TypeError

salesagility:master ← rahulshinde19:master

opened 03:16PM - 25 Aug 22 UTC

rahulshinde19

+1 -1

Corrected typo mistake  ## Description Count bracket is closed after relational operator it must be typo mistake done years ago before PHP 8.0 count() use to yield a warning but after PHP 8.0 count() will throw TypeError if countable types parameter is not passed, in this case Boolean value was feeding to count so it was throwing TypeError in PHP 8.0+ ## Motivation and Context This issue will throw TypeError in PHP 8.0 and may stop execution on all listing page ## How To Test This Use PHP 8.0 + version and search on any listing page with some conditions selected in dropdown in basic search Click on Campaigns -> View Email Template -> click on filter -> in Quick filter enter some name and select type as email -> click on search you will see following error ``` Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, bool given in C:\xampp80\htdocs\SuiteCRM-7.12.7\include\ListView\ListViewData.php:514 Stack trace: #0 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\ListView\ListViewDisplay.php(158): ListViewData->getListViewData(Object(EmailTemplate), '(email_template...', 0, 20, Array, Array, 'id', true, NULL) #1 C:\xampp80\htdocs\SuiteCRM-7.12.7\include\MVC\View\views\view.list.php(283): ListViewDisplay->setup(Object(EmailTemplate), 'include/ListVie...', '(email_template...', Array) #2 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\MVC\View\views\view.list.php(391): ViewList->listViewProcess() #3 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\MVC\View\SugarView.php(210): ViewList->display() #4 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\MVC\Controller\SugarController.php(432): SugarView->process() #5 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\MVC\Controller\SugarController.php(363): SugarController->processView() #6 C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\MVC\SugarApplication.php(101): SugarController->execute() #7 C:\xampp80\htdocs\SuiteCRM- 7.12.7\index.php(52): SugarApplication->execute() #8 {main} thrown in C:\xampp80\htdocs\SuiteCRM- 7.12.7\include\ListView\ListViewData.php on line 514 ``` ## Types of changes - [x] Bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds functionality) - [ ] Breaking change (fix or feature that would cause existing functionality to change) ### Final checklist - [x] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/). - [ ] My change requires a change to the documentation. - [x] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.

BenMore1320 · 20 September 2022 20:42

We made this change and the problem remains. Cannot load the report into the Dashlet. Thanks again for your suggestion.

pgr · 21 September 2022 15:01

Hhhm I don’t know, then.

Just a few random things to try:

delete the cached file /bitnami/suitecrm/cache/smarty/templates_c/%%D7^D74^D74EEC47%%dashletConfigure.tpl.php , it will get re-created and might come up different
in Admin / Repairs, run a repair dashlets action.
try commenting out continue as explained here.

aureh12 · 6 February 2023 17:07

Same here. PHP 8.0, Suitecrm 7.13.1

Homepage crashes if there are already Report Dashlets created.
If we reset the homepage it is impossible to add Report Dashlet.

Can’t go back to PHP 7.4, apache crashes for some unknown reasons.
It will be faster to solve this issue in the code.

Thanks

abuzarfaris · 7 February 2023 04:57

In the file \modules\AOR_Reports\Dashlets\AORReportsDashlet\AORReportsDashlet.php

from line 142 replace

         for ($i = 0; $i < count($req['parameter_value']); $i++) {
                if (isset($req['parameter_value'][$i]) && $req['parameter_value'][$i] != '') {
                    global $current_user, $timedate;
                    $user_date_format = $timedate->get_date_format($current_user);

                    if (DateTime::createFromFormat($user_date_format, $req['parameter_value'][$i]) !== false) {
                        $date = DateTime::createFromFormat($user_date_format, $req['parameter_value'][$i]);
                        $date->setTime(00, 00, 00);
                        $req['parameter_value'][$i] = $timedate->asDb($date);
                    }
                }
            }

with

if(!empty($req['parameter_value'])) {
            for ($i = 0; $i < count($req['parameter_value']); $i++) {
                if (isset($req['parameter_value'][$i]) && $req['parameter_value'][$i] != '') {
                    global $current_user, $timedate;
                    $user_date_format = $timedate->get_date_format($current_user);

                    if (DateTime::createFromFormat($user_date_format, $req['parameter_value'][$i]) !== false) {
                        $date = DateTime::createFromFormat($user_date_format, $req['parameter_value'][$i]);
                        $date->setTime(00, 00, 00);
                        $req['parameter_value'][$i] = $timedate->asDb($date);
                    }
                }
            }
        }

aureh12 · 7 February 2023 07:56

Thanks !! It is making progress.

Now we can add new Dashlets, but as soon as we save filters it crashes again with this now:

Fatal error: Uncaught Error: Non-static method SugarWidgetReportField::_get_column_select() cannot be called statically in /Data/websites/crm.asiaction.com/include/generic/SugarWidgets/SugarWidgetFieldname.php:229 Stack trace: #0 /Data/websites/crm.asiaction.com/include/Dashlets/DashletGeneric.php(365): SugarWidgetFieldName->queryFilterone_of() #1 /Data/websites/crm.asiaction.com/include/Dashlets/DashletGeneric.php(415): DashletGeneric->buildWhere() #2 /Data/websites/crm.asiaction.com/modules/Home/index.php(244): DashletGeneric->process() #3 /Data/websites/crm.asiaction.com/modules/Home/views/view.list.php(54): include('...') #4 /Data/websites/crm.asiaction.com/include/MVC/View/SugarView.php(210): HomeViewList->display() #5 /Data/websites/crm.asiaction.com/include/MVC/Controller/SugarController.php(432): SugarView->process() #6 /Data/websites/crm.asiaction.com/include/MVC/Controller/SugarController.php(363): SugarController->processView() #7 /Data/websites/crm.asiaction.com/include/MVC/SugarApplication.php(101): SugarController->execute() #8 /Data/websites/crm.asiaction.com/index.php(52): SugarApplication->execute() #9 {main} thrown in /Data/websites/crm.asiaction.com/include/generic/SugarWidgets/SugarWidgetFieldname.php on line 229

Can you help again ?

Thank you.

abuzarfaris · 7 February 2023 08:36

Go to this file
include/generic/SugarWidgets/SugarWidgetFieldname.php
search for
SugarWidgetFieldid::_get_column_select
and replace it with
$this->_get_column_select

aureh12 · 8 February 2023 13:58

Thanks. It is working.

MadMart · 16 August 2023 09:47

Can confirm this issue exists on 7.13.3
provided code fixes the issue

pgr · 16 August 2023 10:59

Is there an Issue and a a PR with this fix already on GitHub? If there is, someone please post a link here. I’d there isn’t, someone please open it

dcrp.orc · 18 August 2023 09:57

Hello,

I found the issue #9104 that it’s related to this case.

pgr · 29 September 2023 10:24

And this one actually has the same PHP error:

github.com/salesagility/SuiteCRM

Homepage dashboard doesn't load in PHP 8+ with My Open Tasks Dashlet set to display another user's open tasks

opened 03:38PM - 25 Sep 23 UTC

mattlt

Type:Bug Priority:Important Area: Dashlets Area: PHP8

#### Issue When I use the My Open Tasks Dashlet to set up a dashlet to see an…other user's open tasks the dashboard does not load in PHP 8+. #### Expected Behavior The dashboard should load as it does in previous PHP versions (7.4-). #### Actual Behavior Dashboard does not load, only showing a white screen in PHP 8+. Switching the PHP version back to PHP 7.4 allows the dashboard to load again. #### Possible Fix Hoping you don't say, "It's called the MY Open Tasks dashlet for a reason." #### Steps to Reproduce 1. Reset your user dashboard (homepage). 2. Add the My Open Tasks dashlet to your dashboard. 3. Edit the dashlet created above. 4. In the Filters section, uncheck Only My Items. 5. In the Filters - Assigned to: section, select any other user. 6. Hit the home button. 7. Dashboard now should display as a white screen. #### Context I usually have my dashboard as a bunch of dashlets, one for each user I'm managing, showing their open tasks. It works great to see where everyone is at in a more structured view than the Tasks listing page/view. #### Your Environment * SuiteCRM Version used: 7.13/7.14 * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Mac OS Safari Version 16.6 * Environment name and version (e.g. MySQL, PHP 7): PHP 7.4/PHP 8.1 * Operating System and version (e.g Ubuntu 16.04): Mac OS 13.6 Ventura

EDIT: although initially I had proposed the same solution that @abuzarfaris gave above, later I found out that there are more instances of the static call that need correction, and more importantly, that the correct fix is this:

github.com/salesagility/SuiteCRM

Fixed #10199 - PHP Fatal error: Uncaught Error: Non-static method Sug…

salesagility:hotfix ← TwizzX17:hotfix

opened 09:03AM - 29 Sep 23 UTC

TwizzX17

+6 -5

…arWidgetReportField::_get_column_select() PHP version 8 seems to have deprec…ated the non-static method calling. In this fix the class SugarWidgetFieldid is being instantiated and set as a property for reusability throughout the class.  ## Description Solving this issue: #10199 ## Motivation and Context ## How To Test This The bug occurs when having a widget on your dashboard (e.g. "My Top Open Opportunities : Options") and adding the following filter: disable "only my items" checkbox and add a "assigned To". This will cause the dashboard to crash. ## Types of changes - [x] Bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds functionality) - [ ] Breaking change (fix or feature that would cause existing functionality to change) ### Final checklist - [x] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/). - [ ] My change requires a change to the documentation. - [x] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.

Instead of using $this to call the method, a new object must be instantiated, because $this is not the correct class for the intended method, it’s another one.

cperrot · 22 October 2023 15:18

worked for me. thanks for that.

rsp · 14 December 2023 18:46

Using v7.13

I am getting a console error when I am trying to save or edit any dashlet on home screen.

How did you resolve this issue?

MySugar.js?v=6WY0eIRvQx-xSuYs2iwxMg:49 Uncaught ReferenceError: newTop is not defined
    at Object.fillInConfigureDiv (MySugar.js?v=6WY0eIRvQx-xSuYs2iwxMg:49:481)
    at Object.handleTransactionResponse (sugar_grp1_yui.js?v=6WY0eIRvQx-xSuYs2iwxMg:31:4422)
    at sugar_grp1_yui.js?v=6WY0eIRvQx-xSuYs2iwxMg:31:3935