Ask Your Question
0

Database error when searching

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

oscarfh gravatar image

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

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

edit retag flag offensive 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 gravatar imageralph ( 2013-02-22 09:54:26 -0600 )edit

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

Fitoria gravatar imageFitoria ( 2013-02-22 10:11:20 -0600 )edit

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

Evgeny gravatar imageEvgeny ( 2013-02-22 11:31:42 -0600 )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 gravatar imageoscarfh ( 2013-02-22 13:12:32 -0600 )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 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

Evgeny gravatar image

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

edit flag offensive delete link more

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 gravatar imageoscarfh ( 2013-02-22 17:14:45 -0600 )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

Stats

Asked: 2013-02-22 09:07:11 -0600

Seen: 156 times

Last updated: Feb 22 '13