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

Revision history  [back]

Revision 4
photon's avatar
5
photon
updated 13 years ago

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 13 years ago

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 13 years ago

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 13 years ago

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.