First time here? Check out the FAQ!
0

login error: DatabaseError at /account/signin/

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

photon's avatar
5
photon
updated 2011-10-25 03:57:14 -0500, asked 2011-10-24 09:06:48 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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.

Evgeny's avatar
13.2k
Evgeny
updated 2011-10-24 09:15:23 -0500, answered 2011-10-24 09:14:13 -0500
edit flag offensive 0 remove flag delete link

Comments

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

photon's avatar photon (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's avatar photon (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's avatar Evgeny (2011-10-24 10:34:29 -0500) edit
add a comment see more comments