First time here? Check out the FAQ!
1

Cron job error

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.
Evgeny's avatar
13.2k
Evgeny
updated 2010-12-05 22:30:37 -0600
graeme's avatar
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's avatar 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's avatar 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's avatar Evgeny (2010-11-15 20:17:38 -0600) edit
Thanks, yet again.
graeme's avatar graeme (2010-11-15 22:48:26 -0600) edit
add a comment see more comments

2 Answers

1

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
graeme's avatar
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's avatar Evgeny (2010-11-19 19:39:40 -0600) edit
looking into the FB issue now.
Evgeny's avatar 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's avatar graeme (2010-11-19 19:48:20 -0600) edit
add a comment see more comments
1

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.

Evgeny's avatar
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's avatar graeme (2010-12-06 06:18:33 -0600) edit
add a comment see more comments