I was able to view the sla report page with another user. I remember that with my user, in version 6.0.1, I had done a search with the date 2022/03/10 16:40 (something like that), because in the correct format there was no result. I even made this update to version 6.0.2 because I saw that the datetime picker had been fixed. But now I can't load the page with my user, even after clearing the browser cache. Should I clear apache cache with htcacheclean ?

Hello, Cesar!

Could you, please, try clearing web browser cookies and cache?

• Here is a guide for main browsers: https://www.fvsu.edu/how-to-clear-your-browser-cache/
• Here is a mention of a possibility of problems in the web frontend after upgrading the Zabbix and not clearing browser cache: https://www.zabbix.com/documentation/6.0/en/manual/installation/upgrade/packages/debian_ubuntu?hl=Clear%2Cweb%2Cbrowser%2Ccookies%2Cand%2Ccache%2Cclear#clear-web-browser-cookies-and-cache

Regards,

Antons

I cleared cache and cookies, and even reinstalled Google Chrome, and the error remains.

I cleared cache and cookies, and even reinstalled Google Chrome, and the error remains.

Thank you for the update!

I was able to view the sla report page with another user

• And this section which previously was accessible by your user is not accessible by it anymore?
• Is there any error message shown in the browser or just a blank page?
• One more thing, could you, please, enable "debug mode" (https://www.zabbix.com/documentation/current/en/manual/web_interface/debug_mode) for both users and attach the debug log output for both as well.

• And this section which previously was accessible by your user is not accessible by it anymore?

With another user, who never tried to filter the report with the wrong date format, but it worked in version 6.0.1, it is possible to view the page today normally.

• Is there any error message shown in the browser or just a blank page?

Just 'HTTP ERROR 500', but, But, as I already informed, in the apache log it appears:

PHP Fatal error: Uncaught Error: Call to a member function getTimestamp() on null in /var/www/html/zabbix/app/controllers/CControllerSlaReportList.php:164\nStack trace:\n#0 /var/www/html/zabbix/include/classes/mvc/CController.php(465): CControllerSlaReportList->doAction()\n#1 /var/www/html/zabbix/include/classes/core/ZBase.php(526): CController->run()\n#2 /var/www/html/zabbix/include/classes/core/ZBase.php(210): ZBase->processRequest()\n#3 /var/www/html/zabbix/include/config.inc.php(25): ZBase->run()\n#4 /var/www/html/zabbix/zabbix.php(22): require_once('/var/www/html/z...')\n#5
{main}
\n thrown in /var/www/html/zabbix/app/controllers/CControllerSlaReportList.php on line 164, referer: https://zbx.unipam.edu.br/zabbix.php?action=dashboard.view

• One more thing, could you, please, enable "debug mode" (https://www.zabbix.com/documentation/current/en/manual/web_interface/debug_mode) for both users and attach the debug log output for both as well.

In my user, there is no point in enabling it, because the error 500 is already generated, and the white page

Ok, it seems that one of the probabilities is that an incorrect date filter setting has been saved for your user and now it prevents the SLA report section from proper functioning.

Could you, please, run the following SQL query and share its output:

select * from profiles where idx LIKE "%slareport%" AND userid=(SELECT userid FROM users WHERE username='<username>');

replace the "<username>" with your user name (mind the case sensitivity). This will show what filter settings are saved for your user in the "profiles" table regarding "SLA report" section.

Attached is the output:

Should I update these records?

Let us try resetting the "value_str" values for "idx" entries "web.slareport.list.filter.date_from" and "web.slareport.list.filter.date_to" which supposedly have incorrect date format values:

 UPDATE profiles SET value_str="" WHERE idx="web.slareport.list.filter.date_from" AND userid=(SELECT userid FROM users WHERE username='<username>');
 UPDATE profiles SET value_str="" WHERE idx="web.slareport.list.filter.date_to" AND userid=(SELECT userid FROM users WHERE username='<username>');

replace the "<username>" with your user name (mind the case sensitivity). Try accessing the "SLA report" section.

The update in the database table profiles solved my problem. Thank you for the support!

We are always glad to help!