First time here? Check out the FAQ!
0

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: http://www.naosabepergunta.com/questions/scope:all/sort:activity-desc/query:como/page:1/ 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/base.py 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/python27.zip', '/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 ;)

thanks!

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

oscarfh's avatar
69
oscarfh
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

Comments

I believe we're having the same (or a similar) error in Fedora Infrastructure. Here's our ticket tracking the issue -> https://fedorahosted.org/fedora-infrastructure/ticket/3677 and here's a link to our installation -> https://ask.fedoraproject.org/questions/

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 settings.py

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 settings.py), do I have to do something to reload the settings.py 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

0

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

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

Comments

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