First time here? Check out the FAQ!
Ask Your Question

Revision history  [back]

Revision 4
photon's avatar
5
photon
updated 2011-10-25 03:56:54 -0600

login error:relation "django_authopenid_association" does not exist

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.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
111. response = callback(request, callback_args, *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/django_authopenid/views.py" in signin
391. sreg_request=sreg_req
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in ask_openid
156. auth_request = consumer.begin(openid_url)
File "/usr/lib/python2.6/site-packages/python_openid-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/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in beginWithoutDiscovery
376. auth_req = self.consumer.begin(service)
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin
598. assoc = self._getAssociation(service_endpoint)
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in _getAssociation
1158. assoc = self.store.getAssociation(endpoint.server_url)
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/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 _result_iter
107. self._fill_cache()
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _fill_cache
772. self._result_cache.append(self._iter.next())
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in iterator
273. for row in compiler.results_iter():
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in results_iter
680. for rows in self.execute_sql(MULTI):
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
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/postgresql_psycopg2/base.py" in execute
44. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /account/signin/
Exception Value: relation "django_authopenid_association" does not exist
LINE 1: ..."django_authopenid_association"."assoc_type" FROM "django_au... 

                                     ^

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 django_authopenid:
- Migrating forwards to 0005_auto__del_externallogindata.

django_authopenid:0001_initial
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0002_make_multiple_openids_possible
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0003_fill_in_provider_names
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0004_auto__add_field_userassociation_last_used_timestamp__add_unique_useras
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0005_auto__del_externallogindata
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
- Loading initial data for django_authopenid.
No fixtures found.
Running migrations for askbot:
- Nothing to migrate.
- Loading initial data for askbot.
No fixtures found.

Revision 3
photon's avatar
5
photon
updated 2011-10-24 10:22:42 -0600

login error:relation "django_authopenid_association" does not exist

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.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
111. response = callback(request, callback_args, *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/django_authopenid/views.py" in signin
391. sreg_request=sreg_req
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in ask_openid
156. auth_request = consumer.begin(openid_url)
File "/usr/lib/python2.6/site-packages/python_openid-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/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in beginWithoutDiscovery
376. auth_req = self.consumer.begin(service)
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin
598. assoc = self._getAssociation(service_endpoint)
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in _getAssociation
1158. assoc = self.store.getAssociation(endpoint.server_url)
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/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 _result_iter
107. self._fill_cache()
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _fill_cache
772. self._result_cache.append(self._iter.next())
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in iterator
273. for row in compiler.results_iter():
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in results_iter
680. for rows in self.execute_sql(MULTI):
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in execute_sql
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/postgresql_psycopg2/base.py" in execute
44. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /account/signin/
Exception Value: relation "django_authopenid_association" does not exist
LINE 1: ..."django_authopenid_association"."assoc_type" FROM "django_au... 

                                     ^

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 django_authopenid:
- Migrating forwards to 0005_auto__del_externallogindata.

django_authopenid:0001_initial
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0002_make_multiple_openids_possible
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0003_fill_in_provider_names
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0004_auto__add_field_userassociation_last_used_timestamp__add_unique_useras
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
django_authopenid:0005_auto__del_externallogindata
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
====in db.models.Model, save, BOM====
====in db.models.Model, save_base, BOM====
- Loading initial data for django_authopenid.
No fixtures found.
Running migrations for askbot:
- Nothing to migrate.
- Loading initial data for askbot.
No fixtures found.

Revision 2
Evgeny's avatar
13.2k
Evgeny
updated 2011-10-24 10:22:01 -0600

login error:relation "django_authopenid_association" does not exist

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
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 
 
  111.                         response = callback(request, callback_args, *callback_kwargs) 
*callback_args, **callback_kwargs)  
File "/usr/lib/python2.6/site-packages/django/utils/decorators.py" in _wrapped_view 
 
  93.                     response = view_func(request, args, *kwargs) 
*args, **kwargs)  
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in signin 
 
  391.                             sreg_request=sreg_req 
 
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in ask_openid 
 
  156.         auth_request = consumer.begin(openid_url) 
 
File "/usr/lib/python2.6/site-packages/python_openid-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/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in beginWithoutDiscovery 
 
  376.         auth_req = self.consumer.begin(service) 
 
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin 
 
  598.             assoc = self._getAssociation(service_endpoint) 
 
