@mattab opened this Issue on March 27th 2017 Member

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 commented on March 27th 2017 Member

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
Powered by GitHub Issue Mirror