Uncaught Server Exception how to fix this

ERPNext Support
1

I have recenlty setup erp frappe next14 ubuntu 22:04 lts and using old frappenext13 databased for restore after restore i have received following error

Traceback (most recent call last):

File “apps/frappe/frappe/www/app.py”, line 29, in get_context
boot = frappe.sessions.get()
File “apps/frappe/frappe/sessions.py”, line 155, in get
bootinfo = get_bootinfo()
File “apps/frappe/frappe/boot.py”, line 52, in get_bootinfo
load_desktop_data(bootinfo)
File “apps/frappe/frappe/boot.py”, line 140, in load_desktop_data
bootinfo.allowed_workspaces = get_workspace_sidebar_items().get(“pages”)
File “apps/frappe/frappe/desk/desktop.py”, line 446, in get_workspace_sidebar_items
all_pages = frappe.get_all(
File “apps/frappe/frappe/init.py”, line 1938, in get_all
return get_list(doctype, *args, **kwargs)
File “apps/frappe/frappe/init.py”, line 1910, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
File “apps/frappe/frappe/model/db_query.py”, line 191, in execute
result = self.build_and_run()
File “apps/frappe/frappe/model/db_query.py”, line 232, in build_and_run
return frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 244, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 825, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1199, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘title’ in ‘field list’”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “apps/frappe/frappe/website/serve.py”, line 18, in get_response
response = renderer_instance.render()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 84, in render
html = self.get_html()
File “apps/frappe/frappe/website/utils.py”, line 517, in cache_html_decorator
html = func(*args, **kwargs)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 95, in get_html
self.update_context()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 163, in update_context
data = self.run_pymodule_method(“get_context”)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 223, in run_pymodule_method
return method(self.context)
File “apps/frappe/frappe/www/app.py”, line 31, in get_context
raise frappe.SessionBootFailed from e
frappe.exceptions.SessionBootFailed

Screenshot_2
Screenshot_21353×607 41.6 KB

2

Check Title Field Technical Name, its a naming issue

3

Traceback (most recent call last):
File “apps/frappe/frappe/www/app.py”, line 29, in get_context
boot = frappe.sessions.get()
File “apps/frappe/frappe/sessions.py”, line 155, in get
bootinfo = get_bootinfo()
File “apps/frappe/frappe/boot.py”, line 52, in get_bootinfo
load_desktop_data(bootinfo)
File “apps/frappe/frappe/boot.py”, line 140, in load_desktop_data
bootinfo.allowed_workspaces = get_workspace_sidebar_items().get(“pages”)
File “apps/frappe/frappe/desk/desktop.py”, line 446, in get_workspace_sidebar_items
all_pages = frappe.get_all(
File “apps/frappe/frappe/init.py”, line 1938, in get_all
return get_list(doctype, *args, **kwargs)
File “apps/frappe/frappe/init.py”, line 1910, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
File “apps/frappe/frappe/model/db_query.py”, line 191, in execute
result = self.build_and_run()
File “apps/frappe/frappe/model/db_query.py”, line 232, in build_and_run
return frappe.db.sql(
File “apps/frappe/frappe/database/database.py”, line 244, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 825, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1199, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 775, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 150, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘parent_page’ in ‘field list’”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “apps/frappe/frappe/website/serve.py”, line 18, in get_response
response = renderer_instance.render()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 84, in render
html = self.get_html()
File “apps/frappe/frappe/website/utils.py”, line 517, in cache_html_decorator
html = func(*args, **kwargs)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 95, in get_html
self.update_context()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 163, in update_context
data = self.run_pymodule_method(“get_context”)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 223, in run_pymodule_method
return method(self.context)
File “apps/frappe/frappe/www/app.py”, line 31, in get_context
raise frappe.SessionBootFailed from e
frappe.exceptions.SessionBootFailed

this new error

4

The error message indicates that ERPNext is failing to boot due to a missing column parent_page in the database.

  1. Either it is missing in DB
  2. Or it is used in code but not called properly.
5

Traceback (most recent call last):
File “apps/frappe/frappe/website/serve.py”, line 18, in get_response
response = renderer_instance.render()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 84, in render
html = self.get_html()
File “apps/frappe/frappe/website/utils.py”, line 517, in cache_html_decorator
html = func(*args, **kwargs)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 101, in get_html
html = self.render_template()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 236, in render_template
html = frappe.render_template(self.source, self.context, safe_render=safe_render)
File “apps/frappe/frappe/utils/jinja.py”, line 94, in render_template
return get_jenv().from_string(template).render(context)
File “env/lib/python3.10/site-packages/jinja2/environment.py”, line 1295, in render
self.environment.handle_exception()
File “env/lib/python3.10/site-packages/jinja2/environment.py”, line 942, in handle_exception
raise rewrite_traceback_stack(source=source)
File “”, line 2, in top-level template code
File “apps/frappe/frappe/templates/web.html”, line 1, in top-level template code
{% extends base_template_path %}
File “apps/frappe/frappe/templates/base.html”, line 70, in top-level template code
{% block content %}
File “apps/frappe/frappe/templates/web.html”, line 63, in block ‘content’
{{ main_content() }}
File “env/lib/python3.10/site-packages/jinja2/sandbox.py”, line 401, in call
return __context.call(__obj, *args, **kwargs)
File “env/lib/python3.10/site-packages/jinja2/runtime.py”, line 784, in _invoke
rv = self.func(*arguments)
File “apps/frappe/frappe/templates/web.html”, line 15, in template
{% block page_container %}
File “apps/frappe/frappe/templates/web.html”, line 30, in block ‘page_container’
{%- block page_content -%}{%- endblock -%}
File “”, line 63, in block ‘page_content’
File “env/lib/python3.10/site-packages/jinja2/sandbox.py”, line 401, in call
return __context.call(__obj, *args, **kwargs)
File “apps/frappe/frappe/database/database.py”, line 865, in get_single_value
frappe.throw((“Invalid field name: {0}”).format(frappe.bold(fieldname)), self.InvalidColumnName)
File “apps/frappe/frappe/init.py”, line 548, in throw
msgprint(
File “apps/frappe/frappe/init.py”, line 509, in msgprint
_raise_exception()
File “apps/frappe/frappe/init.py”, line 455, in _raise_exception
raise raise_exception(msg)
frappe.database.database.Database.InvalidColumnName: Invalid field name: show_account_deletion_link

can you please provide more deatils to fix this issue

6

i also got this error first i restart my pc and also restart bench and then migrate it after that i resolve this error if you still got then ask deepseek

7

Instead of posting error. Can you paste your code here?