Cron job error

fixed
bug
badges
retag add tags

Newly reinstalled ASkbot install gives following error in cron job:

operator does not exist: boolean = integer
LINE 1: ...ype_id, object_id FROM activity WHERE is_auditted = 0 AND ac...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

operator does not exist: boolean = integer
LINE 1: ... q.vote_up_count >=3 AND                 act.is_auditted = 0
                                                                    ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

13.2k

Evgeny

updated 2010-12-05 22:30:37 -0600

319

graeme

asked 2010-11-14 22:42:49 -0600

edit flag offensive 0 remove flag close merge delete

Comments

One possible solution here: http://www.mail-archive.com/pgsql-general@postgresql.org/msg72327.html - although I have no idea of implications vs addings casts to queries. Surprised this has not affected anyone else it appears to be the default behaviour of PG 8.3+

graeme (2010-11-15 06:11:14 -0600) edit

I've made a release with some cosmetic changes in the badge system. The real problem is not solved yet, but at least some badges will be awarded and the jobs will not fail completely. Will need to have a separate coding session to fix the badges after I make the comments editable.

Evgeny (2010-11-15 15:39:14 -0600) edit

actually, I'll take it back, for postgres one more change will needed, will add it by tomorrow.

Evgeny (2010-11-15 20:17:38 -0600) edit

Thanks, yet again.

graeme (2010-11-15 22:48:26 -0600) edit

add a comment see more comments

2 Answers

Sort by

oldest

newest

most voted

OK finally fixed this. If you upgrade, those two badge cron jobs wont be necessary any more. Also - thresholds for the badges can be adjusted in the settings. There still are some issues with the badges to polish out, but hopefully no critical bugs. I've made at least one test case for each badge.

13.2k

Evgeny

updated 2010-12-06 00:35:38 -0600, answered 2010-12-06 00:14:01 -0600

edit flag offensive 0 remove flag delete link

Comments

Thanks yet again.

graeme (2010-12-06 06:18:33 -0600) edit

add a comment see more comments

Original problem seems OK, but I am now getting a different error. POsting as an answer because it will not fit in a comment:

multi_award_badges.py:handle_noargs:56 badge award error function datediff(timestamp with time zone, timestamp with time zone) does not exist
LINE 1: ...WHERE q.id = a.question_id AND                    DATEDIFF(a...
                                                         ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
in question_be_answered_after_60_days_and_be_voted_up_5

319

graeme

answered 2010-11-19 19:34:36 -0600

edit flag offensive 0 remove flag delete link

Comments

I know about this. Do you see this error in the console or the error log? The errors do happen because there are still bugs in the badge job, but some badges are now awarded. I'll try to get to fixing badges for real as soon as I can, possibly this weekend.

Evgeny (2010-11-19 19:39:40 -0600) edit

looking into the FB issue now.

Evgeny (2010-11-19 19:40:40 -0600) edit

The errors are in the error log. There is no output in the console. I am now seeing some badges awarded. Thank you very much for that - its not perfect, but it now looks to users.

graeme (2010-11-19 19:48:20 -0600) edit

add a comment see more comments

Cron job error edit

Comments

2 Answers

Comments

Comments

Cron job error