[2026-09-15T17:27:03.395810+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-15T17:27:03.399136+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-15T17:27:03.511767+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-15T17:27:03.531865+00:00] doctrine.DEBUG: Executing statement: SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME (parameters: array{"1":"livrecomment_db_test"}, types: array{"1":0}) {"sql":"SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n AND TABLE_TYPE = 'BASE TABLE'\nORDER BY TABLE_NAME","params":{"1":"livrecomment_db_test"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-15T17:27:03.959233+00:00] doctrine.DEBUG: Executing statement: CREATE TABLE doctrine_migration_versions (version VARCHAR(191) NOT NULL, executed_at DATETIME DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY (version)) {"sql":"CREATE TABLE doctrine_migration_versions (version VARCHAR(191) NOT NULL, executed_at DATETIME DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY (version))"} [] [2026-09-15T17:27:04.500730+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-15T17:27:04.514949+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-15T17:27:04.515587+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-15T17:27:04.684097+00:00] doctrine.DEBUG: Beginning transaction [] [] [2026-09-15T17:27:04.711314+00:00] deprecation.INFO: User Deprecated: The "Doctrine\DBAL\Schema\Schema" class is considered final. It may change without further notice as of its next major version. You should not extend it from "Doctrine\Migrations\Provider\LazySchema". {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\DBAL\\Schema\\Schema\" class is considered final. It may change without further notice as of its next major version. You should not extend it from \"Doctrine\\Migrations\\Provider\\LazySchema\". at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-15T17:27:04.711362+00:00] deprecation.INFO: User Deprecated: The "Doctrine\Migrations\Provider\LazySchema" class uses "Symfony\Component\VarExporter\LazyProxyTrait" that is deprecated since Symfony 7.3, use native lazy objects instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\Migrations\\Provider\\LazySchema\" class uses \"Symfony\\Component\\VarExporter\\LazyProxyTrait\" that is deprecated since Symfony 7.3, use native lazy objects instead. at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-15T17:27:04.718581+00:00] doctrine.DEBUG: Executing query: CREATE TABLE authors (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, name VARCHAR(150) NOT NULL, slug VARCHAR(160) NOT NULL, bio LONGTEXT DEFAULT NULL, birth_year SMALLINT DEFAULT NULL, death_year SMALLINT DEFAULT NULL, photo_url VARCHAR(500) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_8E0C2A51F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_8E0C2A51989D9B62 (slug), UNIQUE INDEX UNIQ_8E0C2A51B5B48B91 (public_id), INDEX idx_authors_name (name), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE authors (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, name VARCHAR(150) NOT NULL, slug VARCHAR(160) NOT NULL, bio LONGTEXT DEFAULT NULL, birth_year SMALLINT DEFAULT NULL, death_year SMALLINT DEFAULT NULL, photo_url VARCHAR(500) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_8E0C2A51F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_8E0C2A51989D9B62 (slug), UNIQUE INDEX UNIQ_8E0C2A51B5B48B91 (public_id), INDEX idx_authors_name (name), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.734100+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_list_items (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, position INT UNSIGNED DEFAULT 0 NOT NULL, note VARCHAR(500) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, list_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_A72037FD3DAE168B (list_id), INDEX IDX_A72037FD16A2B381 (book_id), INDEX idx_book_list_items_list_pos (list_id, position), UNIQUE INDEX uniq_book_list_items_list_book (list_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_list_items (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, position INT UNSIGNED DEFAULT 0 NOT NULL, note VARCHAR(500) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, list_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_A72037FD3DAE168B (list_id), INDEX IDX_A72037FD16A2B381 (book_id), INDEX idx_book_list_items_list_pos (list_id, position), UNIQUE INDEX uniq_book_list_items_list_book (list_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.738675+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_lists (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(20) NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(500) DEFAULT NULL, is_public TINYINT DEFAULT 1 NOT NULL, items_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, owner_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6E48ADCB5B48B91 (public_id), INDEX IDX_6E48ADC7E3C61F9 (owner_id), INDEX idx_book_lists_owner_type (owner_id, type), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_lists (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(20) NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(500) DEFAULT NULL, is_public TINYINT DEFAULT 1 NOT NULL, items_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, owner_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6E48ADCB5B48B91 (public_id), INDEX IDX_6E48ADC7E3C61F9 (owner_id), INDEX idx_book_lists_owner_type (owner_id, type), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.744752+00:00] doctrine.DEBUG: Executing query: CREATE TABLE books (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, title VARCHAR(255) NOT NULL, subtitle VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, original_title VARCHAR(255) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_4A1B2A92F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_4A1B2A9279FDCE08 (google_books_id), UNIQUE INDEX UNIQ_4A1B2A92B5B48B91 (public_id), INDEX idx_books_isbn13 (isbn_13), INDEX idx_books_isbn10 (isbn_10), INDEX idx_books_title (title), INDEX idx_books_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE books (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, title VARCHAR(255) NOT NULL, subtitle VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, original_title VARCHAR(255) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_4A1B2A92F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_4A1B2A9279FDCE08 (google_books_id), UNIQUE INDEX UNIQ_4A1B2A92B5B48B91 (public_id), INDEX idx_books_isbn13 (isbn_13), INDEX idx_books_isbn10 (isbn_10), INDEX idx_books_title (title), INDEX idx_books_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.748920+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_authors (book_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, INDEX IDX_1D2C02C716A2B381 (book_id), INDEX IDX_1D2C02C7F675F31B (author_id), PRIMARY KEY (book_id, author_id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_authors (book_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, INDEX IDX_1D2C02C716A2B381 (book_id), INDEX IDX_1D2C02C7F675F31B (author_id), PRIMARY KEY (book_id, author_id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.752307+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_genres (book_id BIGINT UNSIGNED NOT NULL, genre_id INT UNSIGNED NOT NULL, INDEX IDX_813CEE9B16A2B381 (book_id), INDEX IDX_813CEE9B4296D31F (genre_id), PRIMARY KEY (book_id, genre_id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_genres (book_id BIGINT UNSIGNED NOT NULL, genre_id INT UNSIGNED NOT NULL, INDEX IDX_813CEE9B16A2B381 (book_id), INDEX IDX_813CEE9B4296D31F (genre_id), PRIMARY KEY (book_id, genre_id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.755164+00:00] doctrine.DEBUG: Executing query: CREATE TABLE follows (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, follower_id BIGINT UNSIGNED NOT NULL, followed_id BIGINT UNSIGNED NOT NULL, INDEX IDX_4B638A73AC24F853 (follower_id), INDEX IDX_4B638A73D956F010 (followed_id), INDEX idx_follows_followed_created (followed_id, created_at), UNIQUE INDEX uniq_follows_follower_followed (follower_id, followed_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE follows (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, follower_id BIGINT UNSIGNED NOT NULL, followed_id BIGINT UNSIGNED NOT NULL, INDEX IDX_4B638A73AC24F853 (follower_id), INDEX IDX_4B638A73D956F010 (followed_id), INDEX idx_follows_followed_created (followed_id, created_at), UNIQUE INDEX uniq_follows_follower_followed (follower_id, followed_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.758215+00:00] doctrine.DEBUG: Executing query: CREATE TABLE genres (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(80) NOT NULL, slug VARCHAR(80) NOT NULL, description VARCHAR(255) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_A8EBE5165E237E06 (name), UNIQUE INDEX UNIQ_A8EBE516989D9B62 (slug), UNIQUE INDEX UNIQ_A8EBE516B5B48B91 (public_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE genres (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(80) NOT NULL, slug VARCHAR(80) NOT NULL, description VARCHAR(255) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_A8EBE5165E237E06 (name), UNIQUE INDEX UNIQ_A8EBE516989D9B62 (slug), UNIQUE INDEX UNIQ_A8EBE516B5B48B91 (public_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.762574+00:00] doctrine.DEBUG: Executing query: CREATE TABLE ratings (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, score NUMERIC(2, 1) NOT NULL, read_at DATE DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_CEB607C9B5B48B91 (public_id), INDEX IDX_CEB607C9A76ED395 (user_id), INDEX IDX_CEB607C916A2B381 (book_id), INDEX idx_ratings_book_score (book_id, score), INDEX idx_ratings_user_created (user_id, created_at), UNIQUE INDEX uniq_ratings_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE ratings (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, score NUMERIC(2, 1) NOT NULL, read_at DATE DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_CEB607C9B5B48B91 (public_id), INDEX IDX_CEB607C9A76ED395 (user_id), INDEX IDX_CEB607C916A2B381 (book_id), INDEX idx_ratings_book_score (book_id, score), INDEX idx_ratings_user_created (user_id, created_at), UNIQUE INDEX uniq_ratings_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.766181+00:00] doctrine.DEBUG: Executing query: CREATE TABLE review_comments (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_7CDC1F21B5B48B91 (public_id), INDEX IDX_7CDC1F213E2E969B (review_id), INDEX IDX_7CDC1F21F675F31B (author_id), INDEX idx_review_comments_review_created (review_id, created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE review_comments (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_7CDC1F21B5B48B91 (public_id), INDEX IDX_7CDC1F213E2E969B (review_id), INDEX IDX_7CDC1F21F675F31B (author_id), INDEX idx_review_comments_review_created (review_id, created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.769516+00:00] doctrine.DEBUG: Executing query: CREATE TABLE review_likes (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, INDEX IDX_5A4462663E2E969B (review_id), INDEX IDX_5A446266A76ED395 (user_id), INDEX idx_review_likes_user_created (user_id, created_at), UNIQUE INDEX uniq_review_likes_review_user (review_id, user_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE review_likes (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, INDEX IDX_5A4462663E2E969B (review_id), INDEX IDX_5A446266A76ED395 (user_id), INDEX idx_review_likes_user_created (user_id, created_at), UNIQUE INDEX uniq_review_likes_review_user (review_id, user_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.772697+00:00] doctrine.DEBUG: Executing query: CREATE TABLE reviews (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, contains_spoilers TINYINT DEFAULT 0 NOT NULL, likes_count INT UNSIGNED DEFAULT 0 NOT NULL, comments_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, rating_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6970EB0FB5B48B91 (public_id), UNIQUE INDEX UNIQ_6970EB0FA32EFC6 (rating_id), INDEX idx_reviews_created (created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE reviews (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, contains_spoilers TINYINT DEFAULT 0 NOT NULL, likes_count INT UNSIGNED DEFAULT 0 NOT NULL, comments_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, rating_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6970EB0FB5B48B91 (public_id), UNIQUE INDEX UNIQ_6970EB0FA32EFC6 (rating_id), INDEX idx_reviews_created (created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.776016+00:00] doctrine.DEBUG: Executing query: CREATE TABLE users (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, username VARCHAR(30) NOT NULL, password VARCHAR(255) NOT NULL, display_name VARCHAR(60) DEFAULT NULL, bio LONGTEXT DEFAULT NULL, avatar_path VARCHAR(255) DEFAULT NULL, roles JSON NOT NULL, email_verified_at DATETIME DEFAULT NULL, last_login_at DATETIME DEFAULT NULL, is_active TINYINT DEFAULT 1 NOT NULL, locale VARCHAR(5) DEFAULT 'fr' NOT NULL, deleted_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_1483A5E9B5B48B91 (public_id), INDEX idx_users_active (is_active, deleted_at), UNIQUE INDEX uniq_users_email (email), UNIQUE INDEX uniq_users_username (username), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE users (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, username VARCHAR(30) NOT NULL, password VARCHAR(255) NOT NULL, display_name VARCHAR(60) DEFAULT NULL, bio LONGTEXT DEFAULT NULL, avatar_path VARCHAR(255) DEFAULT NULL, roles JSON NOT NULL, email_verified_at DATETIME DEFAULT NULL, last_login_at DATETIME DEFAULT NULL, is_active TINYINT DEFAULT 1 NOT NULL, locale VARCHAR(5) DEFAULT 'fr' NOT NULL, deleted_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_1483A5E9B5B48B91 (public_id), INDEX idx_users_active (is_active, deleted_at), UNIQUE INDEX uniq_users_email (email), UNIQUE INDEX uniq_users_username (username), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.780410+00:00] doctrine.DEBUG: Executing query: CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0E3BD61CE16BA31DBBF396750 (queue_name, available_at, delivered_at, id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0E3BD61CE16BA31DBBF396750 (queue_name, available_at, delivered_at, id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:04.785874+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD3DAE168B FOREIGN KEY (list_id) REFERENCES book_lists (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD3DAE168B FOREIGN KEY (list_id) REFERENCES book_lists (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.805859+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.817039+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_lists ADD CONSTRAINT FK_6E48ADC7E3C61F9 FOREIGN KEY (owner_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_lists ADD CONSTRAINT FK_6E48ADC7E3C61F9 FOREIGN KEY (owner_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.829761+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C716A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C716A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.841506+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C7F675F31B FOREIGN KEY (author_id) REFERENCES authors (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C7F675F31B FOREIGN KEY (author_id) REFERENCES authors (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.851082+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.862075+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B4296D31F FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B4296D31F FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.871380+00:00] doctrine.DEBUG: Executing query: ALTER TABLE follows ADD CONSTRAINT FK_4B638A73AC24F853 FOREIGN KEY (follower_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE follows ADD CONSTRAINT FK_4B638A73AC24F853 FOREIGN KEY (follower_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.882859+00:00] doctrine.DEBUG: Executing query: ALTER TABLE follows ADD CONSTRAINT FK_4B638A73D956F010 FOREIGN KEY (followed_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE follows ADD CONSTRAINT FK_4B638A73D956F010 FOREIGN KEY (followed_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.893625+00:00] doctrine.DEBUG: Executing query: ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C9A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C9A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.910064+00:00] doctrine.DEBUG: Executing query: ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C916A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C916A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.920525+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F213E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F213E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.931853+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F21F675F31B FOREIGN KEY (author_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F21F675F31B FOREIGN KEY (author_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.944878+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_likes ADD CONSTRAINT FK_5A4462663E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_likes ADD CONSTRAINT FK_5A4462663E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.956676+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_likes ADD CONSTRAINT FK_5A446266A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_likes ADD CONSTRAINT FK_5A446266A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.967559+00:00] doctrine.DEBUG: Executing query: ALTER TABLE reviews ADD CONSTRAINT FK_6970EB0FA32EFC6 FOREIGN KEY (rating_id) REFERENCES ratings (id) ON DELETE CASCADE {"sql":"ALTER TABLE reviews ADD CONSTRAINT FK_6970EB0FA32EFC6 FOREIGN KEY (rating_id) REFERENCES ratings (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:04.992286+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260511153433","2":"2026-09-15 17:27:04","3":295}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260511153433","2":"2026-09-15 17:27:04","3":295},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-15T17:27:05.002550+00:00] deprecation.INFO: User Deprecated: Context: trying to commit a transaction Problem: the transaction is already committed, relying on silencing is deprecated. Solution: override `AbstractMigration::isTransactional()` so that it returns false. Automate that by setting `transactional` to false in the configuration. More details at https://www.doctrine-project.org/projects/doctrine-migrations/en/stable/explanation/implicit-commits.html (TransactionHelper.php:20 called by DbalExecutor.php:193, https://github.com/doctrine/migrations/issues/1169, package doctrine/migrations) {"exception":"[object] (ErrorException(code: 0): User Deprecated: Context: trying to commit a transaction\nProblem: the transaction is already committed, relying on silencing is deprecated.\nSolution: override `AbstractMigration::isTransactional()` so that it returns false.\nAutomate that by setting `transactional` to false in the configuration.\nMore details at https://www.doctrine-project.org/projects/doctrine-migrations/en/stable/explanation/implicit-commits.html (TransactionHelper.php:20 called by DbalExecutor.php:193, https://github.com/doctrine/migrations/issues/1169, package doctrine/migrations) at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/deprecations/src/Deprecation.php:208)"} [] [2026-09-15T17:27:05.002646+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_2 {"sql":"SAVEPOINT DOCTRINE_2"} [] [2026-09-15T17:27:05.002959+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_lists CHANGE is_public is_public TINYINT DEFAULT 0 NOT NULL {"sql":"ALTER TABLE book_lists CHANGE is_public is_public TINYINT DEFAULT 0 NOT NULL"} [] [2026-09-15T17:27:05.010059+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260512121001","2":"2026-09-15 17:27:05","3":7}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260512121001","2":"2026-09-15 17:27:05","3":7},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-15T17:27:05.010394+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_3 {"sql":"SAVEPOINT DOCTRINE_3"} [] [2026-09-15T17:27:05.010531+00:00] doctrine.DEBUG: Executing query: CREATE TABLE user_favorites (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_E489ED11A76ED395 (user_id), INDEX IDX_E489ED1116A2B381 (book_id), INDEX idx_user_favorites_user_created (user_id, created_at), UNIQUE INDEX uniq_user_favorites_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE user_favorites (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_E489ED11A76ED395 (user_id), INDEX IDX_E489ED1116A2B381 (book_id), INDEX idx_user_favorites_user_created (user_id, created_at), UNIQUE INDEX uniq_user_favorites_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:05.014581+00:00] doctrine.DEBUG: Executing query: ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED11A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED11A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:05.028023+00:00] doctrine.DEBUG: Executing query: ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED1116A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED1116A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-15T17:27:05.038444+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260513121159","2":"2026-09-15 17:27:05","3":28}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260513121159","2":"2026-09-15 17:27:05","3":28},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-15T17:27:05.038775+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_4 {"sql":"SAVEPOINT DOCTRINE_4"} [] [2026-09-15T17:27:05.038904+00:00] doctrine.DEBUG: Executing query: ALTER TABLE reviews ADD is_pinned TINYINT DEFAULT 0 NOT NULL {"sql":"ALTER TABLE reviews ADD is_pinned TINYINT DEFAULT 0 NOT NULL"} [] [2026-09-15T17:27:05.053975+00:00] doctrine.DEBUG: Executing query: ALTER TABLE users ADD pinned_quote VARCHAR(280) DEFAULT NULL {"sql":"ALTER TABLE users ADD pinned_quote VARCHAR(280) DEFAULT NULL"} [] [2026-09-15T17:27:05.066851+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260513123915","2":"2026-09-15 17:27:05","3":28}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260513123915","2":"2026-09-15 17:27:05","3":28},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-15T17:27:05.067292+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 0 {"sql":"SET FOREIGN_KEY_CHECKS = 0"} [] [2026-09-15T17:27:05.067396+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_list_items {"sql":"TRUNCATE TABLE book_list_items"} [] [2026-09-15T17:27:05.068521+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE ratings {"sql":"TRUNCATE TABLE ratings"} [] [2026-09-15T17:27:05.069418+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE reviews {"sql":"TRUNCATE TABLE reviews"} [] [2026-09-15T17:27:05.070000+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_authors {"sql":"TRUNCATE TABLE book_authors"} [] [2026-09-15T17:27:05.070580+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_genres {"sql":"TRUNCATE TABLE book_genres"} [] [2026-09-15T17:27:05.071110+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE books {"sql":"TRUNCATE TABLE books"} [] [2026-09-15T17:27:05.071919+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 1 {"sql":"SET FOREIGN_KEY_CHECKS = 1"} [] [2026-09-15T17:27:05.072042+00:00] doctrine.DEBUG: Executing query: CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:05.075814+00:00] doctrine.DEBUG: Executing query: CREATE TABLE works (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_work_id VARCHAR(50) DEFAULT NULL, canonical_key VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, original_title VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, first_published_year SMALLINT UNSIGNED DEFAULT NULL, original_language VARCHAR(5) DEFAULT NULL, default_cover_url VARCHAR(500) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_F6E5024345E5FBFA (open_library_work_id), UNIQUE INDEX UNIQ_F6E50243B57AAE94 (canonical_key), UNIQUE INDEX UNIQ_F6E50243B5B48B91 (public_id), INDEX idx_works_title (title), INDEX idx_works_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE works (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_work_id VARCHAR(50) DEFAULT NULL, canonical_key VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, original_title VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, first_published_year SMALLINT UNSIGNED DEFAULT NULL, original_language VARCHAR(5) DEFAULT NULL, default_cover_url VARCHAR(500) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_F6E5024345E5FBFA (open_library_work_id), UNIQUE INDEX UNIQ_F6E50243B57AAE94 (canonical_key), UNIQUE INDEX UNIQ_F6E50243B5B48B91 (public_id), INDEX idx_works_title (title), INDEX idx_works_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-15T17:27:05.176055+00:00] console.CRITICAL: Error thrown while running command "doctrine:migrations:migrate --env=test --no-interaction". Message: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1071): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:102)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1071): SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)","command":"doctrine:migrations:migrate --env=test --no-interaction","message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000"} [] [2026-09-15T17:27:05.180680+00:00] console.DEBUG: Command "doctrine:migrations:migrate --env=test --no-interaction" exited with code "1071" {"command":"doctrine:migrations:migrate --env=test --no-interaction","code":1071} [] [2026-09-17T11:59:19.580998+00:00] request.INFO: Matched route "app_forgot_password_request". {"route":"app_forgot_password_request","route_parameters":{"_route":"app_forgot_password_request","_controller":"App\\Controller\\ResetPasswordController::request"},"request_uri":"http://localhost/reset-password","method":"GET"} [] [2026-09-17T11:59:19.638421+00:00] security.DEBUG: Checking for authenticator support. {"firewall_name":"main","authenticators":1} [] [2026-09-17T11:59:19.638442+00:00] security.DEBUG: Checking support on authenticator. {"firewall_name":"main","authenticator":"Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticator"} [] [2026-09-17T11:59:19.638459+00:00] security.DEBUG: Authenticator does not support the request. {"firewall_name":"main","authenticator":"Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticator"} [] [2026-09-17T11:59:24.400995+00:00] request.CRITICAL: Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("The "@hotwired/stimulus" vendor asset is missing. Try running the "importmap:install" command.") in "base.html.twig" at line 139." at base.html.twig line 139 {"exception":"[object] (Twig\\Error\\RuntimeError(code: 0): An exception has been thrown during the rendering of a template (\"The \"@hotwired/stimulus\" vendor asset is missing. Try running the \"importmap:install\" command.\") in \"base.html.twig\" at line 139. at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/templates/base.html.twig:139)\n[previous exception] [object] (Symfony\\Component\\AssetMapper\\Exception\\LogicException(code: 0): The \"@hotwired/stimulus\" vendor asset is missing. Try running the \"importmap:install\" command. at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/asset-mapper/ImportMap/ImportMapGenerator.php:256)"} [] [2026-09-17T11:59:26.050333+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-17T11:59:28.186019+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-17T11:59:30.247720+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":8889,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"letterbook_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-17T12:03:22.033427+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-17T12:03:22.037683+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.155216+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.170598+00:00] doctrine.DEBUG: Executing statement: SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME (parameters: array{"1":"livrecomment_db_test"}, types: array{"1":0}) {"sql":"SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n AND TABLE_TYPE = 'BASE TABLE'\nORDER BY TABLE_NAME","params":{"1":"livrecomment_db_test"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:22.704138+00:00] doctrine.DEBUG: Executing query: SELECT @@character_set_database, @@collation_database {"sql":"SELECT @@character_set_database, @@collation_database"} [] [2026-09-17T12:03:22.749395+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.749838+00:00] doctrine.DEBUG: Executing statement: SELECT c.TABLE_NAME, c.COLUMN_NAME, c.DATA_TYPE, c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.EXTRA, c.COLUMN_COMMENT, c.CHARACTER_SET_NAME, c.COLLATION_NAME FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION (parameters: array{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"}, types: array{"1":0,"2":0,"3":0}) {"sql":"SELECT c.TABLE_NAME,\n c.COLUMN_NAME,\n c.DATA_TYPE,\n c.COLUMN_TYPE,\n c.CHARACTER_MAXIMUM_LENGTH,\n c.CHARACTER_OCTET_LENGTH,\n c.NUMERIC_PRECISION,\n c.NUMERIC_SCALE,\n c.IS_NULLABLE,\n c.COLUMN_DEFAULT,\n c.EXTRA,\n c.COLUMN_COMMENT,\n c.CHARACTER_SET_NAME,\n c.COLLATION_NAME\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_NAME = c.TABLE_NAME\nWHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?\n AND t.TABLE_TYPE = 'BASE TABLE'\nORDER BY c.TABLE_NAME,\n c.ORDINAL_POSITION","params":{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:22.803319+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.803748+00:00] doctrine.DEBUG: Executing statement: SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' (parameters: array{"1":"livrecomment_db_test","2":"doctrine_migration_versions"}, types: array{"1":0,"2":0}) {"sql":" SELECT t.TABLE_NAME,\n t.ENGINE,\n t.AUTO_INCREMENT,\n t.TABLE_COMMENT,\n t.CREATE_OPTIONS,\n t.TABLE_COLLATION,\n ccsa.CHARACTER_SET_NAME\n FROM information_schema.TABLES t\n INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'","params":{"1":"livrecomment_db_test","2":"doctrine_migration_versions"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:22.905077+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.919141+00:00] doctrine.DEBUG: Executing statement: SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME, kcu.COLUMN_NAME FROM information_schema.TABLE_CONSTRAINTS tc INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ? AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME, kcu.ORDINAL_POSITION (parameters: array{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"}, types: array{"1":0,"2":0,"3":0}) {"sql":"SELECT tc.TABLE_NAME,\n tc.CONSTRAINT_NAME,\n kcu.COLUMN_NAME\nFROM information_schema.TABLE_CONSTRAINTS tc\n INNER JOIN information_schema.KEY_COLUMN_USAGE kcu\n ON kcu.TABLE_NAME = tc.TABLE_NAME\n AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME\nWHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?\n AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'\nORDER BY TABLE_NAME,\n kcu.ORDINAL_POSITION","params":{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:22.948959+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.960040+00:00] doctrine.DEBUG: Executing statement: SELECT TABLE_NAME, INDEX_NAME, INDEX_TYPE, NON_UNIQUE, COLUMN_NAME, SUB_PART FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND INDEX_NAME != 'PRIMARY' ORDER BY TABLE_NAME, SEQ_IN_INDEX (parameters: array{"1":"livrecomment_db_test","2":"doctrine_migration_versions"}, types: array{"1":0,"2":0}) {"sql":"SELECT TABLE_NAME,\n INDEX_NAME,\n INDEX_TYPE,\n NON_UNIQUE,\n COLUMN_NAME,\n SUB_PART\nFROM information_schema.STATISTICS\nWHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?\n AND INDEX_NAME != 'PRIMARY'\nORDER BY TABLE_NAME,\n SEQ_IN_INDEX","params":{"1":"livrecomment_db_test","2":"doctrine_migration_versions"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:22.965539+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:22.981182+00:00] doctrine.DEBUG: Executing statement: SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.REFERENCED_TABLE_NAME, c.UPDATE_RULE, c.DELETE_RULE, k.COLUMN_NAME, k.REFERENCED_COLUMN_NAME FROM information_schema.KEY_COLUMN_USAGE k INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION (parameters: array{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"}, types: array{"1":0,"2":0,"3":0}) {"sql":"SELECT k.TABLE_NAME,\n k.CONSTRAINT_NAME,\n k.REFERENCED_TABLE_NAME,\n c.UPDATE_RULE,\n c.DELETE_RULE,\n k.COLUMN_NAME,\n k.REFERENCED_COLUMN_NAME\nFROM information_schema.KEY_COLUMN_USAGE k\n INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c\n ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n AND c.TABLE_NAME = k.TABLE_NAME\nWHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?\n AND k.REFERENCED_COLUMN_NAME IS NOT NULL\nORDER BY k.TABLE_NAME,\n k.CONSTRAINT_NAME,\n k.ORDINAL_POSITION","params":{"1":"livrecomment_db_test","2":"livrecomment_db_test","3":"doctrine_migration_versions"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:23.252788+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:23.277223+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:23.278085+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:23.505989+00:00] deprecation.INFO: User Deprecated: The "Doctrine\DBAL\Schema\Schema" class is considered final. It may change without further notice as of its next major version. You should not extend it from "Doctrine\Migrations\Provider\LazySchema". {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\DBAL\\Schema\\Schema\" class is considered final. It may change without further notice as of its next major version. You should not extend it from \"Doctrine\\Migrations\\Provider\\LazySchema\". at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-17T12:03:23.506036+00:00] deprecation.INFO: User Deprecated: The "Doctrine\Migrations\Provider\LazySchema" class uses "Symfony\Component\VarExporter\LazyProxyTrait" that is deprecated since Symfony 7.3, use native lazy objects instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\Migrations\\Provider\\LazySchema\" class uses \"Symfony\\Component\\VarExporter\\LazyProxyTrait\" that is deprecated since Symfony 7.3, use native lazy objects instead. at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-17T12:03:23.516572+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 0 {"sql":"SET FOREIGN_KEY_CHECKS = 0"} [] [2026-09-17T12:03:23.517793+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_list_items {"sql":"TRUNCATE TABLE book_list_items"} [] [2026-09-17T12:03:23.535691+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE ratings {"sql":"TRUNCATE TABLE ratings"} [] [2026-09-17T12:03:23.539644+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE reviews {"sql":"TRUNCATE TABLE reviews"} [] [2026-09-17T12:03:23.542360+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_authors {"sql":"TRUNCATE TABLE book_authors"} [] [2026-09-17T12:03:23.543431+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_genres {"sql":"TRUNCATE TABLE book_genres"} [] [2026-09-17T12:03:23.545641+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE books {"sql":"TRUNCATE TABLE books"} [] [2026-09-17T12:03:23.547785+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 1 {"sql":"SET FOREIGN_KEY_CHECKS = 1"} [] [2026-09-17T12:03:23.547939+00:00] doctrine.DEBUG: Executing query: CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:23.585601+00:00] console.CRITICAL: Error thrown while running command "doctrine:migrations:migrate --env=test --no-interaction". Message: "An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 La table 'editions' existe déjà" {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableExistsException(code: 1050): An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 La table 'editions' existe déjà at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1050): SQLSTATE[42S01]: Base table or view already exists: 1050 La table 'editions' existe déjà at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 La table 'editions' existe déjà at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)","command":"doctrine:migrations:migrate --env=test --no-interaction","message":"An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 La table 'editions' existe déjà"} [] [2026-09-17T12:03:23.590021+00:00] console.DEBUG: Command "doctrine:migrations:migrate --env=test --no-interaction" exited with code "1050" {"command":"doctrine:migrations:migrate --env=test --no-interaction","code":1050} [] [2026-09-17T12:03:45.867113+00:00] doctrine.INFO: Connecting with parameters array{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"} {"params":{"dbname_suffix":"_test","driver":"pdo_mysql","idle_connection_ttl":600,"host":"127.0.0.1","port":3306,"user":"root","password":"","driverOptions":[],"defaultTableOptions":[],"dbname":"livrecomment_db_test","serverVersion":"8.0.32","charset":"utf8mb4"}} [] [2026-09-17T12:03:45.872193+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:45.877131+00:00] doctrine.DEBUG: Executing query: SELECT DATABASE() {"sql":"SELECT DATABASE()"} [] [2026-09-17T12:03:45.877883+00:00] doctrine.DEBUG: Executing statement: SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME (parameters: array{"1":"livrecomment_db_test"}, types: array{"1":0}) {"sql":"SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n AND TABLE_TYPE = 'BASE TABLE'\nORDER BY TABLE_NAME","params":{"1":"livrecomment_db_test"},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:45.891145+00:00] doctrine.DEBUG: Executing statement: CREATE TABLE doctrine_migration_versions (version VARCHAR(191) NOT NULL, executed_at DATETIME DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY (version)) {"sql":"CREATE TABLE doctrine_migration_versions (version VARCHAR(191) NOT NULL, executed_at DATETIME DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY (version))"} [] [2026-09-17T12:03:45.916260+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:45.919778+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:45.920322+00:00] doctrine.DEBUG: Executing query: SELECT * FROM doctrine_migration_versions {"sql":"SELECT * FROM doctrine_migration_versions"} [] [2026-09-17T12:03:45.926746+00:00] doctrine.DEBUG: Beginning transaction [] [] [2026-09-17T12:03:45.928509+00:00] deprecation.INFO: User Deprecated: The "Doctrine\DBAL\Schema\Schema" class is considered final. It may change without further notice as of its next major version. You should not extend it from "Doctrine\Migrations\Provider\LazySchema". {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\DBAL\\Schema\\Schema\" class is considered final. It may change without further notice as of its next major version. You should not extend it from \"Doctrine\\Migrations\\Provider\\LazySchema\". at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-17T12:03:45.928549+00:00] deprecation.INFO: User Deprecated: The "Doctrine\Migrations\Provider\LazySchema" class uses "Symfony\Component\VarExporter\LazyProxyTrait" that is deprecated since Symfony 7.3, use native lazy objects instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: The \"Doctrine\\Migrations\\Provider\\LazySchema\" class uses \"Symfony\\Component\\VarExporter\\LazyProxyTrait\" that is deprecated since Symfony 7.3, use native lazy objects instead. at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/symfony/error-handler/DebugClassLoader.php:363)"} [] [2026-09-17T12:03:45.929094+00:00] doctrine.DEBUG: Executing query: CREATE TABLE authors (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, name VARCHAR(150) NOT NULL, slug VARCHAR(160) NOT NULL, bio LONGTEXT DEFAULT NULL, birth_year SMALLINT DEFAULT NULL, death_year SMALLINT DEFAULT NULL, photo_url VARCHAR(500) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_8E0C2A51F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_8E0C2A51989D9B62 (slug), UNIQUE INDEX UNIQ_8E0C2A51B5B48B91 (public_id), INDEX idx_authors_name (name), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE authors (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, name VARCHAR(150) NOT NULL, slug VARCHAR(160) NOT NULL, bio LONGTEXT DEFAULT NULL, birth_year SMALLINT DEFAULT NULL, death_year SMALLINT DEFAULT NULL, photo_url VARCHAR(500) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_8E0C2A51F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_8E0C2A51989D9B62 (slug), UNIQUE INDEX UNIQ_8E0C2A51B5B48B91 (public_id), INDEX idx_authors_name (name), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.934603+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_list_items (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, position INT UNSIGNED DEFAULT 0 NOT NULL, note VARCHAR(500) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, list_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_A72037FD3DAE168B (list_id), INDEX IDX_A72037FD16A2B381 (book_id), INDEX idx_book_list_items_list_pos (list_id, position), UNIQUE INDEX uniq_book_list_items_list_book (list_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_list_items (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, position INT UNSIGNED DEFAULT 0 NOT NULL, note VARCHAR(500) DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, list_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_A72037FD3DAE168B (list_id), INDEX IDX_A72037FD16A2B381 (book_id), INDEX idx_book_list_items_list_pos (list_id, position), UNIQUE INDEX uniq_book_list_items_list_book (list_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.940556+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_lists (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(20) NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(500) DEFAULT NULL, is_public TINYINT DEFAULT 1 NOT NULL, items_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, owner_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6E48ADCB5B48B91 (public_id), INDEX IDX_6E48ADC7E3C61F9 (owner_id), INDEX idx_book_lists_owner_type (owner_id, type), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_lists (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, type VARCHAR(20) NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(500) DEFAULT NULL, is_public TINYINT DEFAULT 1 NOT NULL, items_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, owner_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6E48ADCB5B48B91 (public_id), INDEX IDX_6E48ADC7E3C61F9 (owner_id), INDEX idx_book_lists_owner_type (owner_id, type), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.946119+00:00] doctrine.DEBUG: Executing query: CREATE TABLE books (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, title VARCHAR(255) NOT NULL, subtitle VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, original_title VARCHAR(255) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_4A1B2A92F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_4A1B2A9279FDCE08 (google_books_id), UNIQUE INDEX UNIQ_4A1B2A92B5B48B91 (public_id), INDEX idx_books_isbn13 (isbn_13), INDEX idx_books_isbn10 (isbn_10), INDEX idx_books_title (title), INDEX idx_books_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE books (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, title VARCHAR(255) NOT NULL, subtitle VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, original_title VARCHAR(255) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_4A1B2A92F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_4A1B2A9279FDCE08 (google_books_id), UNIQUE INDEX UNIQ_4A1B2A92B5B48B91 (public_id), INDEX idx_books_isbn13 (isbn_13), INDEX idx_books_isbn10 (isbn_10), INDEX idx_books_title (title), INDEX idx_books_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.954205+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_authors (book_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, INDEX IDX_1D2C02C716A2B381 (book_id), INDEX IDX_1D2C02C7F675F31B (author_id), PRIMARY KEY (book_id, author_id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_authors (book_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, INDEX IDX_1D2C02C716A2B381 (book_id), INDEX IDX_1D2C02C7F675F31B (author_id), PRIMARY KEY (book_id, author_id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.958777+00:00] doctrine.DEBUG: Executing query: CREATE TABLE book_genres (book_id BIGINT UNSIGNED NOT NULL, genre_id INT UNSIGNED NOT NULL, INDEX IDX_813CEE9B16A2B381 (book_id), INDEX IDX_813CEE9B4296D31F (genre_id), PRIMARY KEY (book_id, genre_id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE book_genres (book_id BIGINT UNSIGNED NOT NULL, genre_id INT UNSIGNED NOT NULL, INDEX IDX_813CEE9B16A2B381 (book_id), INDEX IDX_813CEE9B4296D31F (genre_id), PRIMARY KEY (book_id, genre_id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.962618+00:00] doctrine.DEBUG: Executing query: CREATE TABLE follows (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, follower_id BIGINT UNSIGNED NOT NULL, followed_id BIGINT UNSIGNED NOT NULL, INDEX IDX_4B638A73AC24F853 (follower_id), INDEX IDX_4B638A73D956F010 (followed_id), INDEX idx_follows_followed_created (followed_id, created_at), UNIQUE INDEX uniq_follows_follower_followed (follower_id, followed_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE follows (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, follower_id BIGINT UNSIGNED NOT NULL, followed_id BIGINT UNSIGNED NOT NULL, INDEX IDX_4B638A73AC24F853 (follower_id), INDEX IDX_4B638A73D956F010 (followed_id), INDEX idx_follows_followed_created (followed_id, created_at), UNIQUE INDEX uniq_follows_follower_followed (follower_id, followed_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.968054+00:00] doctrine.DEBUG: Executing query: CREATE TABLE genres (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(80) NOT NULL, slug VARCHAR(80) NOT NULL, description VARCHAR(255) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_A8EBE5165E237E06 (name), UNIQUE INDEX UNIQ_A8EBE516989D9B62 (slug), UNIQUE INDEX UNIQ_A8EBE516B5B48B91 (public_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE genres (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(80) NOT NULL, slug VARCHAR(80) NOT NULL, description VARCHAR(255) DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_A8EBE5165E237E06 (name), UNIQUE INDEX UNIQ_A8EBE516989D9B62 (slug), UNIQUE INDEX UNIQ_A8EBE516B5B48B91 (public_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.972349+00:00] doctrine.DEBUG: Executing query: CREATE TABLE ratings (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, score NUMERIC(2, 1) NOT NULL, read_at DATE DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_CEB607C9B5B48B91 (public_id), INDEX IDX_CEB607C9A76ED395 (user_id), INDEX IDX_CEB607C916A2B381 (book_id), INDEX idx_ratings_book_score (book_id, score), INDEX idx_ratings_user_created (user_id, created_at), UNIQUE INDEX uniq_ratings_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE ratings (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, score NUMERIC(2, 1) NOT NULL, read_at DATE DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_CEB607C9B5B48B91 (public_id), INDEX IDX_CEB607C9A76ED395 (user_id), INDEX IDX_CEB607C916A2B381 (book_id), INDEX idx_ratings_book_score (book_id, score), INDEX idx_ratings_user_created (user_id, created_at), UNIQUE INDEX uniq_ratings_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.978398+00:00] doctrine.DEBUG: Executing query: CREATE TABLE review_comments (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_7CDC1F21B5B48B91 (public_id), INDEX IDX_7CDC1F213E2E969B (review_id), INDEX IDX_7CDC1F21F675F31B (author_id), INDEX idx_review_comments_review_created (review_id, created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE review_comments (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_7CDC1F21B5B48B91 (public_id), INDEX IDX_7CDC1F213E2E969B (review_id), INDEX IDX_7CDC1F21F675F31B (author_id), INDEX idx_review_comments_review_created (review_id, created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.989781+00:00] doctrine.DEBUG: Executing query: CREATE TABLE review_likes (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, INDEX IDX_5A4462663E2E969B (review_id), INDEX IDX_5A446266A76ED395 (user_id), INDEX idx_review_likes_user_created (user_id, created_at), UNIQUE INDEX uniq_review_likes_review_user (review_id, user_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE review_likes (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, review_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, INDEX IDX_5A4462663E2E969B (review_id), INDEX IDX_5A446266A76ED395 (user_id), INDEX idx_review_likes_user_created (user_id, created_at), UNIQUE INDEX uniq_review_likes_review_user (review_id, user_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:45.996186+00:00] doctrine.DEBUG: Executing query: CREATE TABLE reviews (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, contains_spoilers TINYINT DEFAULT 0 NOT NULL, likes_count INT UNSIGNED DEFAULT 0 NOT NULL, comments_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, rating_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6970EB0FB5B48B91 (public_id), UNIQUE INDEX UNIQ_6970EB0FA32EFC6 (rating_id), INDEX idx_reviews_created (created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE reviews (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, contains_spoilers TINYINT DEFAULT 0 NOT NULL, likes_count INT UNSIGNED DEFAULT 0 NOT NULL, comments_count INT UNSIGNED DEFAULT 0 NOT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, rating_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_6970EB0FB5B48B91 (public_id), UNIQUE INDEX UNIQ_6970EB0FA32EFC6 (rating_id), INDEX idx_reviews_created (created_at), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.001857+00:00] doctrine.DEBUG: Executing query: CREATE TABLE users (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, username VARCHAR(30) NOT NULL, password VARCHAR(255) NOT NULL, display_name VARCHAR(60) DEFAULT NULL, bio LONGTEXT DEFAULT NULL, avatar_path VARCHAR(255) DEFAULT NULL, roles JSON NOT NULL, email_verified_at DATETIME DEFAULT NULL, last_login_at DATETIME DEFAULT NULL, is_active TINYINT DEFAULT 1 NOT NULL, locale VARCHAR(5) DEFAULT 'fr' NOT NULL, deleted_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_1483A5E9B5B48B91 (public_id), INDEX idx_users_active (is_active, deleted_at), UNIQUE INDEX uniq_users_email (email), UNIQUE INDEX uniq_users_username (username), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE users (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, username VARCHAR(30) NOT NULL, password VARCHAR(255) NOT NULL, display_name VARCHAR(60) DEFAULT NULL, bio LONGTEXT DEFAULT NULL, avatar_path VARCHAR(255) DEFAULT NULL, roles JSON NOT NULL, email_verified_at DATETIME DEFAULT NULL, last_login_at DATETIME DEFAULT NULL, is_active TINYINT DEFAULT 1 NOT NULL, locale VARCHAR(5) DEFAULT 'fr' NOT NULL, deleted_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_1483A5E9B5B48B91 (public_id), INDEX idx_users_active (is_active, deleted_at), UNIQUE INDEX uniq_users_email (email), UNIQUE INDEX uniq_users_username (username), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.007906+00:00] doctrine.DEBUG: Executing query: CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0E3BD61CE16BA31DBBF396750 (queue_name, available_at, delivered_at, id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0E3BD61CE16BA31DBBF396750 (queue_name, available_at, delivered_at, id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.012951+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD3DAE168B FOREIGN KEY (list_id) REFERENCES book_lists (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD3DAE168B FOREIGN KEY (list_id) REFERENCES book_lists (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.049522+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_list_items ADD CONSTRAINT FK_A72037FD16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.072176+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_lists ADD CONSTRAINT FK_6E48ADC7E3C61F9 FOREIGN KEY (owner_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_lists ADD CONSTRAINT FK_6E48ADC7E3C61F9 FOREIGN KEY (owner_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.093940+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C716A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C716A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.107658+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C7F675F31B FOREIGN KEY (author_id) REFERENCES authors (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_authors ADD CONSTRAINT FK_1D2C02C7F675F31B FOREIGN KEY (author_id) REFERENCES authors (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.120507+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B16A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.134556+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B4296D31F FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE CASCADE {"sql":"ALTER TABLE book_genres ADD CONSTRAINT FK_813CEE9B4296D31F FOREIGN KEY (genre_id) REFERENCES genres (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.148345+00:00] doctrine.DEBUG: Executing query: ALTER TABLE follows ADD CONSTRAINT FK_4B638A73AC24F853 FOREIGN KEY (follower_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE follows ADD CONSTRAINT FK_4B638A73AC24F853 FOREIGN KEY (follower_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.170834+00:00] doctrine.DEBUG: Executing query: ALTER TABLE follows ADD CONSTRAINT FK_4B638A73D956F010 FOREIGN KEY (followed_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE follows ADD CONSTRAINT FK_4B638A73D956F010 FOREIGN KEY (followed_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.184401+00:00] doctrine.DEBUG: Executing query: ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C9A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C9A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.199796+00:00] doctrine.DEBUG: Executing query: ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C916A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE ratings ADD CONSTRAINT FK_CEB607C916A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.212282+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F213E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F213E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.226771+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F21F675F31B FOREIGN KEY (author_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_comments ADD CONSTRAINT FK_7CDC1F21F675F31B FOREIGN KEY (author_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.240698+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_likes ADD CONSTRAINT FK_5A4462663E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_likes ADD CONSTRAINT FK_5A4462663E2E969B FOREIGN KEY (review_id) REFERENCES reviews (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.254256+00:00] doctrine.DEBUG: Executing query: ALTER TABLE review_likes ADD CONSTRAINT FK_5A446266A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE review_likes ADD CONSTRAINT FK_5A446266A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.265108+00:00] doctrine.DEBUG: Executing query: ALTER TABLE reviews ADD CONSTRAINT FK_6970EB0FA32EFC6 FOREIGN KEY (rating_id) REFERENCES ratings (id) ON DELETE CASCADE {"sql":"ALTER TABLE reviews ADD CONSTRAINT FK_6970EB0FA32EFC6 FOREIGN KEY (rating_id) REFERENCES ratings (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.294006+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260511153433","2":"2026-09-17 12:03:45","3":353}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260511153433","2":"2026-09-17 12:03:45","3":353},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:46.307881+00:00] deprecation.INFO: User Deprecated: Context: trying to commit a transaction Problem: the transaction is already committed, relying on silencing is deprecated. Solution: override `AbstractMigration::isTransactional()` so that it returns false. Automate that by setting `transactional` to false in the configuration. More details at https://www.doctrine-project.org/projects/doctrine-migrations/en/stable/explanation/implicit-commits.html (TransactionHelper.php:20 called by DbalExecutor.php:193, https://github.com/doctrine/migrations/issues/1169, package doctrine/migrations) {"exception":"[object] (ErrorException(code: 0): User Deprecated: Context: trying to commit a transaction\nProblem: the transaction is already committed, relying on silencing is deprecated.\nSolution: override `AbstractMigration::isTransactional()` so that it returns false.\nAutomate that by setting `transactional` to false in the configuration.\nMore details at https://www.doctrine-project.org/projects/doctrine-migrations/en/stable/explanation/implicit-commits.html (TransactionHelper.php:20 called by DbalExecutor.php:193, https://github.com/doctrine/migrations/issues/1169, package doctrine/migrations) at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/deprecations/src/Deprecation.php:208)"} [] [2026-09-17T12:03:46.308017+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_2 {"sql":"SAVEPOINT DOCTRINE_2"} [] [2026-09-17T12:03:46.308301+00:00] doctrine.DEBUG: Executing query: ALTER TABLE book_lists CHANGE is_public is_public TINYINT DEFAULT 0 NOT NULL {"sql":"ALTER TABLE book_lists CHANGE is_public is_public TINYINT DEFAULT 0 NOT NULL"} [] [2026-09-17T12:03:46.315602+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260512121001","2":"2026-09-17 12:03:46","3":7}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260512121001","2":"2026-09-17 12:03:46","3":7},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:46.315955+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_3 {"sql":"SAVEPOINT DOCTRINE_3"} [] [2026-09-17T12:03:46.316098+00:00] doctrine.DEBUG: Executing query: CREATE TABLE user_favorites (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_E489ED11A76ED395 (user_id), INDEX IDX_E489ED1116A2B381 (book_id), INDEX idx_user_favorites_user_created (user_id, created_at), UNIQUE INDEX uniq_user_favorites_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE user_favorites (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id BIGINT UNSIGNED NOT NULL, book_id BIGINT UNSIGNED NOT NULL, INDEX IDX_E489ED11A76ED395 (user_id), INDEX IDX_E489ED1116A2B381 (book_id), INDEX idx_user_favorites_user_created (user_id, created_at), UNIQUE INDEX uniq_user_favorites_user_book (user_id, book_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.319200+00:00] doctrine.DEBUG: Executing query: ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED11A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE {"sql":"ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED11A76ED395 FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.334455+00:00] doctrine.DEBUG: Executing query: ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED1116A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE {"sql":"ALTER TABLE user_favorites ADD CONSTRAINT FK_E489ED1116A2B381 FOREIGN KEY (book_id) REFERENCES books (id) ON DELETE CASCADE"} [] [2026-09-17T12:03:46.350191+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260513121159","2":"2026-09-17 12:03:46","3":34}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260513121159","2":"2026-09-17 12:03:46","3":34},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:46.350555+00:00] doctrine.DEBUG: Executing statement: SAVEPOINT DOCTRINE_4 {"sql":"SAVEPOINT DOCTRINE_4"} [] [2026-09-17T12:03:46.350698+00:00] doctrine.DEBUG: Executing query: ALTER TABLE reviews ADD is_pinned TINYINT DEFAULT 0 NOT NULL {"sql":"ALTER TABLE reviews ADD is_pinned TINYINT DEFAULT 0 NOT NULL"} [] [2026-09-17T12:03:46.365447+00:00] doctrine.DEBUG: Executing query: ALTER TABLE users ADD pinned_quote VARCHAR(280) DEFAULT NULL {"sql":"ALTER TABLE users ADD pinned_quote VARCHAR(280) DEFAULT NULL"} [] [2026-09-17T12:03:46.381857+00:00] doctrine.DEBUG: Executing statement: INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?) (parameters: array{"1":"DoctrineMigrations\\Version20260513123915","2":"2026-09-17 12:03:46","3":31}, types: array{"1":0,"2":0,"3":0}) {"sql":"INSERT INTO doctrine_migration_versions (version, executed_at, execution_time) VALUES (?, ?, ?)","params":{"1":"DoctrineMigrations\\Version20260513123915","2":"2026-09-17 12:03:46","3":31},"types":{"1":{"Doctrine\\DBAL\\ParameterType":0},"2":{"Doctrine\\DBAL\\ParameterType":0},"3":{"Doctrine\\DBAL\\ParameterType":0}}} [] [2026-09-17T12:03:46.382352+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 0 {"sql":"SET FOREIGN_KEY_CHECKS = 0"} [] [2026-09-17T12:03:46.382484+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_list_items {"sql":"TRUNCATE TABLE book_list_items"} [] [2026-09-17T12:03:46.383220+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE ratings {"sql":"TRUNCATE TABLE ratings"} [] [2026-09-17T12:03:46.384123+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE reviews {"sql":"TRUNCATE TABLE reviews"} [] [2026-09-17T12:03:46.384819+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_authors {"sql":"TRUNCATE TABLE book_authors"} [] [2026-09-17T12:03:46.385336+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE book_genres {"sql":"TRUNCATE TABLE book_genres"} [] [2026-09-17T12:03:46.385882+00:00] doctrine.DEBUG: Executing query: TRUNCATE TABLE books {"sql":"TRUNCATE TABLE books"} [] [2026-09-17T12:03:46.386708+00:00] doctrine.DEBUG: Executing query: SET FOREIGN_KEY_CHECKS = 1 {"sql":"SET FOREIGN_KEY_CHECKS = 1"} [] [2026-09-17T12:03:46.386828+00:00] doctrine.DEBUG: Executing query: CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE editions (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_id VARCHAR(50) DEFAULT NULL, google_books_id VARCHAR(50) DEFAULT NULL, isbn_10 VARCHAR(10) DEFAULT NULL, isbn_13 VARCHAR(13) DEFAULT NULL, subtitle VARCHAR(255) DEFAULT NULL, published_year SMALLINT UNSIGNED DEFAULT NULL, language VARCHAR(5) DEFAULT NULL, page_count INT UNSIGNED DEFAULT NULL, cover_url VARCHAR(500) DEFAULT NULL, publisher VARCHAR(150) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, work_id BIGINT UNSIGNED NOT NULL, UNIQUE INDEX UNIQ_96AE53E6F5CE0C4 (open_library_id), UNIQUE INDEX UNIQ_96AE53E679FDCE08 (google_books_id), UNIQUE INDEX UNIQ_96AE53E6B5B48B91 (public_id), INDEX idx_editions_isbn13 (isbn_13), INDEX idx_editions_isbn10 (isbn_10), INDEX idx_editions_work (work_id), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.391078+00:00] doctrine.DEBUG: Executing query: CREATE TABLE works (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_work_id VARCHAR(50) DEFAULT NULL, canonical_key VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, original_title VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, first_published_year SMALLINT UNSIGNED DEFAULT NULL, original_language VARCHAR(5) DEFAULT NULL, default_cover_url VARCHAR(500) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_F6E5024345E5FBFA (open_library_work_id), UNIQUE INDEX UNIQ_F6E50243B57AAE94 (canonical_key), UNIQUE INDEX UNIQ_F6E50243B5B48B91 (public_id), INDEX idx_works_title (title), INDEX idx_works_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 {"sql":"CREATE TABLE works (id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, open_library_work_id VARCHAR(50) DEFAULT NULL, canonical_key VARCHAR(255) DEFAULT NULL, title VARCHAR(255) NOT NULL, original_title VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, first_published_year SMALLINT UNSIGNED DEFAULT NULL, original_language VARCHAR(5) DEFAULT NULL, default_cover_url VARCHAR(500) DEFAULT NULL, ratings_count INT UNSIGNED DEFAULT 0 NOT NULL, ratings_avg NUMERIC(3, 2) DEFAULT NULL, last_synced_at DATETIME DEFAULT NULL, public_id BINARY(16) NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, UNIQUE INDEX UNIQ_F6E5024345E5FBFA (open_library_work_id), UNIQUE INDEX UNIQ_F6E50243B57AAE94 (canonical_key), UNIQUE INDEX UNIQ_F6E50243B5B48B91 (public_id), INDEX idx_works_title (title), INDEX idx_works_rank (ratings_avg, ratings_count), PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4"} [] [2026-09-17T12:03:46.400409+00:00] console.CRITICAL: Error thrown while running command "doctrine:migrations:migrate --env=test --no-interaction". Message: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000" {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1071): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:102)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1071): SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000 at C:/Users/rgalo/Dropbox/_LIVRECOMMENT/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)","command":"doctrine:migrations:migrate --env=test --no-interaction","message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 La clé est trop longue. Longueur maximale: 1000"} [] [2026-09-17T12:03:46.404995+00:00] console.DEBUG: Command "doctrine:migrations:migrate --env=test --no-interaction" exited with code "1071" {"command":"doctrine:migrations:migrate --env=test --no-interaction","code":1071} []