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

planet_express · October 22, 2015, 1:39pm

Hello,

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?

matthieu · October 22, 2015, 8:34pm

Hello,

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

planet_express · October 23, 2015, 7:15am

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

oweiland · October 23, 2015, 4:52pm

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

matthieu · October 23, 2015, 5:23pm

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

planet_express · October 24, 2015, 8:09am