Fix for wallabag 2.2 and SQLite

fix.md

After upgrading wallabag to 2.2, if you use SQLite for database, you may have a blank page or an internal server error (error 500). It can be due to migrations which failed.

The migrations who failed are migrations which try to create new columns on tables.

To fix this problem, please execute these commands on your webserver:

    php bin/console doctrine:migration:execute 20161024212538 -e=prod
    php bin/console doctrine:migration:execute 20161106113822 -e=prod
    php bin/console doctrine:migration:execute 20161118134328 -e=prod
    php bin/console doctrine:migration:execute 20161128084725 -e=prod
    php bin/console doctrine:migration:execute 20161214094402 -e=prod

If for some commands, you have this error:

    ++ migrating 20161118134328
    -> ALTER TABLE wallabag_entry ADD COLUMN http_status VARCHAR(3) DEFAULT NULL
    Migration 20161118134328 failed during Post-Checks. Error An exception occurred while executing 'INSERT INTO migration_versions (version) VALUES (?)' with params ["20161118134328"]:
    SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: migration_versions.version

Please open your database like this (or with a tool like DB Browser for SQLite)

    sqlite3 data/db/wallabag.sqlite

Then, execute the query corresponding to the migration which failed:

delete from migration_versions where version = "20161024212538";
delete from migration_versions where version = "20161106113822";
delete from migration_versions where version = "20161118134328";
delete from migration_versions where version = "20161128084725";
delete from migration_versions where version = "20161214094402";

Then, re-execute the command which failed.

$ docker-compose exec wallabag sh
# find /var/www/wallabag/app/DoctrineMigrations/ | sort | grep Version | sed 's/.*Version//; s/.php//' | xargs -I {} php /var/www/wallabag/bin/console --no-interaction doctrine:migration:execute {}  -e=prod

$ sudo sqlite3 wallabag.sqlite
sqlite> delete from migration_versions;

$ docker-compose exec poche sh
# find /var/www/wallabag/app/DoctrineMigrations/ | sort | grep Version | sed 's/.*Version//; s/.php//' | xargs -I {} php /var/www/wallabag/bin/console --no-interaction doctrine:migration:execute {}  -e=prod