ProgrammingError at /accounts/login/

column socialaccount_socialapp.provider_id does not exist
LINE 1: ...lapp"."id", "socialaccount_socialapp"."provider", "socialacc...
                                                             ^
HINT:  Perhaps you meant to reference the column "socialaccount_socialapp.provider".
Request Method: GET
Request URL: https://ringbase.org/accounts/login/?next=/species/551/
Django Version: 4.2.4
Exception Type: ProgrammingError
Exception Value:
column socialaccount_socialapp.provider_id does not exist
LINE 1: ...lapp"."id", "socialaccount_socialapp"."provider", "socialacc...
                                                             ^
HINT:  Perhaps you meant to reference the column "socialaccount_socialapp.provider".
Exception Location: /home/ringbase/virtualenv/lib/python3.11/site-packages/psycopg/cursor.py, line 737, in execute
Raised during: allauth.account.views.LoginView
Python Executable: /home/ringbase/virtualenv/bin/uwsgi
Python Version: 3.11.7
Python Path:
['.',
 '',
 '/usr/lib/python311.zip',
 '/usr/lib/python3.11',
 '/usr/lib/python3.11/lib-dynload',
 '/home/ringbase/virtualenv/lib/python3.11/site-packages']
Server time: Tue, 19 Mar 2024 04:01:41 +0000

Error during template rendering

In template /home/ringbase/django/templates/account/_login_form.html, error at line 5

column socialaccount_socialapp.provider_id does not exist LINE 1: ...lapp"."id", "socialaccount_socialapp"."provider", "socialacc... ^ HINT: Perhaps you meant to reference the column "socialaccount_socialapp.provider".

1 {% load i18n %}
2 {% load bootstrap3 %}
3 {% load account socialaccount %}
4
5 {% get_providers as socialaccount_providers %}
6
7 {% if socialaccount_providers %}
8 <p>{% blocktrans %}Please sign in with one
9 of your existing third party accounts. Or, <a href="{{ signup_url }}">register a new account</a>
10 and sign in below.{% endblocktrans %}</p>
11
12 <div class="socialaccount_ballot">
13
14 <ul class="socialaccount_providers">
15 {% include "socialaccount/snippets/provider_list.html" with process="login" %}

Traceback Switch to copy-and-paste view



Request information

USER

AnonymousUser

GET

Variable Value
next
'/species/551/'

POST

No POST data

FILES

No FILES data

No cookie data

META

Variable Value
CONTENT_LENGTH
''
CONTENT_TYPE
''
DOCUMENT_ROOT
'/usr/share/nginx/html'
HTTPS
'on'
HTTP_ACCEPT
'*/*'
HTTP_HOST
'ringbase.org'
HTTP_USER_AGENT
'claudebot'
PATH_INFO
'/accounts/login/'
QUERY_STRING
'next=/species/551/'
REMOTE_ADDR
'54.81.185.66'
REMOTE_PORT
'60498'
REQUEST_METHOD
'GET'
REQUEST_SCHEME
'https'
REQUEST_URI
'/accounts/login/?next=/species/551/'
SCRIPT_NAME
''
SERVER_NAME
'ringbase.org'
SERVER_PORT
'443'
SERVER_PROTOCOL
'HTTP/1.1'
uwsgi.node
b'zp'
uwsgi.version
b'2.0.22'
wsgi.errors
<_io.TextIOWrapper name=2 mode='w' encoding='UTF-8'>
wsgi.file_wrapper
<built-in function uwsgi_sendfile>
wsgi.input
<uwsgi._Input object at 0x7fa551ff3f50>
wsgi.multiprocess
False
wsgi.multithread
False
wsgi.run_once
False
wsgi.url_scheme
'https'
wsgi.version
(1, 0)

Settings

Using settings module app.settings

Setting Value
ABSOLUTE_URL_OVERRIDES
{}
ADMINS
[]
ALLOWED_HOSTS
['*']
APPEND_SLASH
True
AUTHENTICATION_BACKENDS
('rules.permissions.ObjectPermissionBackend',
 'django.contrib.auth.backends.ModelBackend',
 'allauth.account.auth_backends.AuthenticationBackend')
