First time here? Check out the FAQ!

Revision history  [back]

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

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