summaryrefslogtreecommitdiff
path: root/doc/en_US/solving-database-migration-issues.markdown
diff options
context:
space:
mode:
authorFrédéric Guillot <fred@kanboard.net>2018-04-06 10:54:58 -0700
committerFrédéric Guillot <fred@kanboard.net>2018-04-06 10:54:58 -0700
commit0b306fa60ad84ea077111e0ff7b59208ba7bc8a3 (patch)
tree5d8941b5950ede2db8ca3fba0213792db0f07a50 /doc/en_US/solving-database-migration-issues.markdown
parentac11220a1aa7ae30b8827d9bbf221888d3edd0a7 (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.markdown23
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