graeme's profile - activity

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.

The user moderation options "suspended" and "blocked" are fairly obvious, as is the general point of "moderator", but I what do "watched user" and "approved" mean.

Does the skin settings in /settings/GENERAL_SKIN_SETTINGS/ (i.e. click on settings, then go to "skin and User Interface Settings") have any effect. It seems to have no effect as far as I can see. What does work is the ASKBOT_DEFAULT_SKIN setting in settings.py

When I try to use Google or Yahoo openid sign in I get this error.

I initially thought that it might be lack of ssl in python, but it appears (from a discussion of that problem on OSQA) that would stop Yahoo from working as well (and it works OK).

I know this is probably too little information to diagnose the problem with, but if anyone can give me suggestions on how to diagnose the problem it would help a lot.

Edited to add. I get a similar response (as shown in the url when I return to my site) to what I get from the same providers when I try logging into askbot.org with them.

I have debug = True, and the required authentication backend,

flickr gives a slightly different error: OpenID http://flickr.com/igraeme is invalid

Facebook gives the somewhat unhelp ful "There was some problem when connecting to Facebook..."

IN ALL cases I am able to login to the provider (if I am not already logged in there) and get directed back to my site.

The providers send back a response with res_id and a verified identity. The nonce matches the return to url,

The last question about skins (from August) I could find says that skins can only be loaded from the existing skins directory, and that it would be better to defer HTML customisation until the skins are re-written in Jinja2.

I notice that some things have changed: doing pip install askbot installed jinja2, so it is presumably now used, there is a skin setting in /settings, and the default settings.py has the following line:

os.path.join(os.path.dirname(__file__),'askbot','skins').replace('\\','/')

Does this all mean that we can more easily customise and do it in an askbot/settings directory?

I get the following error when doing manag.py migrate askbot

File "/home/graeme/iqapy/lib/python2.5/site-packages/askbot/management/commands/init_postgresql_full_text_search.py", line 19, in handle_noargs
cursor.execute("CREATE LANGUAGE plpgsql")
psycopg2.ProgrammingError: must be superuser to create procedural language

It appears that if the Facebook Javascript is blocked, it casues a Javascript error that prevents other login methods from working as well.

I get this if I visit this site (askbot.org) with FireFox with NoScript installed and facebook.net not allowed. None of the login methods work, and the error console shows an "FB not defined" error.

If I allow facebook.net in No Script everything works.

There is a script for a cron job in askbot/cron, but the install instructions no longer mention settings up cron jobs. Are they still needed or helpful?

If TEMPLATE_DIRS is set, Askbot will use a template from that directory. However jinja still gets the original include path (I guess jinga gets the template root and jinga include paths are always relative to the template root).

Extends is unpredictable. {% extends "user.html" %} in user_stats etc gets it from the directory specified in TEMPLATE_DIRS whereas {% extends "two_column_body.html" %} seems to get it from the original (at least edits to it do not show).

I realise that using TEMPLATE_DIRS is not the currently recommended way to customise, but it would be nice to have it working consistently: it almost does, and I am more comfortable with it as it lets me use pip install rather than git to install askbot on my server.