Ask Your Question
1

Cron job error

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

graeme gravatar image

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

Evgeny gravatar image

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.
edit retag flag offensive 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 gravatar imagegraeme ( 2010-11-15 06:11:14 -0500 )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 gravatar imageEvgeny ( 2010-11-15 15:39:14 -0500 )edit
actually, I'll take it back, for postgres one more change will needed, will add it by tomorrow.
Evgeny gravatar imageEvgeny ( 2010-11-15 20:17:38 -0500 )edit
Thanks, yet again.
graeme gravatar imagegraeme ( 2010-11-15 22:48:26 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted
1

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

Evgeny gravatar image

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.

edit flag offensive delete link more

Comments

Thanks yet again.
graeme gravatar imagegraeme ( 2010-12-06 06:18:33 -0500 )edit
1

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

graeme gravatar image

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
edit flag offensive delete link more

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

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

Seen: 222 times

Last updated: Dec 06 '10