Ask Your Question

Database error when searching

asked 2013-02-22 09:07:11 -0500

oscarfh gravatar image

updated 2013-02-22 09:12:48 -0500

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

edit retag flag offensive 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 gravatar imageralph ( 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 gravatar imageFitoria ( 2013-02-22 10:11:20 -0500 )edit

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

Evgeny gravatar imageEvgeny ( 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 gravatar imageoscarfh ( 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 gravatar imageoscarfh ( 2013-02-22 13:13:04 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2013-02-22 15:50:26 -0500

Evgeny gravatar image

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

edit flag offensive delete link more


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 gravatar imageoscarfh ( 2013-02-22 17:14:45 -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: 2013-02-22 09:07:11 -0500

Seen: 165 times

Last updated: Feb 22 '13