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
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/
This is produced by the ASKBOT_MULTILINGUAL feature if you don't use it put "ASKBOT_MULTILINGUAL = False" on settings.py
I think this was fixed, please try the latest code.
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?
@Evgeny I can't at the moment, I will go with Fitoria's solution for the moment ;)