yii2-image-manager icon indicating copy to clipboard operation
yii2-image-manager copied to clipboard

for postgresql migration does not applied

Open bemulima opened this issue 6 years ago • 0 comments

> create table {{%ImageManager}} ... done (time: 0.009s)
> alter column id in table {{%ImageManager}} to INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ...Exception 'yii\db\Exception' with message 'SQLSTATE[42601]: Syntax error: 7 ОШИБКА:  ошибка синтаксиса (примерное положение: "(")

LINE 1: ...ER TABLE "ImageManager" ALTER COLUMN "id" TYPE INT(10) UNSIG... ^ The SQL being executed was: ALTER TABLE "ImageManager" ALTER COLUMN "id" TYPE INT(10) UNSIGNED NOT NULL AUTO_INCREMENT'

in C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\db\Schema.php:664

Error Info: Array ( [0] => 42601 [1] => 7 [2] => ОШИБКА: ошибка синтаксиса (примерное положение: "(") LINE 1: ...ER TABLE "ImageManager" ALTER COLUMN "id" TYPE INT(10) UNSIG... ^ )

Stack trace: #0 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\db\Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'ALTER TABLE "Im...') #1 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\db\Command.php(1091): yii\db\Command->internalExecute('ALTER TABLE "Im...') #2 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\db\Migration.php(420): yii\db\Command->execute() #3 C:\OSPanel\domains\ad.loc\vendor\noam148\yii2-image-manager\migrations\m160622_085710_create_ImageManager_table.php(25): yii\db\Migration->alterColumn('{{%ImageManager...', 'id', 'INT(10) UNSIGNE...') #4 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(725): m160622_085710_create_ImageManager_table->up() #5 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\console\controllers\BaseMigrateController.php(199): yii\console\controllers\BaseMigrateController->migrateUp('m160622_085710_...') #6 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0) #7 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #8 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\base\Controller.php(157): yii\base\InlineAction->runWithParams(Array) #9 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\console\Controller.php(148): yii\base\Controller->runAction('', Array) #10 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\base\Module.php(528): yii\console\Controller->runAction('', Array) #11 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\console\Application.php(180): yii\base\Module->runAction('migrate', Array) #12 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\console\Application.php(147): yii\console\Application->runAction('migrate', Array) #13 C:\OSPanel\domains\ad.loc\vendor\yiisoft\yii2\base\Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request)) #14 C:\OSPanel\domains\ad.loc\console\yii(26): yii\base\Application->run() #15 {main}

bemulima avatar Mar 20 '19 06:03 bemulima