Ask Your Question
1

getting error while searching for questions from home page

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

timewasted gravatar image

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 ./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
edit retag flag offensive 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 gravatar imageEvgeny ( 2012-04-06 13:27:14 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Evgeny gravatar image

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
edit flag offensive delete link more

Comments

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

timewasted gravatar imagetimewasted ( 2012-04-07 18:39:06 -0500 )edit

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

timewasted gravatar imagetimewasted ( 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

2 followers

Stats

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

Seen: 179 times

Last updated: Apr 06 '12