search

18F / standup-slack-bot

A Slack bot to streamline team standup without disturbing the overall flow of conversation
https://standup-slack-bot.app.cloud.gov/
Other
87 stars 31 forks source link

Initial db migration complains of non-existent column #154

Open bkero opened 6 years ago

bkero commented 6 years ago

I am writing to set this bot up for my org, although run into a complication. Setup is done on out-of-the-box xenial with postgres 9.5.


> standup-bot@0.9.3 migrate /home/ubuntu/standup-slack-bot
> sequelize db:migrate --url $DATABASE_URL

Sequelize CLI [Node: 6.7.0, CLI: 3.0.0, ORM: 4.22.5]

WARNING: This version of Sequelize CLI is not fully compatible with Sequelize v4. https://github.com/sequelize/cli#sequelize-support

Parsed url postgres://ssb:*****@127.0.0.1/ssb
sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators node_modules/sequelize/lib/sequelize.js:236:13
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
File: .gitkeep does not match pattern: /\.js$/
== 20160315145654-create-model: migrating =======
== 20160315145654-create-model: migrated (0.211s)

== 20160415145654-add-audience: migrating =======
== 20160415145654-add-audience: migrated (0.111s)

== 20161026145654-add-days-of-week: migrating =======
== 20161026145654-add-days-of-week: migrated (0.335s)

== 20161221145654-migrate-to-local-times: migrating =======
[09 Nov 2017 18:43:30] 📢  verbose Channel model Initializing
[09 Nov 2017 18:43:30] 📢  verbose Standup model Initializing
Unhandled rejection SequelizeDatabaseError: column "postUpdatesInChannel" does not exist
    at Query.formatError (/home/ubuntu/standup-slack-bot/node_modules/sequelize/lib/dialects/postgres/query.js:356:16)
    at query.catch.err (/home/ubuntu/standup-slack-bot/node_modules/sequelize/lib/dialects/postgres/query.js:86:18)
    at tryCatcher (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/promise.js:512:31)
    at Promise._settlePromise (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/promise.js:569:18)
    at Promise._settlePromise0 (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/promise.js:614:10)
    at Promise._settlePromises (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/promise.js:689:18)
    at Async._drainQueue (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/async.js:133:16)
    at Async._drainQueues (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/async.js:143:10)
    at Immediate.Async.drainQueues (/home/ubuntu/standup-slack-bot/node_modules/bluebird/js/release/async.js:17:14)
    at runCallback (timers.js:574:20)
    at tryOnImmediate (timers.js:554:5)
    at processImmediate [as _immediateCallback] (timers.js:533:5)