Hello Everyone
We have recently using postgres with frappe version 15 ,
we are doing integrations with react app , sometimes we get responded by
[\"Error in query:\\ncolumn \\\"doctype\\\" of relation \\\"tabDefaultValue\\\" does not exist\\nLINE 1: ...\\\", \\\"modified\\\", \\\"modified_by\\\", \\\"docstatus\\\", \\\"idx\\\", \\\"doctype\\\",...\\n ^\\n\"]"
also after login sometimes we got a message saying
HINT: Perhaps you meant to reference the column "tabNotification Log.type".
with traceback:
{
"frappe": "15.18.0",
"frappe_types": "0.0.1",
}
### Route
Workspaces/Services
### Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 110, in application
response = frappe.api.handle(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api/__init__.py", line 49, in handle
data = endpoint(**arguments)
^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
return frappe.handler.handle()
^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 49, 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 1718, in call
return fn(*args, **newargs)
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/desk/doctype/notification_log/notification_log.py", line 167, in get_notification_logs
notification_logs = frappe.db.get_list(
^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/database.py", line 765, in get_list
return frappe.get_list(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1982, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 192, in execute
result = self.build_and_run()
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 233, in build_and_run
return frappe.db.sql(
^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/postgres/database.py", line 208, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/database.py", line 234, in sql
self._cursor.execute(query, values)
psycopg2.errors.UndefinedColumn: column "doctype" does not exist
LINE 1: ...", "modified", "modified_by", "docstatus", "idx", "doctype",...
^
HINT: Perhaps you meant to reference the column "tabNotification Log.type".
### Request Data
{
"type": "POST",
"args": {
"limit": 20
},
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.doctype.notification_log.notification_log.get_notification_logs",
"request_id": null
}
### Response Data
{
"exception": "",
"exc_type": "UndefinedColumn",
"_debug_messages": "[\"Error in query:\\ncolumn \\\"doctype\\\" does not exist\\nLINE 1: ...\\\", \\\"modified\\\", \\\"modified_by\\\", \\\"docstatus\\\", \\\"idx\\\", \\\"doctype\\\",...\\n ^\\nHINT: Perhaps you meant to reference the column \\\"tabNotification Log.type\\\".\\n\"]"
}
How to resolve those issues? or what is root cause to able to fix??
Thanks All in advance