Upgrade Notes

This page shows common issues for upgrading between released. Commonly the only things you need to know about are schema files to be executed.

About Upgrading

If you have recently upgraded, you will need to follow the following instructions. If you are upgrading from one further down the list to one at the top of the list then you need to execute all of the changes in between - or if the changes pertain to SQL file imports and you do not see the "alter commands" file being referenced then you will need to export your current data, create a new schema with the new main schema file and then import your data to the new schema. This is a simple process: please contact support if you need help with that process.

Release Notes

For any command that involves executing a SQL file. Please use this command: "shell> mysql --user=username -p kontrollbase_schema_name < sql_file.sql"

Any revision between 288 and above (as of 292)

Revision 288

  • You will need to execute the following schema change file: $directory_of_installation/install/sql/schema_alter_commands-REV288.sql

Revision 271

  • If upgrading from 270 you do not need to follow these changes.
  • You will need to execute the following schema change file: $directory_of_installation/install/sql/kontrollbase-schema-SECONDARY_SCHEMA_LOAD_THIS_TOO.sql

Revision 270

  • You will need to execute the following schema change file: $directory_of_installation/install/sql/kontrollbase-schema-SECONDARY_SCHEMA_LOAD_THIS_TOO.sql
  • You will need to execute the following schema change: $directory_of_installation/install/sql/kontrollbase-schema-analytics_table_commands-rev249_250.sql

Revision 271

  • You will need to execute the following schema change file: $directory_of_installation/install/sql/kontrollbase-schema-analytics_table_commands-rev249_250.sql