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:

(Matthieu Aubry) #2


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

(Matthieu Aubry) #5

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