Ask Your Question

getting error while searching for questions from home page

asked 2012-04-06 12:57:24 -0500

timewasted's avatar

updated 2012-04-06 12:57:57 -0500

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 ./ migrate askbot. thank to, I was able to get past those errors by running;

python syncdb --all
python 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:
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/ in execute, line 44
Python Executable:  /usr/bin/python
Python Version:     2.7.2
Python Path:    


Server time:    Fri, 6 Apr 2012 12:44:55 -0500
edit retag flag offensive close merge delete


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

1 Answer

Sort by ยป oldest newest most voted

answered 2012-04-06 13:25:10 -0500

Evgeny's avatar

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

python init_postgresql_full_text_search

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

python syncdb --migrate --noinput

The command above is equivalent to the two commands below.

python syncdb --noinput
python migrate
edit flag offensive delete link more


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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools



Asked: 2012-04-06 12:57:24 -0500

Seen: 756 times

Last updated: Apr 06 '12