Badges plugin bug - upvote leads to "database error"

Question

Running MySQL 5.1, Apache 2.2, PHP 5.2, shared hosting.

Downloaded Dec 12th 2011 github.com version of Noah's badges plugin. When upvoting on a question, occasionally see the following error with javascript turned off:

---

Question2Answer query failed:

INSERT INTO qa_userbadges (awarded_at, notify, object_id, user_id, badge_slug, id) VALUES (NOW(), 1, 75, NULL, _utf8 'nice_answer', 0)

Error 1048: Column 'user_id' cannot be null

---

If javascript is on, for reference, the error says "A database error occurred." With phmyadmin, I can see that the qa_userbadges table exists.

I tried "Recreate badges" and "Recheck badge awarding" with box checked ("Remove all badges from database first"), but this didn't fix it.

Answer 1

Not sure what is wrong, but I've added a check that should stop it from trying to award badges without userid.  Try with latest code.