Ask Your Question
0

login error: DatabaseError at /account/signin/

asked 2011-10-24 09:06:48 -0500

photon gravatar image

updated 2011-10-25 03:57:14 -0500

Hi, I setup askbot, but when I tried to sign in with the superuser created by syncdb, I see this error. I chose the askbot signin. Any suggestion?

The installation follows http://askbot.org/doc/index.html

An update: I also see a relation "djangoauthopenidassociation" does not exist error, maybe these two probems are related.

OS: fedora 13
askbot: askbot-0.7.26, installed with easy_install.
db: postgres, client 8.4.5, server 9.0, psycopg2

Environment:
Request Method: POST
Request URL: http://localhost:8000/account/signin/

Django Version: 1.3
Python Version: 2.6.4
Installed Applications:
['django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.admin',
'django.contrib.humanize',
'django.contrib.sitemaps',
'askbot',
'askbot.deps.django_authopenid',
'south',
'askbot.deps.livesettings',
'keyedcache',
'robots',
'django_countries',
'djcelery',
'djkombu',
'followit']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'askbot.middleware.anon_user.ConnectToSessionMessagesMiddleware',
'askbot.middleware.pagesize.QuestionsPageSizeMiddleware',
'askbot.middleware.cancel.CancelActionMiddleware',
'django.middleware.transaction.TransactionMiddleware',
'askbot.middleware.view_log.ViewLogMiddleware',
'askbot.middleware.spaceless.SpacelessMiddleware')

Traceback: File "/usr/lib/python2.6/site-packages/django/core/handlers/base.py" in get_response
178. response = middleware_method(request, response)
File "/usr/lib/python2.6/site-packages/django/contrib/sessions/middleware.py" in process_response
36. request.session.save()
File "/usr/lib/python2.6/site-packages/django/contrib/sessions/backends/db.py" in save
61. sid = transaction.savepoint(using=using)
File "/usr/lib/python2.6/site-packages/django/db/transaction.py" in savepoint
162. return connection.savepoint()
File "/usr/lib/python2.6/site-packages/django/db/backends/__init__.py" in savepoint
223. self._savepoint(sid)
File "/usr/lib/python2.6/site-packages/django/db/backends/__init__.py" in _savepoint
70. self.cursor().execute(self.ops.savepoint_create_sql(sid))
File "/usr/lib/python2.6/site-packages/django/db/backends/util.py" in execute
34. return self.cursor.execute(sql, params)
File "/usr/lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/base.py" in execute
44. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /account/signin/
Exception Value: current transaction is aborted, commands ignored until end of transaction block

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2011-10-24 09:14:13 -0500

Evgeny gravatar image

updated 2011-10-24 09:15:23 -0500

Hello, maybe you forgot to run migrations?

python manage.py migrate

Tables for the askbot application and the bundled login app are created by the migrate command, but most other applications - by syncdb.

edit flag offensive delete link more

Comments

I've run python manage.py syncdb and python manage.py migrate, see login error:relation "djangoauthopenidassociation" does not exist

photon gravatar imagephoton ( 2011-10-24 10:18:38 -0500 )edit

yes, the two problems are related. After I run the syncdb and migrate commands again, the two problems both disappear.

photon gravatar imagephoton ( 2011-10-24 10:31:21 -0500 )edit

Sorry, the first time you just ran syncdb, without the migrate - and then you had the issue - and the second time you ran both commands back-to-back and the problem went away - yes? Or there is something else?

Evgeny gravatar imageEvgeny ( 2011-10-24 10:34:29 -0500 )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

1 follower

Stats

Asked: 2011-10-24 09:06:48 -0500

Seen: 1,546 times

Last updated: Oct 25 '11