File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in _getAssociation 
 
  1158.         assoc = self.store.getAssociation(endpoint.server_url) 
 
File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/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 _result_iter 
 
  107.                 self._fill_cache() 
 
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _fill_cache 
 
  772.                     self._result_cache.append(self._iter.next()) 
 
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in iterator 
 
  273.         for row in compiler.results_iter(): 
 
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in results_iter 
 
  680.         for rows in self.execute_sql(MULTI): 
 
File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in execute_sql 
 
  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/postgresql_psycopg2/base.py" in execute 
 
  44.             return self.cursor.execute(query, args)  
 
 Exception Type: DatabaseError at /account/signin/ 
 
Exception Value: relation "django_authopenid_association" does not exist 
 
LINE 1: ..."django_authopenid_association"."assoc_type" FROM "django_au...  
 
                                      ^

 
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 django_authopenid: 
 
 - Migrating forwards to 0005_auto__del_externallogindata.  
 
 

 > django_authopenid:0001_initial 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > django_authopenid:0002_make_multiple_openids_possible 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > django_authopenid:0003_fill_in_provider_names 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > django_authopenid:0004_auto__add_field_userassociation_last_used_timestamp__add_unique_useras 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > django_authopenid:0005_auto__del_externallogindata 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 - Loading initial data for django_authopenid. 
  No fixtures found. 
  Running migrations for askbot: 
  - Nothing to migrate. 
   - Loading initial data for askbot. 
  No fixtures found.  
 
found.
Revision 1
photon's avatar
5
photon
asked 2011-10-24 10:12:48 -0600

login error:relation "django_authopenid_association" does not exist

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

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  

  111.                         response = callback(request, *callback_args, **callback_kwargs)  callback_args, *callback_kwargs) 

File "/usr/lib/python2.6/site-packages/django/utils/decorators.py" in _wrapped_view  

  93.                     response = view_func(request, *args, **kwargs)  args, *kwargs) 

File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in signin  

  391.                             sreg_request=sreg_req  

File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/views.py" in ask_openid  

  156.         auth_request = consumer.begin(openid_url)  

File "/usr/lib/python2.6/site-packages/python_openid-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/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in beginWithoutDiscovery  

  376.         auth_req = self.consumer.begin(service)  

File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in begin  

  598.             assoc = self._getAssociation(service_endpoint)  

File "/usr/lib/python2.6/site-packages/python_openid-2.2.5-py2.6.egg/openid/consumer/consumer.py" in _getAssociation  

  1158.         assoc = self.store.getAssociation(endpoint.server_url)  

File "/usr/lib/python2.6/site-packages/askbot-0.7.26-py2.6.egg/askbot/deps/django_authopenid/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 _result_iter  

  107.                 self._fill_cache()  

File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _fill_cache  

  772.                     self._result_cache.append(self._iter.next())  

File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in iterator  

  273.         for row in compiler.results_iter():  

File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in results_iter  

  680.         for rows in self.execute_sql(MULTI):  

File "/usr/lib/python2.6/site-packages/django/db/models/sql/compiler.py" in execute_sql  

  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/postgresql_psycopg2/base.py" in execute  

  44.             return self.cursor.execute(query, args)   
 
Exception Type: DatabaseError at /account/signin/  

Exception Value: relation "django_authopenid_association" does not exist  

LINE 1: ..."django_authopenid_association"."assoc_type" FROM "django_au...  
                                                             ^



                                                             ^
 
$ 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 django_authopenid:  

 - Migrating forwards to 0005_auto__del_externallogindata.  
 > 
 
 
django_authopenid:0001_initial  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
 django_authopenid:0002_make_multiple_openids_possible  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
 django_authopenid:0003_fill_in_provider_names  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
 django_authopenid:0004_auto__add_field_userassociation_last_used_timestamp__add_unique_useras  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
 > 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
 django_authopenid:0005_auto__del_externallogindata  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  
====in db.models.Model, save, BOM====  
====in db.models.Model, save_base, BOM====  


  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 

  ====in db.models.Model, save, BOM==== 

  ====in db.models.Model, save_base, BOM==== 
  - Loading initial data for django_authopenid.  
 No fixtures found.  
 Running migrations for askbot:  
 - Nothing to migrate.  
  - Loading initial data for askbot.  
 No fixtures found.
found.