getting error while searching for questions from home page
I am evaluating askbot for use in an internal Q&A site for my team. I've got everything installed thought I was pretty much there until this. I am running django 1.3.1 and postgres 9.1.3. At first I got migration errors with ./manage.py migrate askbot. thank to http://askbot.org/en/question/6902/error-while-setting-up-askbot, I was able to get past those errors by running;
python manage.py syncdb --all
python manage.py migrate --all --fake
I can now sign in and ask questions. The problem is with searching for questions. I get this message (after putting django in debug mode). Any help getting past this is much appreciated. Here's the error:
DatabaseError at /questions/scope:all/sort:relevance-desc/query:ascii/author:1/page:1/
column askbot_thread.text_search_vector does not exist
LINE 1: ...estion' AND "askbot_post"."deleted" = false AND askbot_thr...
^
Request Method: GET
Request URL: http://127.0.0.1:8000/questions/scope:all/sort:relevance-desc/query:ascii/author:1/page:1/
Django Version: 1.3.1
Exception Type: DatabaseError
Exception Value:
column askbot_thread.text_search_vector does not exist
LINE 1: ...estion' AND "askbot_post"."deleted" = false AND askbot_thr...
^
Exception Location: /usr/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py in execute, line 44
Python Executable: /usr/bin/python
Python Version: 2.7.2
Python Path:
['/home/markf/Programs/askbot_site',
'/usr/lib/python2.7/site-packages/pip-1.1-py2.7.egg',
'/usr/lib/python2.7/site-packages/distribute-0.6.25-py2.7.egg',
'/usr/lib/python2.7/site-packages/askbot-0.7.40-py2.7.egg',
'/usr/lib/python2.7/site-packages/lamson-1.1-py2.7.egg',
'/usr/lib/python2.7/site-packages/html5lib-0.90-py2.7.egg',
'/usr/lib/python2.7/site-packages/python_daemon-1.6-py2.7.egg',
'/usr/lib/python2.7/site-packages/mock-1.0.0alpha1-py2.7.egg',
'/usr/lib/python2.7/site-packages/lockfile-0.9.1-py2.7.egg',
'/usr/lib/python27.zip',
'/usr/lib/python2.7',
'/usr/lib/python2.7/plat-linux2',
'/usr/lib/python2.7/lib-tk',
'/usr/lib/python2.7/lib-old',
'/usr/lib/python2.7/lib-dynload',
'/usr/lib/python2.7/site-packages',
'/usr/lib/python2.7/site-packages/PIL',
'/usr/lib/python2.7/site-packages/gst-0.10',
'/usr/lib/python2.7/site-packages/gtk-2.0',
'/usr/lib/python2.7/site-packages/wx-2.8-gtk2-unicode',
'/usr/lib/python2.7/site-packages/askbot-0.7.40-py2.7.egg/askbot/deps']
Server time: Fri, 6 Apr 2012 12:44:55 -0500
Comments
We have not tested askbot with postgres 9 yet, if there are more issues - please let us know. Most likely issues could be with the search function.