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.

Sign up for GitHub

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

Jump to bottom

a new System check for "MySQL schema and columns" #11540

Open
mattab opened this issue Mar 27, 2017 · 1 comment
Open

a new System check for "MySQL schema and columns" #11540

mattab opened this issue Mar 27, 2017 · 1 comment
Labels
Easier debugging For issues that make troubleshooting issues for developers easier. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
Backlog (Help wan...

Comments

@mattab
Copy link
Member

mattab commented Mar 27, 2017

Sometimes some of the schema updates fail or are missing. We get many bug reports caused by this problem where some schema upgrades were not executed properly for various reasons (incomplete file uploads causing some schema to be missed on upgrade, upgrades timing out, users who manually change types in the DB, etc.)

It would be really useful and awesome to have a new System check that would report a problem whenever:

  • A column is missing
  • An additional is found in DB
  • A column type is different from expected
  • A whole table is missing
  • An index is missing
@mattab mattab added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Mar 27, 2017
@mattab mattab added this to the Backlog (Help wanted) milestone Mar 27, 2017
@mattab
Copy link
Member Author

mattab commented Mar 27, 2017

Not easily do-able

  • Plugins may alter columns and types without defining proper columns
  • we would have to install Piwik in another DB silently and compare schemas. Not easy at all

@Findus23 Findus23 mentioned this issue Feb 11, 2021
Closed
@tsteur tsteur added Easier debugging For issues that make troubleshooting issues for developers easier. and removed Easier debugging For issues that make troubleshooting issues for developers easier. labels Feb 14, 2021
@Findus23 Findus23 mentioned this issue Mar 22, 2021
Closed
@mattab mattab added the Easier debugging For issues that make troubleshooting issues for developers easier. label Dec 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Easier debugging For issues that make troubleshooting issues for developers easier. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Milestone
Backlog (Help wanted)
Development

No branches or pull requests
2 participants
@tsteur @mattab