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

timewasted

asked 13 years ago, updated 13 years ago

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.

Evgeny (13 years ago)

see more comments

After the migrate --all --fake run management command:

python manage.py init_postgresql_full_text_search

I would not use the migrate --all --fake method if this alone works:

python manage.py syncdb --migrate --noinput

The command above is equivalent to the two commands below.

python manage.py syncdb --noinput
python manage.py migrate

13.2k

Evgeny

answered 13 years ago

link

Comments

Thank you. I will try this when I am back in the office on Monday and post back my results.

timewasted (13 years ago)

Thank you very, very much. That seems to have done the trick.

timewasted (13 years ago)

see more comments

getting error while searching for questions from home page savecancel

Comments

1 Answer

Comments

getting error while searching for questions from home page