[GH-ISSUE #311] PostgreSQL: Initial setup of database leads to an error #251

New issue

Open

opened 2026-02-26 09:37:06 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 09:37:06 +03:00

Owner

Originally created by @frlan on GitHub (Mar 23, 2024).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/311

$ bin/doctrine2-cli.php orm:schema-tool:create

 !                                                                                               
 ! [CAUTION] This operation should not be executed in a production environment!                  
 !                                                                                               

 Creating database schema...


In ToolsException.php line 35:
                                                                                                
  Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE dbversion  
   (id INT NOT NULL, version INT NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0)  
   WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))':                                               
                                                                                                
  SQLSTATE[42P07]: Duplicate table: 7 FEHLER:  Relation »dbversion« existiert bereits' while e  
  xecuting DDL: CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(25  
  5) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))             
                                                                                                

In AbstractPostgreSQLDriver.php line 85:
                                                                                                
  An exception occurred while executing 'CREATE TABLE dbversion (id INT NOT NULL, version INT   
  NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PR  
  IMARY KEY(id))':                                                                              
                                                                                                
  SQLSTATE[42P07]: Duplicate table: 7 FEHLER:  Relation »dbversion« existiert bereits

(Relation »dbversion« existiert bereits = Relation already exists)

Source from composer

Originally created by @frlan on GitHub (Mar 23, 2024). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/311 ``` $ bin/doctrine2-cli.php orm:schema-tool:create ! ! [CAUTION] This operation should not be executed in a production environment! ! Creating database schema... In ToolsException.php line 35: Schema-Tool failed with Error 'An exception occurred while executing 'CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))': SQLSTATE[42P07]: Duplicate table: 7 FEHLER: Relation »dbversion« existiert bereits' while e xecuting DDL: CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(25 5) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id)) In AbstractPostgreSQLDriver.php line 85: An exception occurred while executing 'CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PR IMARY KEY(id))': SQLSTATE[42P07]: Duplicate table: 7 FEHLER: Relation »dbversion« existiert bereits ``` (Relation »dbversion« existiert bereits = Relation already exists) Source from composer