Cron job error

Question

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

graeme
317 ● 17 ● 5 ● 16
http://investmentqa.com/

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

Evgeny

11314 ● 50 ● 84 ● 183
http://askbot.org/

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.

Accepted Answer

answered 2010-12-06 00:14:01 -0500

Evgeny

11314 ● 50 ● 84 ● 183
http://askbot.org/

updated 2010-12-06 00:35:38 -0500

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.

Answer 2

1

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

graeme
317 ● 17 ● 5 ● 16
http://investmentqa.com/

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

link publish delete flag offensive edit

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 -0500 )edit

looking into the FB issue now. Evgeny ( 2010-11-19 19:40:40 -0500 )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 -0500 )edit

Cron job error

Comments

2 Answers

Comments

Comments

Your answer

Reliable Askbot Hosting

Question tools

Stats

Related questions