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.

Did work for me, thanks! 👍

Hi,

I will just add fix fox docker/sqlite users.

On host running docker find db/wallabag.sqlite and run

 sudo sqlite3 wallabag.sqlite

and run

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 sh to wallabag container:

docker exec -it wallabag sh

Then

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

And your are done :)

$ 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