First time here? Check out the FAQ!

Database error when searching

Hi Guys, My Askbot installation was working just fine. But now I tried to search for something and got the following error:

column "en" does not exist LINE 1: SELECT DISTINCT (en) AS "language_code", (ts_rank(askbot_thr... ^

Request Method: GET Request URL: Django Version: 1.4.3 Exception Type: DatabaseError Exception Value:

column "en" does not exist LINE 1: SELECT DISTINCT (en) AS "language_code", (ts_rank(askbot_thr... ^

Exception Location: /app/.heroku/python/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/ in execute, line 52 Python Executable: /app/.heroku/python/bin/python Python Version: 2.7.3 Python Path:

['/app/.heroku/python/bin', '/app/.heroku/python/lib/python2.7/site-packages/distribute-0.6.34-py2.7.egg', '/app/.heroku/python/lib/python2.7/site-packages/pip-1.1-py2.7.egg', '/app', '/app/.heroku/python/lib/', '/app/.heroku/python/lib/python2.7', '/app/.heroku/python/lib/python2.7/plat-linux2', '/app/.heroku/python/lib/python2.7/lib-tk', '/app/.heroku/python/lib/python2.7/lib-old', '/app/.heroku/python/lib/python2.7/lib-dynload', '/app/.heroku/python/lib/python2.7/site-packages', '/app/.heroku/python/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info', '/app/askbot/deps']

How could I fix it? ps: I would not like to lose my DB, if possible ;)


btw: this happens only when there is information to be retrieved

oscarfh's avatar
asked 2013-02-22 09:07:11 -0500, updated 2013-02-22 09:12:48 -0500
edit flag offensive 0 remove flag close merge delete


I believe we're having the same (or a similar) error in Fedora Infrastructure. Here's our ticket tracking the issue -> and here's a link to our installation ->

ralph's avatar ralph (2013-02-22 09:54:26 -0500) edit

This is produced by the ASKBOT_MULTILINGUAL feature if you don't use it put "ASKBOT_MULTILINGUAL = False" on

Fitoria's avatar Fitoria (2013-02-22 10:11:20 -0500) edit

I think this was fixed, please try the latest code.

Evgeny's avatar Evgeny (2013-02-22 11:31:42 -0500) edit

if I set it to false (on, do I have to do something to reload the file or it will be loaded automatically?

oscarfh's avatar oscarfh (2013-02-22 13:12:32 -0500) edit

@Evgeny I can't at the moment, I will go with Fitoria's solution for the moment ;)

oscarfh's avatar oscarfh (2013-02-22 13:13:04 -0500) edit
add a comment see more comments

1 Answer


This issue was solved, the latest code in the repository has the fix.

Evgeny's avatar
answered 2013-02-22 15:50:26 -0500
edit flag offensive 0 remove flag delete link


Sorry, I can't download the latest because I am using an heroku doeployment. Im using an old version from @rodelrod "putsches". I tried to deploy the newest version called "askbot-Heroku" but I couldn't get it to work fast using the DB I had from the previous version

oscarfh's avatar oscarfh (2013-02-22 17:14:45 -0500) edit
add a comment see more comments