Ошибка после установки коробочной версии Битрикс24?

Question

[V A]

Установил коробку БИТРИКС24, начал работать с ней, вместо некоторых меню (задачи, профиль) появляется такая ошибка
--

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

Время сервера нужное

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"');
?>

Система и софт
ubuntu 20.04
php7.4
mysql
apache2
-

Comments

[Виктор Таран]

говорят вот
www.geeksengine.com/article/populate-time-zone-dat...

Answer 1

[Sanes]

Удалите модули PHP timezonedb и snmp

Comments

[V A]

Спасибо, а как их удалить? в php.ini отключить? или как

[Sanes]

V A, от версии php зависит. Попробуйте apt purge php-timezonedb php-snmp

[Sanes]

Вместо mysql-server лучше ставить mariadb-server. Ansible по крайней мере как-то неадекватно с mysql-8 работал.

[V A]

Sanes,

php-timezonedb - E: Unable to locate package php-timezonedb
php-snmp - is not installed,