specify / specify7

Specify 7
https://www.specifysoftware.org/products/specify-7/
GNU General Public License v2.0
66 stars 36 forks source link

Querycbx search dialog doesn't open for agent field in the set agents for user dialog. #633

Closed maxpatiiuk closed 2 years ago

maxpatiiuk commented 4 years ago

Error when trying to search for an agent for a user

Screen Shot 2020-03-13 at 2 41 55 PM

OperationalError at /api/delete_blockers/specifyuser/1/
(1054, "Unknown column 'taxon.TaxonAttributeID' in 'field list'")

Request Method: GET
Request URL: http://db3.biwebdbtest.nhm.ku.edu/api/delete_blockers/specifyuser/1/
Django Version: 1.10.2
Python Executable: /usr/bin/python
Python Version: 2.7.15
Python Path: ['/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/home/anhalt/servers/db3', '/home/anhalt/servers/db3/Specify7']
Server time: Tue, 17 Mar 2020 14:37:37 -0500
Installed Applications:
('django.contrib.sessions',
 'django.contrib.staticfiles',
 'django.contrib.contenttypes',
 'django.contrib.auth',
 'specifyweb.specify',
 'specifyweb.stored_queries',
 'specifyweb.businessrules',
 'specifyweb.express_search',
 'specifyweb.context',
 'specifyweb.attachment_gw',
 'specifyweb.frontend',
 'specifyweb.barvis',
 'specifyweb.report_runner',
 'specifyweb.interactions',
 'specifyweb.workbench',
 'specifyweb.notifications',
 'specifyweb.export',
 'specifyweb.raven_placeholder')
