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.
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.
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
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.create your Q&A site
Asked: 2010-11-14 22:42:49 -0500
Seen: 109 times
Last updated: Dec 06 '10