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

graeme

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 (14 years ago)

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 (14 years ago)

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

Evgeny (14 years ago)

Thanks, yet again.

graeme (14 years ago)

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 14 years ago, answered 14 years ago

link

Comments

Thanks yet again.

graeme (14 years ago)

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 14 years ago

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 (14 years ago)

looking into the FB issue now.

Evgeny (14 years ago)

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 (14 years ago)

see more comments

Cron job error savecancel

Comments

2 Answers

Comments

Comments

Cron job error