From 0b306fa60ad84ea077111e0ff7b59208ba7bc8a3 Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Fri, 6 Apr 2018 10:54:58 -0700 Subject: Move documentation to https://docs.kanboard.org/ --- .../solving-database-migration-issues.markdown | 23 ---------------------- 1 file changed, 23 deletions(-) delete mode 100644 doc/en_US/solving-database-migration-issues.markdown (limited to 'doc/en_US/solving-database-migration-issues.markdown') 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/.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 -- cgit v1.2.3