Installed Middleware:
('django.middleware.gzip.GZipMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'specifyweb.context.middleware.ContextMiddleware')

Traceback:  

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/core/handlers/exception.py" in inner
  39.             response = get_response(request)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/core/handlers/base.py" in _legacy_get_response
  249.             response = self._get_response(request)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  187.                 response = self.process_exception_by_middleware(e, request)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/core/handlers/base.py" in _get_response
  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/home/anhalt/servers/db3/Specify7/specifyweb/specify/views.py" in wrapped
  22.             return view(request, *args, **kwargs)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/views/decorators/http.py" in inner
  40.             return func(request, *args, **kwargs)

File "/home/anhalt/servers/db3/Specify7/specifyweb/specify/views.py" in delete_blockers
  67.     collector.collect([obj])

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/deletion.py" in collect
  222.                     elif sub_objs:

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/query.py" in __nonzero__
  264.         return type(self).__bool__(self)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/query.py" in __bool__
  260.         self._fetch_all()

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
  1087.             self._result_cache = list(self.iterator())

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/query.py" in __iter__
  54.         results = compiler.execute_sql()

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
  835.             cursor.execute(sql, params)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  79.             return super(CursorDebugWrapper, self).execute(sql, params)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  64.                 return self.cursor.execute(sql, params)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/utils.py" in __exit__
  94.                 six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  64.                 return self.cursor.execute(sql, params)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/django/db/backends/mysql/base.py" in execute
  110.             return self.cursor.execute(query, args)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/MySQLdb/cursors.py" in execute
  250.             self.errorhandler(self, exc, value)

File "/home/anhalt/servers/db3/Specify7/virtualenv/lib/python2.7/site-packages/MySQLdb/connections.py" in defaulterrorhandler
  50.         raise errorvalue

Exception Type: OperationalError at /api/delete_blockers/specifyuser/1/
Exception Value: (1054, "Unknown column 'taxon.TaxonAttributeID' in 'field list'")
Request information:
USER: Specifyuser object

GET: No GET data

POST: No POST data

FILES: No FILES data

COOKIES:
csrftoken = 'LEbHYq0OlH23az9RAupG4tRqQJRlFX1S636mCaVIl65gTp2YjlMn5BA3Qxy9iSca'
1.taxon.1.default_initial_conformation = '~-'
sessionid = '4d17kx1lw8qwiqq7x17quxdo5y8canj2'
collection = '4'

META:
CONTEXT_DOCUMENT_ROOT = '/var/www/html'
CONTEXT_PREFIX = ''
CSRF_COOKIE = 'LEbHYq0OlH23az9RAupG4tRqQJRlFX1S636mCaVIl65gTp2YjlMn5BA3Qxy9iSca'
DOCUMENT_ROOT = '/var/www/html'
GATEWAY_INTERFACE = 'CGI/1.1'
HTTP_ACCEPT = '*/*'
HTTP_ACCEPT_ENCODING = 'gzip, deflate'
HTTP_ACCEPT_LANGUAGE = 'en-US,en;q=0.9,uk;q=0.8,ru;q=0.7'
HTTP_CONNECTION = 'keep-alive'
HTTP_COOKIE = 'collection=4; csrftoken=LEbHYq0OlH23az9RAupG4tRqQJRlFX1S636mCaVIl65gTp2YjlMn5BA3Qxy9iSca; sessionid=4d17kx1lw8qwiqq7x17quxdo5y8canj2; 1.taxon.1.default_initial_conformation=~-'
HTTP_HOST = 'db3.biwebdbtest.nhm.ku.edu'
HTTP_REFERER = 'http://db3.biwebdbtest.nhm.ku.edu/specify/view/specifyuser/1/'
HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.17 Safari/537.36'
HTTP_X_REQUESTED_WITH = 'XMLHttpRequest'
PATH_INFO = u'/api/delete_blockers/specifyuser/1/'
PATH_TRANSLATED = '/home/anhalt/servers/db3/specify.wsgi/api/delete_blockers/specifyuser/1/'
QUERY_STRING = ''
REMOTE_ADDR = '129.237.183.40'
REMOTE_PORT = '54822'
REQUEST_METHOD = 'GET'
REQUEST_SCHEME = 'http'
REQUEST_URI = '/api/delete_blockers/specifyuser/1/'
SCRIPT_FILENAME = '/home/anhalt/servers/db3/specify.wsgi'
SCRIPT_NAME = u''
SERVER_ADDR = '10.101.225.56'
SERVER_ADMIN = '[no address given]'
SERVER_NAME = 'db3.biwebdbtest.nhm.ku.edu'
SERVER_PORT = '80'
SERVER_PROTOCOL = 'HTTP/1.1'
SERVER_SIGNATURE = '<address>Apache/2.4.29 (Ubuntu) Server at db3.biwebdbtest.nhm.ku.edu Port 80</address>\n'
SERVER_SOFTWARE = 'Apache/2.4.29 (Ubuntu)'
apache.version = 
mod_wsgi.application_group = 'db3.biwebdbtest.nhm.ku.edu|'
mod_wsgi.callable_object = 'application'
mod_wsgi.daemon_connects = '1'
mod_wsgi.daemon_restarts = '0'
mod_wsgi.daemon_start = '1584473857018447'
mod_wsgi.enable_sendfile = '0'
mod_wsgi.handler_script = ''
mod_wsgi.ignore_activity = '0'
mod_wsgi.listener_host = ''
mod_wsgi.listener_port = '80'
mod_wsgi.path_info = '/api/delete_blockers/specifyuser/1/'
mod_wsgi.process_group = 'db3'
mod_wsgi.queue_start = '1584473857018225'
mod_wsgi.request_handler = 'wsgi-script'
mod_wsgi.request_id = 'rEhnEbJN9uk'
mod_wsgi.request_start = '1584473857018028'
mod_wsgi.script_name = ''
mod_wsgi.script_reloading = '1'
mod_wsgi.script_start = '1584473857019503'
mod_wsgi.thread_id = 6
mod_wsgi.thread_requests = 6L
mod_wsgi.total_requests = 31L
mod_wsgi.version = 
wsgi.errors = <mod_wsgi.Log object at 0x7f56bc6fde40>
wsgi.file_wrapper = ''
wsgi.input = <mod_wsgi.Input object at 0x7f56bc62d490>
wsgi.multiprocess = False
wsgi.multithread = True
wsgi.run_once = False
wsgi.url_scheme = 'http'
wsgi.version = 

Settings:
Using settings module specifyweb.settings
ABSOLUTE_URL_OVERRIDES = {}
ADMINS = 
ADMIN_MEDIA_PREFIX = '/static/admin/'
ALLOWED_HOSTS = ['*']
ALLOW_SPECIFY6_PASSWORDS = u'********************'
ALLOW_SUPPORT_LOGIN = True
ANONYMOUS_USER = None
APPEND_SLASH = True
AUTHENTICATION_BACKENDS = ['specifyweb.specify.support_login.SupportLoginBackend', 'django.contrib.auth.backends.ModelBackend']
AUTH_LDAP_SERVER_URI = None
AUTH_PASSWORD_VALIDATORS = u'********************'
AUTH_USER_MODEL = 'specify.Specifyuser'
CACHES = {u'default': {u'BACKEND': u'django.core.cache.backends.locmem.LocMemCache'}}
CACHE_MIDDLEWARE_ALIAS = u'default'
CACHE_MIDDLEWARE_KEY_PREFIX = u'********************'
CACHE_MIDDLEWARE_SECONDS = 600
CSRF_COOKIE_AGE = 31449600
CSRF_COOKIE_DOMAIN = None
CSRF_COOKIE_HTTPONLY = False
CSRF_COOKIE_NAME = u'csrftoken'
CSRF_COOKIE_PATH = u'/'
CSRF_COOKIE_SECURE = False
CSRF_FAILURE_VIEW = u'django.views.csrf.csrf_failure'
CSRF_HEADER_NAME = u'HTTP_X_CSRFTOKEN'
CSRF_TRUSTED_ORIGINS = []
DATABASES = {'default': {'ENGINE': 'specifyweb.hibernateboolsbackend.backends.mysql', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': u'Brown', 'CONN_MAX_AGE': 0, 'TIME_ZONE': None, 'PORT': '', 'HOST': 'localhost', 'USER': 'MasterUser', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'********************', 'OPTIONS': {}}}
DATABASE_HOST = 'localhost'
DATABASE_NAME = u'Brown'
DATABASE_PORT = ''
DATABASE_ROUTERS = []
DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
DATETIME_FORMAT = u'N j, Y, P'
DATETIME_INPUT_FORMATS = [u'%Y-%m-%d %H:%M:%S', u'%Y-%m-%d %H:%M:%S.%f', u'%Y-%m-%d %H:%M', u'%Y-%m-%d', u'%m/%d/%Y %H:%M:%S', u'%m/%d/%Y %H:%M:%S.%f', u'%m/%d/%Y %H:%M', u'%m/%d/%Y', u'%m/%d/%y %H:%M:%S', u'%m/%d/%y %H:%M:%S.%f', u'%m/%d/%y %H:%M', u'%m/%d/%y']
DATE_FORMAT = u'N j, Y'
DATE_INPUT_FORMATS = [u'%Y-%m-%d', u'%m/%d/%Y', u'%m/%d/%y', u'%b %d %Y', u'%b %d, %Y', u'%d %b %Y', u'%d %b, %Y', u'%B %d %Y', u'%B %d, %Y', u'%d %B %Y', u'%d %B, %Y']
DEBUG = True
DEBUG_PROPAGATE_EXCEPTIONS = False
DECIMAL_SEPARATOR = u'.'
DEFAULT_CHARSET = u'utf-8'
DEFAULT_CONTENT_TYPE = u'text/html'
DEFAULT_EXCEPTION_REPORTER_FILTER = u'django.views.debug.SafeExceptionReporterFilter'
DEFAULT_FILE_STORAGE = u'django.core.files.storage.FileSystemStorage'
DEFAULT_FROM_EMAIL = u'webmaster@localhost'
DEFAULT_INDEX_TABLESPACE = u''
DEFAULT_TABLESPACE = u''
DEPOSITORY_DIR = '/home/anhalt/specify-depository'
DISALLOWED_USER_AGENTS = []
EMAIL_BACKEND = u'django.core.mail.backends.smtp.EmailBackend'
EMAIL_HOST = u'localhost'
EMAIL_HOST_PASSWORD = u'********************'
EMAIL_HOST_USER = u''
EMAIL_PORT = 25
EMAIL_SSL_CERTFILE = None
EMAIL_SSL_KEYFILE = u'********************'
EMAIL_SUBJECT_PREFIX = u'[Django] '
EMAIL_TIMEOUT = None
EMAIL_USE_SSL = False
EMAIL_USE_TLS = False
FILE_CHARSET = u'utf-8'
FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
FILE_UPLOAD_HANDLERS = [u'django.core.files.uploadhandler.MemoryFileUploadHandler', u'django.core.files.uploadhandler.TemporaryFileUploadHandler']
FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
FILE_UPLOAD_PERMISSIONS = None
FILE_UPLOAD_TEMP_DIR = None
FIRST_DAY_OF_WEEK = 0
FIXTURE_DIRS = []
FORCE_SCRIPT_NAME = None
FORMAT_MODULE_PATH = None
IGNORABLE_404_URLS = []
INSTALLED_APPS = 
INTERNAL_IPS = []
JAVA_PATH = '/usr/bin/java'
LANGUAGES = [(u'af', u'Afrikaans'), (u'ar', u'Arabic'), (u'ast', u'Asturian'), (u'az', u'Azerbaijani'), (u'bg', u'Bulgarian'), (u'be', u'Belarusian'), (u'bn', u'Bengali'), (u'br', u'Breton'), (u'bs', u'Bosnian'), (u'ca', u'Catalan'), (u'cs', u'Czech'), (u'cy', u'Welsh'), (u'da', u'Danish'), (u'de', u'German'), (u'dsb', u'Lower Sorbian'), (u'el', u'Greek'), (u'en', u'English'), (u'en-au', u'Australian English'), (u'en-gb', u'British English'), (u'eo', u'Esperanto'), (u'es', u'Spanish'), (u'es-ar', u'Argentinian Spanish'), (u'es-co', u'Colombian Spanish'), (u'es-mx', u'Mexican Spanish'), (u'es-ni', u'Nicaraguan Spanish'), (u'es-ve', u'Venezuelan Spanish'), (u'et', u'Estonian'), (u'eu', u'Basque'), (u'fa', u'Persian'), (u'fi', u'Finnish'), (u'fr', u'French'), (u'fy', u'Frisian'), (u'ga', u'Irish'), (u'gd', u'Scottish Gaelic'), (u'gl', u'Galician'), (u'he', u'Hebrew'), (u'hi', u'Hindi'), (u'hr', u'Croatian'), (u'hsb', u'Upper Sorbian'), (u'hu', u'Hungarian'), (u'ia', u'Interlingua'), (u'id', u'Indonesian'), (u'io', u'Ido'), (u'is', u'Icelandic'), (u'it', u'Italian'), (u'ja', u'Japanese'), (u'ka', u'Georgian'), (u'kk', u'Kazakh'), (u'km', u'Khmer'), (u'kn', u'Kannada'), (u'ko', u'Korean'), (u'lb', u'Luxembourgish'), (u'lt', u'Lithuanian'), (u'lv', u'Latvian'), (u'mk', u'Macedonian'), (u'ml', u'Malayalam'), (u'mn', u'Mongolian'), (u'mr', u'Marathi'), (u'my', u'Burmese'), (u'nb', u'Norwegian Bokm\xe5l'), (u'ne', u'Nepali'), (u'nl', u'Dutch'), (u'nn', u'Norwegian Nynorsk'), (u'os', u'Ossetic'), (u'pa', u'Punjabi'), (u'pl', u'Polish'), (u'pt', u'Portuguese'), (u'pt-br', u'Brazilian Portuguese'), (u'ro', u'Romanian'), (u'ru', u'Russian'), (u'sk', u'Slovak'), (u'sl', u'Slovenian'), (u'sq', u'Albanian'), (u'sr', u'Serbian'), (u'sr-latn', u'Serbian Latin'), (u'sv', u'Swedish'), (u'sw', u'Swahili'), (u'ta', u'Tamil'), (u'te', u'Telugu'), (u'th', u'Thai'), (u'tr', u'Turkish'), (u'tt', u'Tatar'), (u'udm', u'Udmurt'), (u'uk', u'Ukrainian'), (u'ur', u'Urdu'), (u'vi', u'Vietnamese'), (u'zh-hans', u'Simplified Chinese'), (u'zh-hant', u'Traditional Chinese')]
LANGUAGES_BIDI = [u'he', u'ar', u'fa', u'ur']
LANGUAGE_CODE = 'en-us'
LANGUAGE_COOKIE_AGE = None
LANGUAGE_COOKIE_DOMAIN = None
LANGUAGE_COOKIE_NAME = u'django_language'
LANGUAGE_COOKIE_PATH = u'/'
LOCALE_PATHS = []
LOGGING = {'loggers': {'specifyweb': {'handlers': ['logfile'], 'propagate': True, 'level': 'DEBUG'}, 'django.request': {'handlers': ['mail_admins', 'logfile'], 'propagate': True, 'level': 'DEBUG'}}, 'disable_existing_loggers': True, 'handlers': {'logfile': {'backupCount': 10, 'level': 'DEBUG', 'filename': u'/home/anhalt/logs/Brown.log', 'formatter': 'standard', 'class': 'logging.handlers.RotatingFileHandler', 'maxBytes': 1048576}, 'console': {'class': 'logging.StreamHandler', 'level': 'DEBUG'}, 'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'filters': ['require_debug_false'], 'level': 'ERROR'}}, 'formatters': {'standard': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] [%(levelname)s] [%(name)s:%(lineno)s] %(message)s'}}, 'version': 1, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}}
LOGGING_CONFIG = u'logging.config.dictConfig'
LOGIN_REDIRECT_URL = '/'
LOGIN_URL = u'/accounts/login/'
LOGOUT_REDIRECT_URL = None
MANAGERS = 
MASTER_NAME = 'MasterUser'
MASTER_PASSWORD = u'********************'
MEDIA_ROOT = ''
MEDIA_URL = ''
MESSAGE_STORAGE = u'django.contrib.messages.storage.fallback.FallbackStorage'
MIDDLEWARE = None
MIDDLEWARE_CLASSES = 
MIGRATION_MODULES = {}
MONTH_DAY_FORMAT = u'F j'
NOTIFICATION_TTL_DAYS = 7
NUMBER_GROUPING = 0
PASSWORD_HASHERS = u'********************'
PASSWORD_RESET_TIMEOUT_DAYS = u'********************'
PREPEND_WWW = False
RAVEN_CONFIG = None
REPORT_RUNNER_HOST = 'localhost'
REPORT_RUNNER_PORT = '9999'
ROOT_URLCONF = 'specifyweb.urls'
RO_MODE = False
SA_DATABASE_URL = u'mysql://MasterUser:MasterPassword@localhost:3306/Brown?charset=utf8'
SA_POOL_RECYCLE = 3600
SCHEMA_LANGUAGE = 'en'
SECRET_KEY = u'********************'
SECURE_BROWSER_XSS_FILTER = False
SECURE_CONTENT_TYPE_NOSNIFF = False
SECURE_HSTS_INCLUDE_SUBDOMAINS = False
SECURE_HSTS_SECONDS = 0
SECURE_PROXY_SSL_HEADER = None
SECURE_REDIRECT_EXEMPT = []
SECURE_SSL_HOST = None
SECURE_SSL_REDIRECT = False
SERVER_EMAIL = u'root@localhost'
SESSION_CACHE_ALIAS = u'default'
SESSION_COOKIE_AGE = 1209600
SESSION_COOKIE_DOMAIN = None
SESSION_COOKIE_HTTPONLY = True
SESSION_COOKIE_NAME = u'sessionid'
SESSION_COOKIE_PATH = u'/'
SESSION_COOKIE_SECURE = False
SESSION_ENGINE = 'django.contrib.sessions.backends.file'
SESSION_EXPIRE_AT_BROWSER_CLOSE = True
SESSION_FILE_PATH = None
SESSION_SAVE_EVERY_REQUEST = False
SESSION_SERIALIZER = u'django.contrib.sessions.serializers.JSONSerializer'
SETTINGS_MODULE = 'specifyweb.settings'
SHORT_DATETIME_FORMAT = u'm/d/Y P'
SHORT_DATE_FORMAT = u'm/d/Y'
SIGNING_BACKEND = u'django.core.signing.TimestampSigner'
SILENCED_SYSTEM_CHECKS = []
SITE_ID = 1
SPECIFY_CONFIG_DIR = '/home/anhalt/servers/db3/Specify6/config'
SPECIFY_THICK_CLIENT = '/home/anhalt/servers/db3/Specify6'
STATICFILES_DIRS = ('config', '/home/anhalt/servers/db3/Specify6/config')
STATICFILES_FINDERS = 
STATICFILES_STORAGE = u'django.contrib.staticfiles.storage.StaticFilesStorage'
STATIC_ROOT = ''
STATIC_URL = '/static/'
STATS_URL = None
SUPPORT_LOGIN_TTL = 300
TEMPLATES = [{'DIRS': [], 'APP_DIRS': True, 'OPTIONS': {'context_processors': ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages']}, 'BACKEND': 'django.template.backends.django.DjangoTemplates'}]
TESTING = False
TESTING_DATABASES = {'default': {'ENGINE': 'django.db.backends.sqlite3', 'NAME': 'specifytest', 'HOST': '127.0.0.1', 'USER': 'Master', 'PASSWORD': u'********************', 'PORT': '3307'}}
TEST_NON_SERIALIZED_APPS = []
TEST_RUNNER = u'django.test.runner.DiscoverRunner'
THICK_CLIENT_LOCATION = '/home/anhalt/servers/db3/Specify6'
THOUSAND_SEPARATOR = u','
TIME_FORMAT = u'P'
TIME_INPUT_FORMATS = [u'%H:%M:%S', u'%H:%M:%S.%f', u'%H:%M']
TIME_ZONE = 'America/Chicago'
USE_ETAGS = False
USE_I18N = True
USE_L10N = True
USE_THOUSAND_SEPARATOR = False
USE_TZ = False
USE_X_FORWARDED_HOST = False
USE_X_FORWARDED_PORT = False
VERSION = 'v7.3.1-69-g5065ba20(debug)'
WB_UPLOAD_LOG_DIR = '/home/anhalt/wbuploadlog'
WEB_ATTACHMENT_COLLECTION = 'KUFishvoucher'
WEB_ATTACHMENT_KEY = u'********************'
WEB_ATTACHMENT_REQUIRES_KEY_FOR_GET = u'********************'
WEB_ATTACHMENT_URL = None
WSGI_APPLICATION = None
X_FRAME_OPTIONS = u'SAMEORIGIN'
YEAR_MONTH_FORMAT = u'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.
benanhalt commented 4 years ago

This looks like a schema mismatch. Is that database updated to 6.8.00?

maxpatiiuk commented 4 years ago

Still happens. Tested in TestBiology10 (it is 6.8)

benanhalt commented 4 years ago

I just tried it on biwebdbtest with TestBiology10 and it worked fine for me. Added an new agent foobar and then a new user foobar and searched for the just created agent by name and set it.

maxpatiiuk commented 4 years ago

I uploaded the video of this error here: https://youtu.be/7X052AyspUc

benanhalt commented 4 years ago

Okay I see. I was trying to get the OperationalError at /api/delete_blockers/specifyuser/1/ (1054, "Unknown column 'taxon.TaxonAttributeID' in 'field list'") exception. The actual problem is that the agent search dialog doesn't open.

maxpatiiuk commented 3 years ago

I don't get the back-end exception anymore, but this front-end exception still happens and the search dialog does not open:

Screen Shot 2021-06-16 at 8 56 09 PM

@Ben, it seems like the error is caused by this commit - https://github.com/specify/specify7/commit/fac8e20bee37633d0402d06954074b4b6a9fe46b