First time here? Check out the FAQ!
1

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's avatar
83
timewasted
asked 2012-04-06 12:57:24 -0500, updated 2012-04-06 12:57:57 -0500
edit flag offensive 0 remove flag close merge delete

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's avatar Evgeny (2012-04-06 13:27:14 -0500) edit
add a comment see more comments

1 Answer

0

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
Evgeny's avatar
13.2k
Evgeny
answered 2012-04-06 13:25:10 -0500
edit flag offensive 0 remove flag delete link

Comments

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

timewasted's avatar timewasted (2012-04-07 18:39:06 -0500) edit

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

timewasted's avatar timewasted (2012-04-08 20:04:38 -0500) edit
add a comment see more comments