Error during authorization in Bitrix. MySQL Query Error. How to fix?

Question

MySQL

Friends, I need help to solve this problem. When transferring a Bitrix site to your server (Lunix, ubuntu, debian), an error occurs when entering the admin panel. The site itself works, but when you enter the adinka, this error occurs, then the entire site does not work until the authorized session ends. Then the site works and until again there is no authorization in the admin panel. I'm afraid the problem is no longer childish. Cleaned the sql table with the TRUNCATE TABLE b_event_log query - does not help. I restored the repair table b_event_log table - it didn't help either.

Code and screenshot of the error:

MySQL Query Error: SELECT COUNT(ID) AS COUNT FROM b_event_log WHERE AUDIT_TYPE_ID in ('SECURITY_FILTER_SQL', 'SECURITY_FILTER_XSS', 'SECURITY_FILTER_XSS2', 'SECURITY_FILTER_PHP') AND (MODULE_ID = 'security' and MODULE_ID is not null) AND TIMESTAMP_X >= '' [[1525] Incorrect TIMESTAMP value: '']

Answer 1

The problem really was timing.
I solved the problem by changing the cell type TIMESTAMP_X from TIMESTAMP to VARCHAR

Answer 2

Who will read?

Incorrect TIMESTAMP value

Problems with the transfer of time. Next, we go to Google and find something similar: Incorrect datetime value: '0000-00-00 00:00:00'. How to fix?