AUTH_PASSWORD_VALIDATORS
'********************'
AUTH_USER_MODEL
'auth.User'
BASE_DIR
'/home/ringbase/django'
BOOTSTRAP3
{'base_url': '/static/plugins/bootstrap/',
 'horizontal_field_class': 'col-md-10',
 'horizontal_label_class': 'col-md-2',
 'include_jquery': False,
 'javascript_in_head': True,
 'success_css_class': ''}
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.memcached.PyLibMCCache',
             'LOCATION': '127.0.0.1:11211'}}
CACHE_MIDDLEWARE_ALIAS
'default'
CACHE_MIDDLEWARE_KEY_PREFIX
'********************'
CACHE_MIDDLEWARE_SECONDS
600
CSRF_COOKIE_AGE
31449600
CSRF_COOKIE_DOMAIN
None
CSRF_COOKIE_HTTPONLY
False
CSRF_COOKIE_MASKED
False
CSRF_COOKIE_NAME
'csrftoken'
CSRF_COOKIE_PATH
'/'
CSRF_COOKIE_SAMESITE
'Lax'
CSRF_COOKIE_SECURE
False
CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME
'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS
[]
CSRF_USE_SESSIONS
False
CURRENT_ENV
'PRODUCTION'
DATABASES
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_HEALTH_CHECKS': False,
             'CONN_MAX_AGE': 600,
             'ENGINE': 'django.contrib.gis.db.backends.postgis',
             'HOST': None,
             'NAME': 'ringbase',
             'OPTIONS': {},
             'PASSWORD': '********************',
             'PORT': 5432,
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIGRATE': True,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': None,
             'USER': 'ringbase'}}
DATABASE_ROUTERS
[]
DATA_UPLOAD_MAX_MEMORY_SIZE
2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS
1000
DATA_UPLOAD_MAX_NUMBER_FILES
100
DATETIME_FORMAT
'N j, Y, P'
DATETIME_INPUT_FORMATS
['%Y-%m-%d %H:%M:%S',
 '%Y-%m-%d %H:%M:%S.%f',
 '%Y-%m-%d %H:%M',
 '%m/%d/%Y %H:%M:%S',
 '%m/%d/%Y %H:%M:%S.%f',
 '%m/%d/%Y %H:%M',
 '%m/%d/%y %H:%M:%S',
 '%m/%d/%y %H:%M:%S.%f',
 '%m/%d/%y %H:%M']
DATE_FORMAT
'N j, Y'
DATE_INPUT_FORMATS
['%Y-%m-%d',
 '%m/%d/%Y',
 '%m/%d/%y',
 '%b %d %Y',
 '%b %d, %Y',
 '%d %b %Y',
 '%d %b, %Y',
 '%B %d %Y',
 '%B %d, %Y',
 '%d %B %Y',
 '%d %B, %Y']
