Upgrade to 1.21.0 fails

Describe the bug Upgrade to v1.21.0 failed

Are you using the Docker image?

Database used

PostgreSQL

Webserver used (when not using docker)

Nginx

Database version used 15.8

Error Messages

[notice] Migrating up to DoctrineMigrations\Version20241013152649
[notice] ALTER TABLE users ADD first_name VARCHAR(255) DEFAULT NULL 
[notice] Query took 3.2ms
[notice] ALTER TABLE users ADD last_name VARCHAR(255) DEFAULT NULL 
[notice] Query took 3.9ms
[notice] CREATE TABLE reset_password_request (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, expires_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, user_id INT NOT NULL, PRIMARY KEY(id)) 
[notice] Query took 10.1ms
[notice] CREATE INDEX IDX_7CE748AA76ED395 ON reset_password_request (user_id) 
[notice] Query took 11.1ms
[notice] ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES users (id) NOT DEFERRABLE INITIALLY IMMEDIATE 
[notice] Query took 12.7ms
[notice] ALTER TABLE logs ADD state INT NOT NULL 
[error] Migration DoctrineMigrations\Version20240929171054 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[23502]: Not null violation: 7 ERROR:  column "state" of relation "logs" contains null values"
[critical] Error thrown while running command "doctrine:migrations:migrate --no-interaction --query-time --all-or-nothing". Message: "An exception occurred while executing a query: SQLSTATE[23502]: Not null violation: 7 ERROR:  column "state" of relation "logs" contains null values"

In ExceptionConverter.php line 47:

  An exception occurred while executing a query: SQLSTATE[23502]: Not null v  
  iolation: 7 ERROR:  column "state" of relation "logs" contains null values  

In Exception.php line 28:

  SQLSTATE[23502]: Not null violation: 7 ERROR:  column "state" of relation   
  "logs" contains null values                                                 

In Connection.php line 57:

  SQLSTATE[23502]: Not null violation: 7 ERROR:  column "state" of relation   
  "logs" contains null values                                                 

doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--no-all-or-nothing] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]

Steps to Reproduce Please provide -detailed- steps to reproduce the problem:

Upgrade to 1.21.0

Expected behavior Keeps working

Additional context Error displayed when accessing web page:

Error

An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column t0.first_name does not exist LINE 1: ...d AS password_4, t0.is_verified AS is_verified_5, t0.first_n... ^

antedebaas / Viesti-Reports

Upgrade to 1.21.0 fails #164