Error after latest update: 1231 Variable 'sql_mode' can't be set to the value of 'NO_ZERO_IN_DATE'


I run Piwik since 2008 and today I got the first error after the auto-update to the latest version (released today):

An error occurred

Cannot connect to the database:

SQLSTATE[42000]: Syntax error or access violation: 1231 Variable ‘sql_mode’ can’t be set to the value of ‘NO_ZERO_IN_DATE’

This may be a temporary issue, try refreshing the page. If the problem persists please contact your Piwik administrator.

Can you help me? :frowning:


What mysql version are you using? maybe it’s possible to try upgrade to a newer one?

Otherwise we can fix the issue by removing piwik/Db.php at 2.15.0 · matomo-org/piwik · GitHub

MySQL Version is 4.1.22.
Would it be better to upgrade or to remove

Same issue with php 5.6.8 and 5.6.12
Tried manual update with same outcome

Please could you create an issue on: Issues · matomo-org/piwik · GitHub

Done: Piwik compatible with old Mysql 4.1 (cannot connect to DB since 2.15.0) · Issue #9088 · matomo-org/piwik · GitHub