I get an error when I try to post the first question in my askbot site
Hi, I've just installed a new askbot website. I was testing it and tried to post a question, I got the following error:
DoesNotExist at /questions/ask/
Group matching query does not exist.
Request Method: POST Request URL: http://naosabepergunta.herokuapp.com/questions/ask/ Django Version: 1.4.3 Exception Type: DoesNotExist Exception Value:
Group matching query does not exist.
Exception Location: /app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py in get, line 366 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']
Server time: Wed, 30 Jan 2013 14:14:52 +0100
This website is new (it has no questions). I may help knowing that searching also fails, I get this error:
DatabaseError at /questions/scope:all/sort:activity-desc/query:buscando/page:1/
column askbot_thread.text_search_vector does not exist LINE 1: ... "askbot_thread"."id") FROM "askbot_thread" WHERE askbot_thr... ^
Request Method: GET Request URL: http://naosabepergunta.herokuapp.com/questions/scope:all/sort:activity-desc/query:buscando/page:1/ Django Version: 1.4.3 Exception Type: DatabaseError Exception Value:
column askbot_thread.text_search_vector does not exist LINE 1: ... "askbot_thread"."id") FROM "askbot_thread" WHERE 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']
Server time: Wed, 30 Jan 2013 14:18:03 +0100
can someone help help?
ps: the posting question error happens only when I use the administrator user. When I create a new user, I am able to post questions normally. The search error keeps happening.
edit: I am hosting it on Heroku, using the files found here: https://github.com/rodelrod/putsches
@Evgeny I ran it and got " FATAL ERROR - The following SQL query failed: CREATE TABLE "django_authopenid_no nce" ("timestamp" integer NOT NULL, "salt" varchar(40) NOT NULL, "id" serial NOT NULL PRIMARY KEY, "server_url" varchar(255) NOT NULL ...
Comments
I think you either forgot to run database migrations or some of them failed for you. Try `python manage.py syncdb --migrate --noinput`
@Evgeny cleaned the DB, ran this code and it worked, but still there are some errors in the migration. Do you want me to sent the log to you? It looks some columns are being added many times (specially in the auth_user table). This could be some problems with the SQL, I could send them to you :)
btw: could you please change your comment to a question so I can accept it?
@Oscar, I'm glad you got your problem fixed. I'm just dropping in to say you shouldn't really be using the putsches fork, but rather https://github.com/rodelrod/askbot-heroku. The putsches fork has some structural modifications of the askbot code and will diverge soon. Any modification that is relevant to the heroku deployment will be ported back to the askbot-heroku fork. As for the remaining errors in the migration, I get those too. They haven't posed any problem for me yet.
@rodelrod thanks for the valuable advice! I will make this change right now!