DEBUG
True
DEBUG_PROPAGATE_EXCEPTIONS
False
DECIMAL_SEPARATOR
'.'
DEFAULT_AUTO_FIELD
'django.db.models.AutoField'
DEFAULT_CHARSET
'utf-8'
DEFAULT_EXCEPTION_REPORTER
'django.views.debug.ExceptionReporter'
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL
'info@ringbase.org'
DEFAULT_INDEX_TABLESPACE
''
DEFAULT_TABLESPACE
''
DISALLOWED_USER_AGENTS
[]
DJANGO_ICONS
{'ICONS': {'download': {'name': 'fas fa-download'},
           'warning': {'name': 'fas fa-exclamation-triangle'}}}
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST
'localhost'
EMAIL_HOST_PASSWORD
'********************'
EMAIL_HOST_USER
''
EMAIL_PORT
25
EMAIL_SSL_CERTFILE
None
EMAIL_SSL_KEYFILE
'********************'
EMAIL_SUBJECT_PREFIX
'[Django] '
EMAIL_TIMEOUT
None
EMAIL_USE_LOCALTIME
False
EMAIL_USE_SSL
False
EMAIL_USE_TLS
False
EXCEL_SUPPORT
'xlwt'
FILE_UPLOAD_DIRECTORY_PERMISSIONS
None
FILE_UPLOAD_HANDLERS
['django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
FILE_UPLOAD_PERMISSIONS
420
FILE_UPLOAD_TEMP_DIR
None
FIRST_DAY_OF_WEEK
0
FIXTURE_DIRS
[]
FORCE_SCRIPT_NAME
None
FORMAT_MODULE_PATH
None
FORM_RENDERER
'django.forms.renderers.DjangoTemplates'
GIT_BRANCH
'feature/upgrade'
GIT_SHA
'9cc9151f6e80535cdb61cc41ae3821b0a3f5c1a7'
GOOGLE_API_KEY
'********************'
IGNORABLE_404_URLS
[]
INSTALLED_APPS
('modeltrans',
 'markdown_deux',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.gis',
 'django.contrib.sites',
 'allauth',
 'allauth.account',
 'allauth.socialaccount',
 'rules.apps.AutodiscoverRulesConfig',
 'bootstrap3',
 'django_icons',
 'leaflet',
 'rosetta',
 'rest_framework',
 'rest_framework.authtoken',
 'rest_framework_gis',
 'rest_framework_extensions',
 'charting',
 'django_tables2',
 'django_filters',
 'django_tables2_column_shifter',
 'stdimage',
 'django_select2',
 'app.countries',
 'app.languages',
 'app.attrs',
 'app.organizations',
 'app.locations',
 'app.schemes',
 'app.species',
 'app.animals',
 'app.rings',
 'app.photos',
 'app.projects',
 'app.fieldwork',
 'app.euring',
 'app.users',
 'django.contrib.admin',
 'teramap')
INTERNAL_IPS
[]
LANGUAGES
(('en', 'English'), ('nl', 'Dutch'), ('ka', 'Georgian'))
LANGUAGES_BIDI
['he', 'ar', 'ar-dz', 'ckb', 'fa', 'ur']
LANGUAGE_CODE
'en'
LANGUAGE_COOKIE_AGE
None
LANGUAGE_COOKIE_DOMAIN
None
LANGUAGE_COOKIE_HTTPONLY
False
LANGUAGE_COOKIE_NAME
'django_language'
LANGUAGE_COOKIE_PATH
'/'
LANGUAGE_COOKIE_SAMESITE
None
LANGUAGE_COOKIE_SECURE
False
LEAFLET_CONFIG
{'DEFAULT_CENTER': (51.0, 4.0),
 'DEFAULT_ZOOM': 6,
 'MAX_ZOOM': 19,
 'MIN_ZOOM': 1,
 'RESET_VIEW': False,
 'TILES': [('OpenStreetMap',
            '//{s}.tile.openstreetmap.org/{z}/{x}/{y}.png',
            {'attribution': '&copy; OpenStreetMap',
             'maxNativeZoom': 19,
             'maxZoom': 19,
             'minZoom': 1,
             'tms': False})]}
LOCALE_PATHS
[]
LOGGING
{}
LOGGING_CONFIG
'logging.config.dictConfig'
LOGIN_REDIRECT_URL
'home'
LOGIN_URL
'/accounts/login/'
LOGOUT_REDIRECT_URL
None
MANAGERS
[]
MEDIA_ROOT
'/home/ringbase/django/../media'
MEDIA_URL
'/media/'
MESSAGE_STORAGE
'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE
('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',
 'django.middleware.security.SecurityMiddleware',
 'django.middleware.locale.LocaleMiddleware')
MIGRATION_MODULES
{}
MODELTRANSLATION_FALLBACK_LANGUAGES
{'default': ('en', 'nl', 'ka'), 'ka': ('en',), 'nl': ('en',)}
MODELTRANS_FALLBACK
{'default': ('en',)}
MONTH_DAY_FORMAT
'F j'
NUMBER_GROUPING
0
PASSWORD_HASHERS
'********************'
PASSWORD_RESET_TIMEOUT
'********************'
PREPEND_WWW
False
REST_FRAMEWORK
{'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication',
                                    'rest_framework.authentication.SessionAuthentication'),
 'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.PageNumberPagination',
 'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAuthenticated',),
 'MAX_PAGINATE_BY': 100,
 'PAGE_SIZE': 100,
 'PAGINATE_BY': 100,
 'PAGINATE_BY_PARAM': 'page_size'}
