常連

注目の的

社会貢献

質問力

質問者

模範生

### 前提・実現したいこと

Djangoでpython-social-authを用いてGoogle認証を実装しようとしています。
index.htmlの「Login with Google」ボタンからGoogleのログイン画面に飛び、その後のリダイレクトで次のエラーメッセージが発生しました。

### エラーメッセージ（概要）
**OperationalError at /complete/google-oauth2/**
**no such table: social_auth_usersocialauth**

### エラーメッセージ（詳細）

```
Environment:

Request Method: GET
Request URL: http://localhost:8000/complete/google-oauth2/?state=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Django Version: 2.0.2
Python Version: 3.5.2
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'social.apps.django_app.default',
 'auth0',
 'auth1']
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 "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py" in execute
  303.         return Database.Cursor.execute(self, query, params)

The above exception (no such table: social_auth_usersocialauth) was the direct cause of the following exception:

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
  35.             response = get_response(request)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  128.                 response = self.process_exception_by_middleware(e, request)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  126.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
  44.         response = view_func(request, *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/views/decorators/csrf.py" in wrapped_view
  54.         return view_func(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_django/utils.py" in wrapper
  49.             return func(request, backend, *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_django/views.py" in complete
  33.                        *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/actions.py" in do_complete
  41.         user = backend.complete(user=user, *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/base.py" in complete
  40.         return self.auth_complete(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/utils.py" in wrapper
  252.             return func(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/oauth.py" in auth_complete
  405.                             *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/utils.py" in wrapper
  252.             return func(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/oauth.py" in do_auth
  416.         return self.strategy.authenticate(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_django/strategy.py" in authenticate
  107.         return authenticate(*args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/contrib/auth/__init__.py" in authenticate
  70.             user = _authenticate_with_backend(backend, backend_path, request, credentials)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/contrib/auth/__init__.py" in _authenticate_with_backend
  116.     return backend.authenticate(*args, **credentials)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/base.py" in authenticate
  80.         return self.pipeline(pipeline, *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/base.py" in pipeline
  83.         out = self.run_pipeline(pipeline, pipeline_index, *args, **kwargs)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/backends/base.py" in run_pipeline
  113.             result = func(*args, **out) or {}

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_core/pipeline/social_auth.py" in social_user
  19.     social = backend.strategy.storage.user.get_social_auth(provider, uid)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/social_django/models.py" in get_social_auth
  51.                                                           uid=uid)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/models/query.py" in get
  397.         num = len(clone)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/models/query.py" in __len__
  254.         self._fetch_all()

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/models/query.py" in _fetch_all
  1179.             self._result_cache = list(self._iterable_class(self))

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/models/query.py" in __iter__
  53.         results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/models/sql/compiler.py" in execute_sql
  1064.             cursor.execute(sql, params)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
  100.             return super().execute(sql, params)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in execute
  68.         return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
  77.         return executor(sql, params, many, context)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/utils.py" in __exit__
  89.                 raise dj_exc_value.with_traceback(traceback) from exc_value

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/utils.py" in _execute
  85.                 return self.cursor.execute(sql, params)

File "/home/kei/.virtualenvs/nextone/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py" in execute
  303.         return Database.Cursor.execute(self, query, params)

Exception Type: OperationalError at /complete/google-oauth2/
Exception Value: no such table: social_auth_usersocialauth


```

### nextone/setting.py（抜粋）

```python
INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'social.apps.django_app.default',
    'auth1', #アプリ名
]

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },


AUTHENTICATION_BACKENDS = (
        'social_core.backends.google.GoogleOAuth2' ,
        'django.contrib.auth.backends.ModelBackend',
        )
        
SOCIAL_AUTH_GOOGLE_OAUTH2_KEY = 'XXXXXXXXXXXXXXXXXXXXXXXXXX'
SOCIAL_AUTH_GOOGLE_OAUTH2_SECRET = 'XXXXXXXXXXXXXXXXX'

SOCIAL_AUTH_LOGIN_REDIRECT_URL = '/'
SOCIAL_AUTH_LOGIN_URL = '/login/'
```

### auth1/templates/auth1/index.html 
```html
{% extends "auth1/base.html" %}

{% block title %}ホーム{% endblock title %}

{% block content %}
<div>
  <h1>ホーム</h1>

  <p>
  <ul>
    {% if user and not user.is_anonymous %}
    
    {% else %}
    <li>
      <a href="{% url 'social:begin' 'google-oauth2' %}?next={{ request.path }}">Login with Google</a>
    </li>
    {% endif %}
  </ul>
  </p>
</div>
{% endblock content %}
```
###auth1/templates/auth1/base.html 
```html
{% load staticfiles %}
<!DOCTYPE html>
<html lang="{{ LANGUAGE_CODE|default:"en-us" }}">
<head>
  <meta charset="UTF-8">
  <title>{% block title %}{% endblock %}</title>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  {% block extrahead %}{% endblock %}
</head>
<body>
  <div class="container">
    {% block content %}
      {{ content }}
    {% endblock %}
  </div>
</body>
</html>
```

### 環境について

python3.5.2
pip9.0.1
ubuntu16.04 x84_64

no such table: social_auth_usersocialauthのエラー

お世話になっております。
GitLabで作成したリポジトリへのプッシュ時にエラーが発生しており、
アドバイスをいただきたく投稿しました。

Push操作自体は、Windows 10のPCから、
TortoiseGitを使用して行いました。

[表示されたエラーメッセージ]
-----
git.exe push --progress "origin" master:master

Enumerating objects: 8, done.
Counting objects: 100% (8/8), done.
Delta compression using up to 8 threads.
Compressing objects: 100% (3/3), done.
Writing objects: 100% (6/6), 532 bytes | 532.00 KiB/s, done.
Total 6 (delta 0), reused 1 (delta 0)
remote: /opt/gitlab/embedded/service/gitlab-shell/lib/gitlab_net.rb:153:in `parse_who': undefined method `start_with?' for nil:NilClass (NoMethodError)
remote: 	from /opt/gitlab/embedded/service/gitlab-shell/lib/gitlab_net.rb:31:in `check_access'
remote: 	from /opt/gitlab/embedded/service/gitlab-shell/lib/gitlab_access.rb:27:in `block in exec'
remote: 	from /opt/gitlab/embedded/service/gitlab-shell/lib/gitlab_metrics.rb:50:in `measure'
remote: 	from /opt/gitlab/embedded/service/gitlab-shell/lib/gitlab_access.rb:26:in `exec'
remote: 	from hooks/pre-receive:30:in `<main>'
To ssh://<ホスト名>:<ポート番号>/~/<リポジトリまでのパス>/test_system.git
! [remote rejected] master -> master (pre-receive hook declined)
error: failed to push some refs to 'ssh://git@<ホスト名>:<ポート番号>/~/<リポジトリまでのパス>/test_system.git'

gitは正常に終了しませんでした (終了コード 1) (1125 ms @ 2018/10/21 16:47:10)
-----

アドバイスいただけたら幸いです。
よろしくお願いいたします。