App Versions
{
"frappe": "14.40.0"
}
Route
Workspaces/Support (IUMS InCharge Desk)
Traceback
Error in query:
column tabDocType.parent does not exist
LINE 1: ...ECT * FROM "tabDocPerm" LEFT JOIN "tabDocType" ON "tabDocTyp...
^
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 66, in application
response = frappe.api.handle()
File "apps/frappe/frappe/api.py", line 54, in handle
return frappe.handler.handle()
File "apps/frappe/frappe/handler.py", line 47, in handle
data = execute_cmd(cmd)
File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "apps/frappe/frappe/__init__.py", line 1608, in call
return fn(*args, **newargs)
File "apps/frappe/frappe/desk/form/load.py", line 73, in getdoctype
docs = get_meta_bundle(doctype)
File "apps/frappe/frappe/desk/form/load.py", line 84, in get_meta_bundle
bundle = [frappe.desk.form.meta.get_meta(doctype)]
File "apps/frappe/frappe/desk/form/meta.py", line 45, in get_meta
meta = FormMeta(doctype)
File "apps/frappe/frappe/desk/form/meta.py", line 55, in __init__
super().__init__(doctype)
File "apps/frappe/frappe/model/meta.py", line 117, in __init__
super().__init__("DocType", doctype)
File "apps/frappe/frappe/model/document.py", line 106, in __init__
self.load_from_db()
File "apps/frappe/frappe/model/meta.py", line 123, in load_from_db
super().load_from_db()
File "apps/frappe/frappe/model/document.py", line 165, in load_from_db
frappe.db.get_values(
File "apps/frappe/frappe/database/database.py", line 607, in get_values
out = self._get_values_from_table(
File "apps/frappe/frappe/database/database.py", line 837, in _get_values_from_table
return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
File "apps/frappe/frappe/query_builder/utils.py", line 76, in execute_query
return frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File "apps/frappe/frappe/database/postgres/database.py", line 199, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
File "apps/frappe/frappe/database/database.py", line 221, in sql
self._cursor.execute(query, values)
psycopg2.errors.UndefinedColumn: column tabDocType.parent does not exist
LINE 1: ...ECT * FROM "tabDocPerm" LEFT JOIN "tabDocType" ON "tabDocTyp...
^
Request Data
{
"type": "GET",
"args": {
"doctype": "Support EXP",
"with_parent": 1,
"cached_timestamp": null
},
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.form.load.getdoctype"
}
Response Data
{
"exception": ""
}
Getting this bug on a workspace