My VPS has installed erpnext v15 with hrms and frappe designer.
already have have created purchase tax template but create a purchase order and when i select purchase tax template that time i have error below this
then i tried to bench migrate through the CLI , no result
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 1682, in call return fn(*args, **newargs) File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper return func(*args, **kwargs) File "apps/erpnext/erpnext/controllers/accounts_controller.py", line 3312, in update_child_qty_rate parent.save() File "apps/frappe/frappe/model/document.py", line 334, in save return self._save(*args, **kwargs) File "apps/frappe/frappe/model/document.py", line 369, in _save self._validate_links() File "apps/frappe/frappe/model/document.py", line 913, in _validate_links invalid_links, cancelled_links = self.get_invalid_links() File "apps/frappe/frappe/model/base_document.py", line 785, in get_invalid_links values = frappe.db.get_value(doctype, docname, values_to_fetch, as_dict=True) File "apps/frappe/frappe/database/database.py", line 516, in get_value result = self.get_values( File "apps/frappe/frappe/database/database.py", line 617, in get_values out = self._get_values_from_table( File "apps/frappe/frappe/database/database.py", line 884, 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 87, in execute_query result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep File "apps/frappe/frappe/database/database.py", line 235, 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 558, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 822, in _read_query_result result.read() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1200, in read first_packet = self.connection._read_packet() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 772, in _read_packet packet.raise_for_error() File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column '' in 'field list'") ### Request Data { "type": "POST", "args": { "parent_doctype": "Purchase Order", "trans_items": "[{\"docname\":\"d5b0661211\",\"name\":\"d5b0661211\",\"item_code\":\"001\",\"schedule_date\":\"2024-01-31\",\"conversion_factor\":1,\"qty\":200,\"rate\":220,\"uom\":\"Nos\",\"fg_item_qty\":0,\"idx\":1},{\"docname\":\"d37594ed5a\",\"name\":\"d37594ed5a\",\"item_code\":\"S001\",\"schedule_date\":\"2024-01-31\",\"conversion_factor\":1,\"qty\":500,\"rate\":130,\"uom\":\"Nos\",\"fg_item_qty\":0,\"idx\":2},{\"docname\":\"2440ac87c2\",\"name\":\"2440ac87c2\",\"item_code\":\"002\",\"schedule_date\":\"2024-01-31\",\"conversion_factor\":1,\"qty\":1400,\"rate\":111,\"uom\":\"Nos\",\"fg_item_qty\":0,\"idx\":3},{\"docname\":\"8daeb4d804\",\"name\":\"8daeb4d804\",\"item_code\":\"001\",\"schedule_date\":\"2024-01-30\",\"conversion_factor\":1,\"qty\":289,\"rate\":220,\"uom\":\"Nos\",\"fg_item_qty\":1,\"idx\":4}]", "parent_doctype_name": "PUR-ORD-2024-00002", "child_docname": "items" }, "freeze": true, "headers": {}, "error_handlers": {}, "url": "/api/method/erpnext.controllers.accounts_controller.update_child_qty_rate", "request_id": null } ### Response Data { "exception": "pymysql.err.OperationalError: (1054, \"Unknown column '' in 'field list'\")", "exc_type": "OperationalError", "_exc_source": "erpnext (app)" }
kindly guide me to claim this issue
Thanks for forum and someone