Can´t login - error 500

ERPNext
1

ERPNext V13.3

Hi Everybody, this happened at the very moment when I was training someone to use ERPNext, completely randomly I am unable to login

My Traceback:

Traceback (most recent call last):
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/utils/jinja.py", line 85, in render_template
    return get_jenv().from_string(template).render(context)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/asyncsupport.py", line 76, in render
    return original_render(self, *args, **kwargs)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/environment.py", line 1008, in render
    return self.environment.handle_exception(exc_info, True)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/environment.py", line 780, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/_compat.py", line 37, in reraise
    raise value.with_traceback(tb)
  File "<template>", line 2, in top-level template code
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/sandbox.py", line 387, in getattr
    value = getattr(obj, attribute)
jinja2.exceptions.UndefinedError: 'desk_theme' is undefined

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/website/render.py", line 49, in render
    data = render_page_by_language(path)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/website/render.py", line 178, in render_page_by_language
    return render_page(path)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/website/render.py", line 194, in render_page
    return build(path)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/website/render.py", line 201, in build
    return build_page(path)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/website/render.py", line 219, in build_page
    html = frappe.render_template(context.source, context)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/utils/jinja.py", line 87, in render_template
    throw(title="Jinja Template Error", msg="<pre>{template}</pre><pre>{tb}</pre>".format(template=template, tb=get_traceback()))
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/__init__.py", line 427, in throw
    msgprint(msg, raise_exception=exc, title=title, indicator='red', is_minimizable=is_minimizable, wide=wide, as_list=as_list)
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/__init__.py", line 406, in msgprint
    _raise_exception()
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/__init__.py", line 360, in _raise_exception
    raise raise_exception(msg)
frappe.exceptions.ValidationError: <pre><!DOCTYPE html>
<html data-theme="{{ desk_theme.lower() }}">
	<head>
		<!-- Chrome, Firefox OS and Opera -->
		<meta name="theme-color" content="#0089FF">
		<!-- Windows Phone -->
		<meta name="msapplication-navbutton-color" content="#0089FF">
		<!-- iOS Safari -->
		<meta name="apple-mobile-web-app-status-bar-style" content="#0089FF">
		<meta content="text/html;charset=utf-8" http-equiv="Content-Type">
		<meta content="utf-8" http-equiv="encoding">
		<meta name="author" content="">
		<meta name="viewport" content="width=device-width, initial-scale=1.0,
			maximum-scale=1.0, minimum-scale=1.0, user-scalable=no, minimal-ui">
		<meta name="apple-mobile-web-app-capable" content="yes">
		<meta name="apple-mobile-web-app-status-bar-style" content="white">
		<meta name="mobile-web-app-capable" content="yes">
		<title>Frappe</title>
		<link rel="shortcut icon"
			href="{{ favicon or "/assets/frappe/images/frappe-favicon.svg" }}" type="image/x-icon">
		<link rel="icon"
			href="{{ favicon or "/assets/frappe/images/frappe-favicon.svg" }}" type="image/x-icon">
		{% for include in include_css -%}
		<link type="text/css" rel="stylesheet" href="{{ include }}?ver={{ build_version }}">
		{%- endfor -%}
	</head>
	<body>
		{% include "public/icons/timeless/symbol-defs.svg" %}
		<div class="centered splash">
			<img src="{{ splash_image or "/assets/frappe/images/frappe-framework-logo.png" }}"
				style="max-width: 100px; max-height: 100px;">
		</div>
		<div class="main-section">
			<header></header>
			<div id="body"></div>
			<footer></footer>
		</div>

		<script type="text/javascript" src="/assets/frappe/js/lib/jquery/jquery.min.js"></script>

		<script type="text/javascript">
		window._version_number = "{{ build_version }}";
		// browser support
		window.app = true;
		window.dev_server = {{ dev_server }};

		if(!window.frappe) window.frappe = {};

		frappe.boot = {{ boot }};

		frappe.csrf_token = "{{ csrf_token }}";

		</script>

		{% for include in include_js %}
		<script type="text/javascript" src="{{ include }}?ver={{ build_version }}"></script>
		{% endfor %}
		{% include "templates/includes/app_analytics/google_analytics.html" %}
		{% include "templates/includes/app_analytics/mixpanel_analytics.html" %}

		{% for sound in (sounds or []) %}
		<audio preload="auto" id="sound-{{ sound.name }}" volume={{ sound.volume or 1 }}>
			<source src="{{ sound.src }}"></source>
		</audio>
		{% endfor %}
	</body>
</html>
</pre><pre>Traceback (most recent call last):
  File "/opt/bitnami/apps/erpnext/htdocs/frappe-bench/apps/frappe/frappe/utils/jinja.py", line 85, in render_template
    return get_jenv().from_string(template).render(context)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/asyncsupport.py", line 76, in render
    return original_render(self, *args, **kwargs)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/environment.py", line 1008, in render
    return self.environment.handle_exception(exc_info, True)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/environment.py", line 780, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/_compat.py", line 37, in reraise
    raise value.with_traceback(tb)
  File "<template>", line 2, in top-level template code
  File "/opt/bitnami/apps/erpnext/htdocs/venv/lib/python3.7/site-packages/jinja2/sandbox.py", line 387, in getattr
    value = getattr(obj, attribute)
jinja2.exceptions.UndefinedError: 'desk_theme' is undefined
</pre>
2

So, my traceback show this error:

jinja2.exceptions.UndefinedError: 'desk_theme' is undefined

but i don´t find any result with it in google :slightly_frowning_face:

3

It appears you are using bitnami. The issue might be with bitnami’s copy.

4

I get this same error when changing the User language to french. When I log in as admin and change the users language back to english he can login again…

5

I had the same problem. I checked the language translation I found an empty translation when I deleted it the system worked again.

1 Like
6

Hello I am facing the same problem but when I logged in I did not see any option of translation

7

You may use the below command in bench mariadb as well:

alter table `tabUser` add column desk_theme varchar(140);

8

I just updated frappe from v13.51.3 to v13.57.3, and come across this same issue. No one can log into Desk.

I did:

  • checked language field in tabUser
  • desk_theme is already varchar(140)
  • I’m not using other language beside English
  • tabUser looks normal, and all fields are correct

Anyone got any update? I’m not sure what I did to trigger this.