@fdellwing opened this Issue on January 22nd 2019 Contributor
  Executing ALTER TABLE `matomo_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';... Done. [1 / 5]
  Executing CREATE TABLE `matomo_twofactor_recovery_code` (`idrecoverycode` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL, `recovery_code` VARCHAR(40) NOT NULL, PRIMARY KEY ( `idrecoverycode` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;... Done. [2 / 5]
  Executing Activating plugin "TwoFactorAuth"... Done. [3 / 5]
  Executing Deactivating plugin "GoogleAuthenticator"... Done. [4 / 5]
  Executing CREATE TABLE `matomo_tracking_failure` (`idsite` BIGINT(20) UNSIGNED NOT NULL, `idfailure` SMALLINT UNSIGNED NOT NULL, `date_first_occurred` DATETIME NOT NULL, `request_url` MEDIUMTEXT NOT NULL, PRIMARY KEY ( `idsite`, `idfailure` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;... Done. [5 / 5]
  Executing CREATE TABLE `matomo_brute_force_log` (`id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, PRIMARY KEY ( `id_brute_force_log` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;... Done. [6 / 5]
  Executing ALTER TABLE `matomo_brute_force_log` ADD INDEX index_ip_address (`ip_address`);... Done. [7 / 5]
@jamesstout commented on January 23rd 2019

did the auto update to 3.8.0 just now.

got this error:

Mysqli prepare error: Table 'piwik."matomo_brute_force_log'" doesn't exist
Had a look to check what changed. Seems a few tables and alters were missing. In fact loads were. My old version was 3.5.1... so all the update scripts in core/Upgrades don't seem to have run.

EDIT
Hold on: I see i need to run an upgrade step .. sorry

thanks

@fdellwing commented on January 23rd 2019 Contributor

Not related to this issue, but take a look at #13836 and #14001

This Issue was closed on February 10th 2019
Powered by GitHub Issue Mirror