Blocking: Can't delete user in Django admin panel #49
Description
https://trello.com/c/U9NwC0sy/99-cant-delete-user-in-django-admin-panel
When trying to delete a test user via the Django admin panel, it threw the included error, and fails to delete the user.
ProgrammingError at /admin/users/customuser/
relation "allauth_socialaccount" does not exist
LINE 1: ...er"."date_joined", "users_customuser"."name" FROM "allauth_s...
^
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/users/customuser/
Django Version: 2.1.3
Exception Type: ProgrammingError
Exception Value:
relation "allauth_socialaccount" does not exist
LINE 1: ...er"."date_joined", "users_customuser"."name" FROM "allauth_s...
^
Exception Location: C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py in _execute, line 85
Python Executable: C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\Scripts\python.exe
Python Version: 3.7.1
Python Path:
['D:\\dev\\LambdaSchool\\labs8\\Labs8-OfflineReader\\backend',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG\\Scripts\\python37.zip',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG\\DLLs',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG\\lib',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG\\Scripts',
'C:\\Programs\\Python37\\Lib',
'C:\\Programs\\Python37\\DLLs',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG',
'C:\\Users\\myuser\\.virtualenvs\\backend-ohEwWIzG\\lib\\site-packages']
Server time: Thu, 15 Nov 2018 18:03:37 +0000
Environment:
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/users/customuser/
Django Version: 2.1.3
Python Version: 3.7.1
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.sites',
'rest_framework',
'rest_framework.authtoken',
'rest_auth',
'allauth',
'allauth.account',
'rest_auth.registration',
'api',
'apps.scraper',
'users',
'pages']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
Traceback:
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
The above exception (relation "allauth_socialaccount" does not exist
LINE 1: ...er"."date_joined", "users_customuser"."name" FROM "allauth_s...
^
) was the direct cause of the following exception:
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\core\handlers\exception.py" in inner
34. response = get_response(request)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\core\handlers\base.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\core\handlers\base.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\options.py" in wrapper
604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\utils\decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\views\decorators\cache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\sites.py" in inner
223. return view(request, *args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\utils\decorators.py" in _wrapper
45. return bound_method(*args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\utils\decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\options.py" in changelist_view
1700. response = self.response_action(request, queryset=cl.get_queryset(request))
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\options.py" in response_action
1400. response = func(self, request, queryset)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\actions.py" in delete_selected
28. deletable_objects, model_count, perms_needed, protected = modeladmin.get_deleted_objects(queryset, request)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\options.py" in get_deleted_objects
1822. return get_deleted_objects(objs, request, self.admin_site)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\utils.py" in get_deleted_objects
134. collector.collect(objs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\contrib\admin\utils.py" in collect
197. return super().collect(objs, source_attr=source_attr, **kwargs)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\models\deletion.py" in collect
220. elif sub_objs:
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\models\query.py" in __bool__
272. self._fetch_all()
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\models\query.py" in _fetch_all
1186. self._result_cache = list(self._iterable_class(self))
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\models\query.py" in __iter__
54. results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\models\sql\compiler.py" in execute_sql
1065. cursor.execute(sql, params)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in execute
100. return super().execute(sql, params)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\utils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Users\myuser\.virtualenvs\backend-ohEwWIzG\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
Exception Type: ProgrammingError at /admin/users/customuser/
Exception Value: relation "allauth_socialaccount" does not exist
LINE 1: ...er"."date_joined", "users_customuser"."name" FROM "allauth_s...
^