Getting the below error whenever I try to add webshop items
Please help
{ "crm": "1.41.1", "erpnext": "15.59.0", "frappe": "15.66.1", "frappe_whatsapp": "1.0.7", "payments": "0.0.1", "webshop": "0.0.1" } ``` ### Route ``` Form/Website Item/new-website-item-itihgyzkrh ``` ### Traceback ``` Traceback (most recent call last): File "apps/frappe/frappe/app.py", line 115, 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 51, in handle data = execute_cmd(cmd) ^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/handler.py", line 84, in execute_cmd return frappe.call(method, **frappe.form_dict) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/__init__.py", line 1739, 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/form/save.py", line 39, in savedocs doc.save() File "apps/frappe/frappe/model/document.py", line 378, in save return self._save(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/model/document.py", line 400, in _save return self.insert() ^^^^^^^^^^^^^ File "apps/frappe/frappe/model/document.py", line 309, in insert self.run_before_save_methods() File "apps/frappe/frappe/model/document.py", line 1136, in run_before_save_methods self.run_method("validate") File "apps/frappe/frappe/model/document.py", line 1007, in run_method out = Document.hook(fn)(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/model/document.py", line 1367, in composer return composed(self, method, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/model/document.py", line 1349, in runner add_to_return_value(self, fn(self, *args, **kwargs)) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/model/document.py", line 1004, in fn return method_object(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/webshop/webshop/webshop/doctype/website_item/website_item.py", line 56, in validate super(WebsiteItem, self).validate() File "apps/frappe/frappe/website/website_generator.py", line 36, in validate self.set_route() File "apps/frappe/frappe/website/website_generator.py", line 40, in set_route self.route = self.make_route() ^^^^^^^^^^^^^^^^^ File "apps/webshop/webshop/webshop/doctype/website_item/website_item.py", line 112, in make_route cstr(frappe.db.get_value("Item Group", self.item_group, "route")) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/database/database.py", line 515, in get_value result = self.get_values( ^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/database/database.py", line 619, in get_values out = self._get_values_from_table( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "apps/frappe/frappe/database/database.py", line 892, 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 230, in sql self._cursor.execute(query, values) File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "env/lib/python3.11/site-packages/pymysql/connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "env/lib/python3.11/site-packages/pymysql/connections.py", line 825, in _read_query_result result.read() File "env/lib/python3.11/site-packages/pymysql/connections.py", line 1199, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet packet.raise_for_error() File "env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'route' in 'SELECT'") ``` ### Request Data ``` { "type": "POST", "args": { "doc": "{\"docstatus\":0,\"doctype\":\"Website Item\",\"name\":\"new-website-item-itihgyzkrh\",\"__islocal\":1,\"__unsaved\":1,\"owner\":\"Administrator\",\"naming_series\":\"WEB-ITM-.####\",\"has_variants\":0,\"published\":1,\"item_group\":\"KOKO FRESH\",\"stock_uom\":\"Gram\",\"on_backorder\":0,\"website_specifications\":[],\"show_tabbed_section\":0,\"tabs\":[],\"recommended_items\":[],\"offers\":[],\"website_item_groups\":[],\"web_item_name\":\"Byadagi Chili Powder\",\"variant_of\":null,\"item_name\":\"Byadagi Chili Powder\",\"description\":\"STO-ITEM-2025-00005\",\"brand\":null,\"item_code\":\"STO-ITEM-2025-00005\"}", "action": "Save" }, "btn": { "jQuery370077668279672831621": { "events": { "click": [ { "type": "click", "origType": "click", "guid": 1502, "namespace": "" } ] } } }, "freeze": true, "headers": {}, "error_handlers": {}, "url": "/api/method/frappe.desk.form.save.savedocs", "request_id": "53f695f1-4a60-43fc-ba47-2b1252b028d4" } ``` ### Response Data ``` { "exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'route' in 'SELECT'\")", "exc_type": "OperationalError", "_exc_source": "webshop (app)" }