Define Help Functionality [Closes #66 #67]

Moniarchy commented 7 years ago

includes jrob's edits from last week
updated migrations: deleted command table and deleted content column in topic table
dropped user relation to help topics
cleaned up migrations and killed all instances of 'UserTopics'... So where is this sql query coming from?

Moniarchy commented 7 years ago

@jrob8577 HELP

rae-ralston commented 7 years ago

we're blocked on something we can't figure out (database is giving us an error that it can't find 'UserTopics', and it shouldn't be trying to find that table... UserTopics isn't mentioned anywhere in the whole project any more... It should be referencing 'UserTopic'

5:34:43 PM web.1 |  Executing (default): SELECT "UserId", "TopicId", "viewed", "createdAt", "updatedAt" FROM "UserTopics" AS "UserTopic" WHERE "UserTopic"."user_id" = 1 ORDER BY "UserTopic"."TopicId" ASC;
5:34:43 PM web.1 |  Unhandled rejection SequelizeDatabaseError: relation "UserTopics" does not exist
5:34:43 PM web.1 |      at Query.formatError (/Users/rachelralston/Desktop/coding/floworky/node_modules/sequelize/lib/dialects/postgres/query.js:357:14)
5:34:43 PM web.1 |      at .<anonymous> (/Users/rachelralston/Desktop/coding/floworky/node_modules/sequelize/lib/dialects/postgres/query.js:88:19)

Moniarchy commented 7 years ago

We tried this on both @rachel-ftw and my machines. Got the same error on mine, but we have been working on Rachel's computer all day.

Moniarchy commented 7 years ago

@jrob8577 We're working on squashing these commits but in the meantime can e get feedback on the code we've written?

jrob8577 commented 7 years ago

Closing, there's another PR that incorporates this work

GuildCrafts / floworky

Define Help Functionality [Closes #66 #67] #85