Error after installing the boxed version of Bitrix24?

Question

PHP

I installed the BITRIX24 box, started working with it, instead of some menus (tasks, profile) the following error appears
--

spoiler

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1525) Incorrect DATETIME value: '' (400)

        SEL ECT 
          COUNT(t.ID) as COUNT,
          GROUP_ID
        FR OM 
          b_tasks as t
          
        WHERE 
          (DEADLINE = '' OR DEADLINE IS NULL)
          AND RESPONSIBLE_ID = 1
          AND RESPONSIBLE_ID != CREATED_BY
          AND ZOMBIE = 'N'
          
          AND (
            STATUS != 4
            AND STATUS != 5
            AND	STATUS != 6
          )
        GROUP BY 
          GROUP_ID
      
/ssd1/bitrix/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal
  /ssd1/bitrix/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query
  /ssd1/bitrix/bitrix/modules/tasks/lib/internals/counter.php:1406
#2: Bitrix\Tasks\Internals\Counter->calcMyWithoutDeadline
  /ssd1/bitrix/bitrix/modules/tasks/lib/internals/counter.php:121
#3: Bitrix\Tasks\Internals\Counter->processRecalculate
  /ssd1/bitrix/bitrix/modules/tasks/lib/internals/counter.php:106
#4: Bitrix\Tasks\Internals\Counter->recountAllCounters
  /ssd1/bitrix/bitrix/modules/tasks/lib/internals/counter.php:38
#5: Bitrix\Tasks\Internals\Counter->__construct
  /ssd1/bitrix/bitrix/modules/tasks/lib/internals/counter.php:534
#6: Bitrix\Tasks\Internals\Counter::getInstance
  /ssd1/bitrix/bitrix/components/bitrix/tasks.interface.topmenu/class.php:159
#7: TasksTopmenuComponent->getCounter
  /ssd1/bitrix/bitrix/components/bitrix/tasks.interface.topmenu/class.php:135
#8: TasksTopmenuComponent->getRoles
  /ssd1/bitrix/bitrix/components/bitrix/tasks.interface.topmenu/class.php:121
#9: TasksTopmenuComponent->doPreAction
  /ssd1/bitrix/bitrix/components/bitrix/tasks.base/class.php:79
#10: TasksBaseComponent->executeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:648
#11: CBitrixComponent->includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/main.php:1039
#12: CAllMain->IncludeComponent
  /ssd1/bitrix/bitrix/components/bitrix/tasks.interface.header/templates/.default/template.php:46
#13: include(string)
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:725
#14: CBitrixComponentTemplate->__IncludePHPTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:820
#15: CBitrixComponentTemplate->IncludeTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:745
#16: CBitrixComponent->showComponentTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:693
#17: CBitrixComponent->includeComponentTemplate
  /ssd1/bitrix/bitrix/components/bitrix/tasks.base/class.php:358
#18: TasksBaseComponent->display
  /ssd1/bitrix/bitrix/components/bitrix/tasks.base/class.php:115
#19: TasksBaseComponent->executeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:648
#20: CBitrixComponent->includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/main.php:1039
#21: CAllMain->IncludeComponent
  /ssd1/bitrix/bitrix/components/bitrix/tasks.task.list/templates/.default/template.php:89
#22: include(string)
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:725
#23: CBitrixComponentTemplate->__IncludePHPTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:820
#24: CBitrixComponentTemplate->IncludeTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:745
#25: CBitrixComponent->showComponentTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:693
#26: CBitrixComponent->includeComponentTemplate
  /ssd1/bitrix/bitrix/components/bitrix/tasks.task.list/class.php:977
#27: TasksTaskListComponent->display
  /ssd1/bitrix/bitrix/components/bitrix/tasks.base/class.php:115
#28: TasksBaseComponent->executeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:648
#29: CBitrixComponent->includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/main.php:1039
#30: CAllMain->IncludeComponent
  /ssd1/bitrix/bitrix/components/bitrix/ui.sidepanel.wrapper/templates/.default/content.php:23
#31: include(string)
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:725
#32: CBitrixComponentTemplate->__IncludePHPTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:820
#33: CBitrixComponentTemplate->IncludeTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:745
#34: CBitrixComponent->showComponentTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:693
#35: CBitrixComponent->includeComponentTemplate
  /ssd1/bitrix/bitrix/components/bitrix/ui.sidepanel.wrapper/class.php:140
#36: UIPageSliderWrapperComponent->executeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:648
#37: CBitrixComponent->includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/main.php:1039
#38: CAllMain->IncludeComponent
  /ssd1/bitrix/bitrix/components/bitrix/socialnetwork_user/templates/.default/user_tasks.php:108
#39: include(string)
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:725
#40: CBitrixComponentTemplate->__IncludePHPTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component_template.php:820
#41: CBitrixComponentTemplate->IncludeTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:745
#42: CBitrixComponent->showComponentTemplate
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:693
#43: CBitrixComponent->includeComponentTemplate
  /ssd1/bitrix/bitrix/components/bitrix/socialnetwork_user/component.php:1420
#44: include(string)
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:604
#45: CBitrixComponent->__includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/component.php:663
#46: CBitrixComponent->includeComponent
  /ssd1/bitrix/bitrix/modules/main/classes/general/main.php:1039
#47: CAllMain->IncludeComponent
  /ssd1/bitrix/company/personal.php:246
#48: include_once(string)
  /ssd1/bitrix/bitrix/modules/main/include/urlrewrite.php:159
#49: include_once(string)
  /ssd1/bitrix/404.php:2

Server time required

Local time: Fri 2020-07-31 19:09:15 MSK
              Universal time: Fri 2020-07-31 16:09:15 UTC
              RTC time: Fri 2020-07-31 16:09:15
              Time zone: Europe/Moscow (MSK, +0300)
              System clock synchronized: yes
              NTP service: active
              RTC in local TZ: no

after_connect.php

<?
$DB->Query("SET NAMES 'utf8'");
$DB->Query("SET sql_mode=''");
$DB->Query('SET collation_connection = "utf8_unicode_ci"');
?>

System and software
ubuntu 20.04
php7.4
mysql
apache2
-

Answer 1

Remove PHP modules timezonedb and snmp