Skip to content

Instantly share code, notes, and snippets.

@vdrnn
Created November 21, 2019 22:34
Show Gist options
  • Save vdrnn/8704ce70c164cdba14aa1cdee780eb7a to your computer and use it in GitHub Desktop.
Save vdrnn/8704ce70c164cdba14aa1cdee780eb7a to your computer and use it in GitHub Desktop.
Database Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sproutforms_integrations' already exists
The SQL being executed was: CREATE TABLE sproutforms_integrations (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
formId int(11) NOT NULL,
name varchar(255) NOT NULL,
type varchar(255) NOT NULL,
settings text,
enabled tinyint(1) DEFAULT FALSE,
dateCreated datetime NOT NULL,
dateUpdated datetime NOT NULL,
uid char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDb DEFAULT CHARSET=utf8
Migration: barrelstrength\sproutforms\migrations\m181120_000000_add_integrations_table
Output:
> create table {{%sproutforms_integrations}} ...Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sproutforms_integrations' already exists
The SQL being executed was: CREATE TABLE sproutforms_integrations (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
formId int(11) NOT NULL,
name varchar(255) NOT NULL,
type varchar(255) NOT NULL,
settings text,
enabled tinyint(1) DEFAULT FALSE,
dateCreated datetime NOT NULL,
dateUpdated datetime NOT NULL,
uid char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDb DEFAULT CHARSET=utf8 (/home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/db/Schema.php:664)
#0 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'CREATE TABLE s...')
#1 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/db/Command.php(1091): yii\db\Command->internalExecute('CREATE TABLE s...')
#2 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/db/Migration.php(323): yii\db\Command->execute()
#3 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/barrelstrength/sprout-forms/src/migrations/m181120_000000_add_integrations_table.php(26): yii\db\Migration->createTable('{{%sproutforms_...', Array)
#4 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/db/Migration.php(58): barrelstrength\sproutforms\migrations\m181120_000000_add_integrations_table->safeUp()
#5 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/db/MigrationManager.php(239): craft\db\Migration->up(true)
#6 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/db/MigrationManager.php(159): craft\db\MigrationManager->migrateUp(Object(barrelstrength\sproutforms\migrations\m181120_000000_add_integrations_table))
#7 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/services/Updates.php(225): craft\db\MigrationManager->up()
#8 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/controllers/BaseUpdaterController.php(521): craft\services\Updates->runMigrations(Array)
#9 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/controllers/UpdaterController.php(208): craft\controllers\BaseUpdaterController->runMigrations(Array, 'restore-db')
#10 [internal function]: craft\controllers\UpdaterController->actionMigrate()
#11 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#12 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#13 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('migrate', Array)
#14 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('migrate', Array)
#15 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/web/Application.php(299): yii\base\Module->runAction('updater/migrate', Array)
#16 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/web/Application.php(652): craft\web\Application->runAction('updater/migrate')
#17 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/craftcms/cms/src/web/Application.php(251): craft\web\Application->_processUpdateLogic(Object(craft\web\Request))
#18 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
#19 /home/vagrant/Projects/002_Y7K/ab01-hotel-arlberg/public/index.php(25): yii\base\Application->run()
#20 {main}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment