`expertise update` fail: robocoup probably thinks I don't exist

bocoup / bots

Our bots.

8 stars 8 forks source link

`expertise update` fail: robocoup probably thinks I don't exist #145

Closed lyzadanger closed 8 years ago

lyzadanger commented 8 years ago

After what (I presume is) the last step of the update for a skill:

An error occurred: `INSERT INTO employee_expertise (
 employee_id,
 expertise_id,
 experience_rating,
 interest_rating,
 notes
) VALUES (
 (SELECT id FROM employee WHERE slack=$1),
 $2,
 $3,
 $4,
 $5
)
- null value in column "employee_id" violates not-null constraint`

Background:

This is the first entry I've tried to make
If it matters (I doubt it), the skill I was adding was WordPress

cowboy commented 8 years ago

I'd imagine this isn't working because your slackname is lyzadanger but the value in the Bocoup database is lyza. @tkellen, can you confirm?

tkellen commented 8 years ago

Indeed it is. I've fixed this over at http://db.bocoup.com. Thanks for the sanity check @cowboy.