Skip to content

Instantly share code, notes, and snippets.

@gwire
Created April 13, 2021 20:33
Show Gist options
  • Save gwire/456e1e3f464aa558b3f7744c235873ec to your computer and use it in GitHub Desktop.
Save gwire/456e1e3f464aa558b3f7744c235873ec to your computer and use it in GitHub Desktop.
Fix Matomo issue "doesn't have a default value"
# An upgrade of MariaDB broke our matomo installation
# Error in Matomo (tracker): Error query: SQLSTATE[HY000]: General error:
# 1364 Field 'visit_total_events' doesn't have a default value In query: INSERT INTO piwik_log_visit ...
#
# See https://github.com/matomo-org/matomo/issues/14799
ALTER TABLE piwik_log_visit MODIFY COLUMN visit_total_events SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE piwik_log_visit MODIFY COLUMN config_os CHAR(3) NULL;
ALTER TABLE piwik_log_visit MODIFY COLUMN config_browser_name VARCHAR(10) NULL;
ALTER TABLE piwik_log_visit MODIFY COLUMN config_browser_version VARCHAR(20) NULL;
ALTER TABLE piwik_log_visit MODIFY COLUMN config_browser_engine VARCHAR(10) NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment