wallabag: Error setting up database on fresh install
⚠️ If your issue is about an error during fetching a link, please read: http://doc.wallabag.org/en/user/errors_during_fetching.html#how-can-i-help-to-fix-that
Issue details
Please provide issue details here. Remember, this is not a place to ask questions. For that, go to https://community.wallabag.org/ (forum) or http://gitter.im/wallabag/wallabag (chat).
Environment
- wallabag version (or git revision) that exhibits the issue: 2.3.3
- How did you install wallabag? Via
git cloneor by downloading the package? https://aur.archlinux.org/packages/wallabag/ - Last wallabag version that did not exhibit the issue (if applicable): FRESH INSTALL
- php version: 7.2.11
- OS: ArchLinux ARM
- type of hosting (shared or dedicated): dedicated (home server)
- which storage system you choose at install (SQLite, MySQL/MariaDB or PostgreSQL): PostgreSQL
Steps to reproduce/test case
Please provide necessary steps for reproduction of this issue, or better the reduced test case (without any external dependencies, if possible).
- Install wallabag from AUR using any aur helper (e.g. pikaur -S wallabag)
- Configure parameters.yml
# This file is auto-generated during the composer install
parameters:
database_driver: pdo_pgsql
database_driver_class: Wallabag\CoreBundle\Doctrine\DBAL\Driver\CustomPostgreSQLDriver
database_host: 127.0.0.1
database_port: null
database_name: wallabag
database_user: wb
database_password: null
database_path: null
database_table_prefix: wallabag_
database_socket: null
database_charset: utf8
domain_name: 'https://wallabag.server.lan'
mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: null
mailer_password: null
locale: en
secret: <REDACTED>
twofactor_auth: false
twofactor_sender: no-reply@wallabag.org
fosuser_registration: true
fosuser_confirmation: true
from_email: no-reply@wallabag.org
rss_limit: 50
rabbitmq_host: localhost
rabbitmq_port: 5672
rabbitmq_user: guest
rabbitmq_password: guest
rabbitmq_prefetch_count: 10
redis_scheme: unix
redis_host: localhost
redis_port: null
redis_path: null
redis_password: null
- Run this command as web user
php /usr/share/webapps/wallabag/bin/console wallabag:install --env=prod
I get this error during step 2.
Error log
Step 2 of 4: Setting up database.
---------------------------------
It appears that your database already exists. Would you like to reset it? (yes/no) [no]:
> yes
Dropping database, creating database and schema...
[RuntimeException]
The command "doctrine:migrations:migrate" generates some errors:
Application Migrations
Migrating up to 20171125164500 from 0
++ migrating 20160401000000
-> CREATE TABLE "wallabag_craue_config_setting" (name VARCHAR(255) NOT NULL, value VARCHAR(255) DEFAULT NULL, section VARCHAR(255) DEFAULT N
ULL, PRIMARY KEY(name));
-> CREATE UNIQUE INDEX UNIQ_5D9649505E237E06 ON "wallabag_craue_config_setting" (name);
-> CREATE TABLE "wallabag_entry" (id INT NOT NULL, user_id INT DEFAULT NULL, title TEXT DEFAULT NULL, url TEXT DEFAULT NULL, is_archived BOO
LEAN NOT NULL, is_starred BOOLEAN NOT NULL, content TEXT DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0
) WITHOUT TIME ZONE NOT NULL, mimetype TEXT DEFAULT NULL, language TEXT DEFAULT NULL, reading_time INT DEFAULT NULL, domain_name TEXT DEFAULT NUL
L, preview_picture TEXT DEFAULT NULL, is_public BOOLEAN DEFAULT 'false', PRIMARY KEY(id));
-> CREATE INDEX IDX_F4D18282A76ED395 ON "wallabag_entry" (user_id);
-> CREATE TABLE "wallabag_entry_tag" (entry_id INT NOT NULL, tag_id INT NOT NULL, PRIMARY KEY(entry_id, tag_id));
-> CREATE INDEX IDX_C9F0DD7CBA364942 ON "wallabag_entry_tag" (entry_id);
-> CREATE INDEX IDX_C9F0DD7CBAD26311 ON "wallabag_entry_tag" (tag_id);
-> CREATE TABLE "wallabag_config" (id INT NOT NULL, user_id INT DEFAULT NULL, theme VARCHAR(255) NOT NULL, items_per_page INT NOT NULL, lang
uage VARCHAR(255) NOT NULL, rss_token VARCHAR(255) DEFAULT NULL, rss_limit INT DEFAULT NULL, reading_speed DOUBLE PRECISION DEFAULT NULL, PRIMARY
KEY(id));
-> CREATE UNIQUE INDEX UNIQ_87E64C53A76ED395 ON "wallabag_config" (user_id);
-> CREATE TABLE "wallabag_tagging_rule" (id INT NOT NULL, config_id INT DEFAULT NULL, rule VARCHAR(255) NOT NULL, tags TEXT NOT NULL, PRIMAR
Y KEY(id));
-> CREATE INDEX IDX_2D9B3C5424DB0683 ON "wallabag_tagging_rule" (config_id);
-> COMMENT ON COLUMN "wallabag_tagging_rule".tags IS '(DC2Type:simple_array)';
-> CREATE TABLE "wallabag_tag" (id INT NOT NULL, label TEXT NOT NULL, slug VARCHAR(128) NOT NULL, PRIMARY KEY(id));
-> CREATE UNIQUE INDEX UNIQ_4CA58A8C989D9B62 ON "wallabag_tag" (slug);
-> CREATE TABLE "wallabag_oauth2_clients" (id INT NOT NULL, random_id VARCHAR(255) NOT NULL, redirect_uris TEXT NOT NULL, secret VARCHAR(255
) NOT NULL, allowed_grant_types TEXT NOT NULL, PRIMARY KEY(id));
-> COMMENT ON COLUMN "wallabag_oauth2_clients".redirect_uris IS '(DC2Type:array)';
-> COMMENT ON COLUMN "wallabag_oauth2_clients".allowed_grant_types IS '(DC2Type:array)';
-> CREATE TABLE "wallabag_oauth2_access_tokens" (id INT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT N
ULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id));
-> CREATE UNIQUE INDEX UNIQ_368A42095F37A13B ON "wallabag_oauth2_access_tokens" (token);
-> CREATE INDEX IDX_368A420919EB6921 ON "wallabag_oauth2_access_tokens" (client_id);
-> CREATE INDEX IDX_368A4209A76ED395 ON "wallabag_oauth2_access_tokens" (user_id);
-> CREATE TABLE "wallabag_oauth2_refresh_tokens" (id INT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT
NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id));
-> CREATE UNIQUE INDEX UNIQ_20C9FB245F37A13B ON "wallabag_oauth2_refresh_tokens" (token);
-> CREATE INDEX IDX_20C9FB2419EB6921 ON "wallabag_oauth2_refresh_tokens" (client_id);
-> CREATE INDEX IDX_20C9FB24A76ED395 ON "wallabag_oauth2_refresh_tokens" (user_id);
-> CREATE TABLE "wallabag_oauth2_auth_codes" (id INT NOT NULL, client_id INT NOT NULL, user_id INT DEFAULT NULL, token VARCHAR(255) NOT NULL
, redirect_uri TEXT NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id));
-> CREATE UNIQUE INDEX UNIQ_EE52E3FA5F37A13B ON "wallabag_oauth2_auth_codes" (token);
-> CREATE INDEX IDX_EE52E3FA19EB6921 ON "wallabag_oauth2_auth_codes" (client_id);
-> CREATE INDEX IDX_EE52E3FAA76ED395 ON "wallabag_oauth2_auth_codes" (user_id);
-> CREATE TABLE "wallabag_user" (id INT NOT NULL, username VARCHAR(180) NOT NULL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(18
0) NOT NULL, email_canonical VARCHAR(180) NOT NULL, enabled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_lo
gin TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, locked BOOLEAN NOT NULL, expired BOOLEAN NOT NULL, expires_at TIMESTAMP(0) WITHOUT TIME ZONE DEF
AULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, password_requested_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, roles TEXT NOT NULL,
credentials_expired BOOLEAN NOT NULL, credentials_expire_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, name TEXT DEFAULT NULL, created_at TIMES
TAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, authCode INT DEFAULT NULL, twoFactorAuthentication BOOLEA
N NOT NULL, trusted TEXT DEFAULT NULL, PRIMARY KEY(id));
-> CREATE UNIQUE INDEX UNIQ_1D63E7E592FC23A8 ON "wallabag_user" (username_canonical);
-> CREATE UNIQUE INDEX UNIQ_1D63E7E5A0D96FBF ON "wallabag_user" (email_canonical);
-> CREATE UNIQUE INDEX UNIQ_1D63E7E5C05FB297 ON "wallabag_user" (confirmation_token);
-> COMMENT ON COLUMN "wallabag_user".roles IS '(DC2Type:array)';
-> COMMENT ON COLUMN "wallabag_user".trusted IS '(DC2Type:json_array)';
-> CREATE TABLE "wallabag_annotation" (id INT NOT NULL, user_id INT DEFAULT NULL, entry_id INT DEFAULT NULL, text TEXT NOT NULL, created_at
TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, quote VARCHAR(255) NOT NULL, ranges TEXT NOT NULL, P
RIMARY KEY(id));
-> CREATE INDEX IDX_A7AED006A76ED395 ON "wallabag_annotation" (user_id);
-> CREATE INDEX IDX_A7AED006BA364942 ON "wallabag_annotation" (entry_id);
-> COMMENT ON COLUMN "wallabag_annotation".ranges IS '(DC2Type:array)';
-> CREATE SEQUENCE "entry_id_seq" INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE "config_id_seq" INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE "tagging_rule_id_seq" INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE "tag_id_seq" INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE oauth2_clients_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE oauth2_access_tokens_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE oauth2_refresh_tokens_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE oauth2_auth_codes_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE "user_id_seq" INCREMENT BY 1 MINVALUE 1 START 1;
-> CREATE SEQUENCE annotation_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
-> ALTER TABLE "wallabag_entry" ADD CONSTRAINT FK_F4D18282A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE INIT
IALLY IMMEDIATE;
-> ALTER TABLE "wallabag_entry_tag" ADD CONSTRAINT FK_C9F0DD7CBA364942 FOREIGN KEY (entry_id) REFERENCES "wallabag_entry" (id) NOT DEFERRABL
E INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_entry_tag" ADD CONSTRAINT FK_C9F0DD7CBAD26311 FOREIGN KEY (tag_id) REFERENCES "wallabag_tag" (id) NOT DEFERRABLE IN
ITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_config" ADD CONSTRAINT FK_87E64C53A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE INI
TIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_tagging_rule" ADD CONSTRAINT FK_2D9B3C5424DB0683 FOREIGN KEY (config_id) REFERENCES "wallabag_config" (id) NOT DEFE
RRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A420919EB6921 FOREIGN KEY (client_id) REFERENCES "wallabag_oauth2_client
s" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A4209A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT
DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_refresh_tokens" ADD CONSTRAINT FK_20C9FB2419EB6921 FOREIGN KEY (client_id) REFERENCES "wallabag_oauth2_clien
ts" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_refresh_tokens" ADD CONSTRAINT FK_20C9FB24A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT
DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_auth_codes" ADD CONSTRAINT FK_EE52E3FA19EB6921 FOREIGN KEY (client_id) REFERENCES "wallabag_oauth2_clients"
(id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_auth_codes" ADD CONSTRAINT FK_EE52E3FAA76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEF
ERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_annotation" ADD CONSTRAINT FK_A7AED006A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE
INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_annotation" ADD CONSTRAINT FK_A7AED006BA364942 FOREIGN KEY (entry_id) REFERENCES "wallabag_entry" (id) NOT DEFERRAB
LE INITIALLY IMMEDIATE;
++ migrated (5.68s)
++ migrating 20160410190541
Migration 20160410190541 failed during Execution. Error An exception occurred while executing 'SELECT min_value, increment_by FROM "entry_id_seq"
':
SQLSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
17:11:03 ERROR [console] Error thrown while running command "doctrine:migrations:migrate --no-interaction=1 --no-debug=1 --env=prod". Message
: "An exception occurred while executing 'SELECT min_value, increment_by FROM "entry_id_seq"':
SQLSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^" ["error" => Doctrine\DBAL\Exception\InvalidFieldNameException { …},"command" => "doctrine:migrations:migrate --no-interaction=1
--no-debug=1 --env=prod","message" => """ An exception occurred while executing 'SELECT min_value, increment_by FROM "entry_id_seq"':\n \n SQ
LSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist\n LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"\n
^ """] []
[Doctrine\DBAL\Exception\InvalidFieldNameException]
An exception occurred while executing 'SELECT min_value, increment_by FROM "entry_id_seq"':
SQLSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
[PDOException]
SQLSTATE[42703]: Undefined column: 7 ERROR: column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
doctrine:migrations:migrate [--write-sql] [--dry-run] [--query-time] [--allow-no-migration] [--configuration [CONFIGURATION]] [--db-configuration
[DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|-
-no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
About this issue
- Original URL
- State: closed
- Created 6 years ago
- Reactions: 1
- Comments: 18 (14 by maintainers)
Ok I found the bug. We force the database version to 5.6 since https://github.com/wallabag/wallabag/pull/1903 When forcing the database version it applies to all possible database, MySQL, Postgres & SQLite. Which means, when we are using dbal, as we force the database version to 5.6, dbal think we are using Postgresql 5.6.0 and load the default platform
PostgreSqlPlatforminstead ofPostgreSQL100Platformin your case. As this sequence stuff changed in Postgres 10 and not in Postgres 9 we now got that error.Pfiou. I’m going to check that but my guess is it won’t be fixed for 2.3.x but in 2.4.0.