ROOT_URLCONF
'app.urls'
SECRET_KEY
'********************'
SECRET_KEY_FALLBACKS
'********************'
SECURE_CONTENT_TYPE_NOSNIFF
True
SECURE_CROSS_ORIGIN_OPENER_POLICY
'same-origin'
SECURE_HSTS_INCLUDE_SUBDOMAINS
False
SECURE_HSTS_PRELOAD
False
SECURE_HSTS_SECONDS
0
SECURE_PROXY_SSL_HEADER
('HTTP_X_FORWARDED_PROTO', 'https')
SECURE_REDIRECT_EXEMPT
[]
SECURE_REFERRER_POLICY
'same-origin'
SECURE_SSL_HOST
None
SECURE_SSL_REDIRECT
False
SELECT2_CACHE_BACKEND
'default'
SELECT2_CACHE_PREFIX
'select2_'
SELECT2_CSS
['admin/css/vendor/select2/select2.min.css']
SELECT2_I18N_AVAILABLE_LANGUAGES
['ar',
 'az',
 'bg',
 'ca',
 'cs',
 'da',
 'de',
 'el',
 'en',
 'es',
 'et',
 'eu',
 'fa',
 'fi',
 'fr',
 'gl',
 'he',
 'hi',
 'hr',
 'hu',
 'id',
 'is',
 'it',
 'ja',
 'km',
 'ko',
 'lt',
 'lv',
 'mk',
 'ms',
 'nb',
 'nl',
 'pl',
 'pt-BR',
 'pt',
 'ro',
 'ru',
 'sk',
 'sr-Cyrl',
 'sr',
 'sv',
 'th',
 'tr',
 'uk',
 'vi',
 'zh-CN',
 'zh-TW']
SELECT2_I18N_PATH
'admin/js/vendor/select2/i18n'
SELECT2_JS
['admin/js/vendor/select2/select2.full.min.js']
SELECT2_JSON_ENCODER
'django.core.serializers.json.DjangoJSONEncoder'
SELECT2_THEME
'default'
SERVER_EMAIL
'root@localhost'
SESSION_CACHE_ALIAS
'default'
SESSION_COOKIE_AGE
1209600
SESSION_COOKIE_DOMAIN
None
SESSION_COOKIE_HTTPONLY
True
SESSION_COOKIE_NAME
'sessionid'
SESSION_COOKIE_PATH
'/'
SESSION_COOKIE_SAMESITE
'Lax'
SESSION_COOKIE_SECURE
False
SESSION_ENGINE
'django.contrib.sessions.backends.db'
SESSION_EXPIRE_AT_BROWSER_CLOSE
True
SESSION_FILE_PATH
None
SESSION_SAVE_EVERY_REQUEST
False
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
SETTINGS_MODULE
'app.settings'
SHORT_DATETIME_FORMAT
'm/d/Y P'
SHORT_DATE_FORMAT
'm/d/Y'
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS
[]
SITE_ID
1
STATICFILES_DIRS
('/home/ringbase/django/static',)
STATICFILES_FINDERS
['django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT
'/home/ringbase/django/../staticfiles'
STATIC_URL
'/static/'
STORAGES
{'default': {'BACKEND': 'django.core.files.storage.FileSystemStorage'},
 'staticfiles': {'BACKEND': 'django.contrib.staticfiles.storage.StaticFilesStorage'}}
TEMPLATES
[{'BACKEND': 'django.template.backends.django.DjangoTemplates',
  'DIRS': ['/home/ringbase/django/templates'],
  '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',
                                     'django.template.context_processors.static',
                                     'app.context_processors.schemes_context_processor'],
              'loaders': ['django.template.loaders.filesystem.Loader',
                          'django.template.loaders.app_directories.Loader']}}]
TEST_NON_SERIALIZED_APPS
[]
TEST_RUNNER
'django.test.runner.DiscoverRunner'
THOUSAND_SEPARATOR
','
TIME_FORMAT
'P'
TIME_INPUT_FORMATS
['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
TIME_ZONE
'UTC'
USE_DEPRECATED_PYTZ
False
USE_I18N
True
USE_L10N
True
USE_THOUSAND_SEPARATOR
False
USE_TZ
True
USE_X_FORWARDED_HOST
False
USE_X_FORWARDED_PORT
False
WSGI_APPLICATION
'app.wsgi.application'
X_FRAME_OPTIONS
'DENY'
YEAR_MONTH_FORMAT
'F Y'

You’re seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard page generated by the handler for this status code.