Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Number of database upgrades off #13992

Closed
fdellwing opened this issue Jan 22, 2019 · 2 comments
Closed

Number of database upgrades off #13992

fdellwing opened this issue Jan 22, 2019 · 2 comments
Assignees
Milestone

Comments

@fdellwing
Copy link
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
Copy link

jamesstout commented Jan 23, 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
Copy link
Contributor Author

fdellwing commented Jan 23, 2019

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

@diosmosis diosmosis modified the milestones: 3.8.1, 3.9.0 Jan 27, 2019
@mattab mattab added not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. and removed not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. labels Mar 18, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants