You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I try to do a fresh installation of Wallabag. I get the following errors, when the database should be filled/created:
Sorry to bother you!
Issue details
[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 NULL, 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 BOOLEAN NOT NULL, is_starred BOOLEAN NOT NULL, content TE
XT 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 DEFAU
LT NULL, domain_name TEXT DEFAULT NULL, 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, language VARCHAR(255) NOT NULL, rss_token VARCHAR(255) DEF
AULT 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, PRIMARY 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 NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) D
EFAULT 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 N
ULL, 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(180) NOT NULL, email_canonical VARCHAR(180) NOT NULL, en
abled BOOLEAN NOT NULL, salt VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_login TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, locked BOOLEAN NOT NULL, expired BOOLEAN NOT NULL, expires_
at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, password_requested_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, roles TEXT NOT NULL, credentials_expir
ed BOOLEAN NOT NULL, credentials_expire_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, name TEXT DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, updated_at TIMESTAMP(0) WITHOUT TIM
E ZONE NOT NULL, authCode INT DEFAULT NULL, twoFactorAuthentication BOOLEAN 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 TI
MESTAMP(0) WITHOUT TIME ZONE NOT NULL, quote VARCHAR(255) NOT NULL, ranges TEXT NOT NULL, PRIMARY 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 INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_entry_tag" ADD CONSTRAINT FK_C9F0DD7CBA364942 FOREIGN KEY (entry_id) REFERENCES "wallabag_entry" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_entry_tag" ADD CONSTRAINT FK_C9F0DD7CBAD26311 FOREIGN KEY (tag_id) REFERENCES "wallabag_tag" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_config" ADD CONSTRAINT FK_87E64C53A76ED395 FOREIGN KEY (user_id) REFERENCES "wallabag_user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_tagging_rule" ADD CONSTRAINT FK_2D9B3C5424DB0683 FOREIGN KEY (config_id) REFERENCES "wallabag_config" (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
-> ALTER TABLE "wallabag_oauth2_access_tokens" ADD CONSTRAINT FK_368A420919EB6921 FOREIGN KEY (client_id) REFERENCES "wallabag_oauth2_clients" (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_clients" (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 DEFERRABLE 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 DEFERRABLE INITIALLY IMMEDIATE;
++ migrated (1.95s)
++ migrating 20160410190541
# This file is auto-generated during the composer install
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 ERREUR: la colonne « min_value » n'existe pas
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
16:26:58 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_v
alue, increment_by FROM "entry_id_seq"':
SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « min_value » n'existe pas
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 excepti
on occurred while executing 'SELECT min_value, increment_by FROM "entry_id_seq"':\n \n SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « min_value » n'existe pas\n LINE 1: SELECT min_valu
e, 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 ERREUR: la colonne « min_value » n'existe pas
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « min_value » n'existe pas
LINE 1: SELECT min_value, increment_by FROM "entry_id_seq"
^
[PDOException]
SQLSTATE[42703]: Undefined column: 7 ERREUR: la colonne « min_value » n'existe pas
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 SHAR
D] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
I try to do a fresh installation of Wallabag. I get the following errors, when the database should be filled/created:
Sorry to bother you!
Issue details
Environment
app/config/parameters.yml
The text was updated successfully, but these errors were encountered: