search

yii2mod / yii2-comments

Comments module for Yii2
MIT License
159 stars 64 forks source link

Fail migrate m161114_094902_add_url_column_to_comment_table #106

Open lav45 opened 3 years ago

lav45 commented 3 years ago

DB Postgresql 13

*** applying m161114_094902_add_url_column_to_comment_table
    > add column url text to table {{%comment}} ...Exception 'yii\db\Exception' with message 'SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "url" of relation "comment" already exists
The SQL being executed was: ALTER TABLE "comment" ADD "url" text'

in /var/www/vendor/yiisoft/yii2/db/Schema.php:678

Error Info:
Array
(
    [0] => 42701
    [1] => 7
    [2] => ERROR:  column "url" of relation "comment" already exists
)

Caused by: Exception 'PDOException' with message 'SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "url" of relation "comment" already exists'