Hallo Zusammen,
Ich habe versucht unsere Matomo-Version von 3.5.1 auf 4.2.0 anzuheben.
Leider klappt etwas beim Update der Datenbank nicht und hält mich davon ab das Update abzuschließen.
Anbei der Fehler:
Fehler während Plugin-Aktualisierungen:
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
/var/www/matomo/core/Columns/Updater.php: Error trying to execute the migration ‘ALTER TABLE piwik_log_visit
MODIFY COLUMN visitor_count_visits
INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN visit_total_interactions
MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN referer_name
VARCHAR(255) NULL, MODIFY COLUMN referer_url
VARCHAR(1500) NULL, MODIFY COLUMN config_browser_name
VARCHAR(40) NULL, ADD COLUMN config_client_type
TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL, MODIFY COLUMN location_region
char(3) DEFAULT NULL;’. The error was: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘location_region’ in 'piwik_log_visit’
Könnt ihr mir da weiterhelfen? Muss ich erst auf eine Zwischenversion updaten oder wie kann ich diesen Fehler beheben.
Vielen Dank und viele Grüße
Kenny