diff options
author | Frédéric Guillot <fred@kanboard.net> | 2018-04-06 10:54:58 -0700 |
---|---|---|
committer | Frédéric Guillot <fred@kanboard.net> | 2018-04-06 10:54:58 -0700 |
commit | 0b306fa60ad84ea077111e0ff7b59208ba7bc8a3 (patch) | |
tree | 5d8941b5950ede2db8ca3fba0213792db0f07a50 /doc/en_US/solving-database-migration-issues.markdown | |
parent | ac11220a1aa7ae30b8827d9bbf221888d3edd0a7 (diff) |
Move documentation to https://docs.kanboard.org/
Diffstat (limited to 'doc/en_US/solving-database-migration-issues.markdown')
-rw-r--r-- | doc/en_US/solving-database-migration-issues.markdown | 23 |
1 files changed, 0 insertions, 23 deletions
diff --git a/doc/en_US/solving-database-migration-issues.markdown b/doc/en_US/solving-database-migration-issues.markdown deleted file mode 100644 index ddd39db6..00000000 --- a/doc/en_US/solving-database-migration-issues.markdown +++ /dev/null @@ -1,23 +0,0 @@ -Solving Database Migration Issues -================================= - -- SQL migrations are executed automatically when you upgrade Kanboard to a new version -- For Postgres and Mysql, the current schema version number is stored in the table `schema_version` and for Sqlite this is stored in the variable `user_version -- Migrations are defined in the file `app/Schema/<DatabaseType>.php` -- Each function is a migration -- Each migration is executed in a transaction -- If migration generate an error, a rollback is performed - -When upgrading: - -- Always backup your data -- Do not run migrations in parallel from multiple processes - -If you got the error "Unable to run SQL migrations [...]", here are the steps to fix it manually: - -1. Open the file corresponding to your database `app/Schema/Sqlite.php` or `app/Schema/Mysql.php` -2. Go to the failed migration function -3. Execute manually the SQL queries defined in the function -4. If you encounter an error, report the issue to the bug tracker with the exact SQL error -5. When all SQL statements of the migration are executed, update the schema version number -6. Run other migrations |