Skip to content

NotSupportedError when using the search filter in the User admin

Sentry Issue: ARKINDEX-BACKEND-13C

FeatureNotSupported: nondeterministic collations are not supported for LIKE

  File "django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)

NotSupportedError: nondeterministic collations are not supported for LIKE

(18 additional frame(s) were not displayed)
...
  File "django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  1. Open the Django admin page for users
  2. Type something in the search field and press Enter
  3. Cry