jsha / blocktogether

Share your blocks and subscribe to others'
GNU General Public License v3.0
330 stars 68 forks source link

[vagrant] provisioning fails during Sequelize #213

Closed dunn closed 8 years ago

dunn commented 8 years ago

Guessing this occurred with 321a0208e4d5d4f94c982ebceff5772c1c3838fb: https://gist.github.com/dunn/24769db6b1f6272cb8e4#file-vagrant-up-L628-L645

==> default: { [SequelizeDatabaseError: ER_KEY_COLUMN_DOES_NOT_EXITS: Key column 'status' doesn't exist in table]
==> default:   name: 'SequelizeDatabaseError',
==> default:   message: 'ER_KEY_COLUMN_DOES_NOT_EXITS: Key column \'status\' doesn\'t exist in table',
==> default:   parent:
==> default:    { [Error: ER_KEY_COLUMN_DOES_NOT_EXITS: Key column 'status' doesn't exist in table]
==> default:      code: 'ER_KEY_COLUMN_DOES_NOT_EXITS',
==> default:      errno: 1072,
==> default:      sqlState: '42000',
==> default:      index: 0,
==> default:      sql: 'CREATE TABLE `Actions` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `source_uid` BIGINT UNSIGNED NOT NULL,\n  `sink_uid` BIGINT UNSIGNED NOT NULL,\n  `typeNum` TINYINT(1) NOT NULL,\n  `statusNum` TINYINT(1) NOT NULL,\n  `createdAt` datetime NOT NULL,\n  `updatedAt` datetime NOT NULL,\n  `causeNum` TINYINT(1) NOT NULL,\n  `cause_uid` BIGINT UNSIGNED,\n  PRIMARY KEY (`id`),\n  KEY `actions_source_uid_sink_uid` (`source_uid`,`sink_uid`),\n  KEY `actions_source_uid_status_created_at` (`source_uid`,`status`,`createdAt`)\n) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' },
==> default:   original:
==> default:    { [Error: ER_KEY_COLUMN_DOES_NOT_EXITS: Key column 'status' doesn't exist in table]
==> default:      code: 'ER_KEY_COLUMN_DOES_NOT_EXITS',
==> default:      errno: 1072,
==> default:      sqlState: '42000',
==> default:      index: 0,
==> default:      sql: 'CREATE TABLE `Actions` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `source_uid` BIGINT UNSIGNED NOT NULL,\n  `sink_uid` BIGINT UNSIGNED NOT NULL,\n  `typeNum` TINYINT(1) NOT NULL,\n  `statusNum` TINYINT(1) NOT NULL,\n  `createdAt` datetime NOT NULL,\n  `updatedAt` datetime NOT NULL,\n  `causeNum` TINYINT(1) NOT NULL,\n  `cause_uid` BIGINT UNSIGNED,\n  PRIMARY KEY (`id`),\n  KEY `actions_source_uid_sink_uid` (`source_uid`,`sink_uid`),\n  KEY `actions_source_uid_status_created_at` (`source_uid`,`status`,`createdAt`)\n) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' },
==> default:   sql: 'CREATE TABLE `Actions` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `source_uid` BIGINT UNSIGNED NOT NULL,\n  `sink_uid` BIGINT UNSIGNED NOT NULL,\n  `typeNum` TINYINT(1) NOT NULL,\n  `statusNum` TINYINT(1) NOT NULL,\n  `createdAt` datetime NOT NULL,\n  `updatedAt` datetime NOT NULL,\n  `causeNum` TINYINT(1) NOT NULL,\n  `cause_uid` BIGINT UNSIGNED,\n  PRIMARY KEY (`id`),\n  KEY `actions_source_uid_sink_uid` (`source_uid`,`sink_uid`),\n  KEY `actions_source_uid_status_created_at` (`source_uid`,`status`,`createdAt`)\n) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' }
jsha commented 8 years ago

Thanks! Pushed a fix. Try now?

dunn commented 8 years ago

Yes, thanks!