login error:relation "django_authopenid_association" does not exist

asked 2011-10-24 10:12:48 -0500

photon
5 ● 1 ● 2

updated 2011-10-25 03:56:54 -0500

I have a problem to login with superuser created with syncdb, then I tried to chose other method to login, such as google signin, and then I saw this error. Maybe the two problems are related, but I feel it better to seperate the two problems before the doubt is confirmed. detail as below:

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.djangoauthopenid',
'south',
'askbot.deps.livesettings',
'keyedcache',
'robots',
'djangocountries',
'djcelery',
'djkombu',
'followit']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'askbot.middleware.anonuser.ConnectToSessionMessagesMiddleware',
'askbot.middleware.pagesize.QuestionsPageSizeMiddleware',
'askbot.middleware.cancel.CancelActionMiddleware',
'django.middleware.transaction.TransactionMiddleware',
'askbot.middleware.viewlog.ViewLogMiddleware',
'askbot.middleware.spaceless.SpacelessMiddleware')

Traceback:
File "/usr/lib/python2.6/site-packages/django/core/handlers/base.py" in getresponse
111. response = callback(request, *callbackargs, *callback_kwargs)
File "/usr/lib/python2.6/site-packages/django/utils/decorators.py" in _wrapped_view
93. response = view_func(request, *args, *kwargs)
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/djangoauthopenid/views.py" in signin
391. sregrequest=sregreq
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/djangoauthopenid/views.py" in askopenid
156. authrequest = consumer.begin(openidurl)
File "/usr/lib/python2.6/site-packages/pythonopenid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin
353. return self.beginWithoutDiscovery(service, anonymous) File "/usr/lib/python2.6/site-packages/pythonopenid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in beginWithoutDiscovery
376. authreq = self.consumer.begin(service)
File "/usr/lib/python2.6/site-packages/pythonopenid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin
598. assoc = self.getAssociation(serviceendpoint)
File "/usr/lib/python2.6/site-packages/pythonopenid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in getAssociation
1158. assoc = self.store.getAssociation(endpoint.serverurl)
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/djangoauthopenid/util.py" in getAssociation
79. if not assocs:
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in nonzero
113. iter(self).next()
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _resultiter
107. self.fillcache()
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in fillcache
772. self.resultcache.append(self.iter.next())
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in iterator
273. for row in compiler.resultsiter():
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in resultsiter
680. for rows in self.executesql(MULTI):
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in executesql
735. cursor.execute(sql, params)
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/postgresqlpsycopg2/base.py" in execute
44. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /account/signin/
Exception Value: relation "djangoauthopenidassociation" does not exist
LINE 1: ..."djangoauthopenidassociation"."assoctype" FROM "djangoau...

                                     ^

Before this problem appeared, I've run following syncdb and migrate commands.

$ python2.6 manage.py syncdb
/usr/lib/python2.6/site-packages/django/db/init.py:19: DeprecationWarning: settings.DATABASE_* is deprecated; use settings.DATABASES instead.
DeprecationWarning
/usr/lib/python2.6/site-packages/django/db/init.py:60: DeprecationWarning: Short names for ENGINE in database configurations are deprecated. Prepend default.ENGINE with 'django.db.backends.'
DeprecationWarning
Syncing...
Creating tables ...
Installing custom SQL ...
Installing indexes ...
No fixtures found.

Synced:

django.contrib.auth
django.contrib.contenttypes
django.contrib.sessions
django.contrib.sites
django.contrib.admin
django.contrib.sitemaps
south
askbot.deps.livesettings
keyedcache
robots
django_countries
djcelery
djkombu
followit

Not synced (use migrations):
- askbot.deps.django_authopenid
- askbot
(use ./manage.py migrate to migrate these)

$ python2.6 manage.py migrate
/usr/lib/python2.6/site-packages/django/db/init.py:19: DeprecationWarning: settings.DATABASE* is deprecated; use settings.DATABASES instead.
DeprecationWarning
/usr/lib/python2.6/site-packages/django/db/init.py:60: DeprecationWarning: Short names for ENGINE in database configurations are deprecated. Prepend default.ENGINE with 'django.db.backends.'
DeprecationWarning
Running migrations for djangoauthopenid:
- Migrating forwards to 0005autodelexternallogindata.

djangoauthopenid:0001initial
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
djangoauthopenid:0002makemultipleopenidspossible
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
djangoauthopenid:0003fillinprovidernames
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
djangoauthopenid:0004autoaddfielduserassociationlastusedtimestampadduniqueuseras
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
djangoauthopenid:0005autodelexternallogindata
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, savebase, BOM====
- Loading initial data for djangoauthopenid.
No fixtures found.
Running migrations for askbot:
- Nothing to migrate.
- Loading initial data for askbot.
No fixtures found.