Keep getting an error below- looking to have redisearch and category filters for this custom field. they save and show and work as expected in the custom field on the website item doctype but are not searchable not when you select the category filter do they filter.
error comes up
“pymysql.err.OperationalError: (1054, "Unknown column ‘custom_area_group’ in ‘field list’")”,
** “_exc_source”: “erpnext (app)”**
App Versions
{
"ecommerce_integrations": "1.18.2",
"email_delivery_service": "0.0.1",
"erpnext": "15.0.0-dev",
"frappe": "15.0.0-dev",
"payments": "0.0.1"
}
Route
Form/E Commerce Settings/E Commerce Settings
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 104, in application
response = frappe.api.handle()
^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api.py", line 53, in handle
return _RESTAPIHandler(call, doctype, name).get_response()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api.py", line 69, in get_response
return self.handle_method()
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api.py", line 79, in handle_method
return frappe.handler.handle()
^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 48, in handle
data = execute_cmd(cmd)
^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 86, in execute_cmd
return frappe.call(method, **frappe.form_dict)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1671, 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 36, in savedocs
doc.save()
File "apps/frappe/frappe/model/document.py", line 331, in save
return self._save(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/document.py", line 383, in _save
self.run_post_save_methods()
File "apps/frappe/frappe/model/document.py", line 1129, in run_post_save_methods
self.run_method("on_change")
File "apps/frappe/frappe/model/document.py", line 937, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/document.py", line 1308, in composer
return composed(self, method, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/document.py", line 1290, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/document.py", line 934, in fn
return method_object(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/erpnext/erpnext/e_commerce/doctype/e_commerce_settings/e_commerce_settings.py", line 159, in on_change
create_website_items_index()
File "apps/erpnext/erpnext/e_commerce/redisearch_utils.py", line 52, in wrapper
func = function(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/erpnext/erpnext/e_commerce/redisearch_utils.py", line 96, in create_website_items_index
reindex_all_web_items()
File "apps/erpnext/erpnext/e_commerce/redisearch_utils.py", line 52, in wrapper
func = function(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/erpnext/erpnext/e_commerce/redisearch_utils.py", line 222, in reindex_all_web_items
items = frappe.get_all("Website Item", fields=get_fields_indexed(), filters={"published": True})
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1961, in get_all
return get_list(doctype, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1936, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 201, in execute
result = self.build_and_run()
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 241, in build_and_run
return frappe.db.sql(
^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/database.py", line 217, 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 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 822, in _read_query_result
result.read()
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 1200, in read
first_packet = self.connection._read_packet()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "env/lib/python3.11/site-packages/pymysql/connections.py", line 772, in _read_packet
packet.raise_for_error()
File "env/lib/python3.11/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "env/lib/python3.11/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'custom_area_group' in 'field list'")
Request Data
{
"type": "POST",
"args": {
"doc": "{\"name\":\"E Commerce Settings\",\"owner\":\"Administrator\",\"modified\":\"2023-09-18 20:51:27.508409\",\"modified_by\":\"Administrator\",\"docstatus\":0,\"idx\":\"0\",\"products_per_page\":30,\"enable_field_filters\":1,\"enable_attribute_filters\":0,\"hide_variants\":0,\"enable_variants\":0,\"show_price\":1,\"show_stock_availability\":0,\"show_quantity_in_website\":0,\"allow_items_not_in_stock\":1,\"show_apply_coupon_code_in_website\":1,\"show_contact_us_button\":1,\"show_attachments\":1,\"company\":\"Zen Hills\",\"price_list\":\"Wholesale-0\",\"enabled\":1,\"default_customer_group\":\"Commercial\",\"quotation_series\":\"SAL-QTN-.YYYY.-\",\"enable_checkout\":0,\"show_price_in_quotation\":1,\"save_quotations_as_draft\":0,\"payment_gateway_account\":\"\",\"payment_success_url\":\"Orders\",\"enable_wishlist\":1,\"enable_reviews\":0,\"enable_recommendations\":1,\"search_index_fields\":\"item_group,brand,item_code,custom_area_group\",\"is_redisearch_enabled\":1,\"is_redisearch_loaded\":1,\"slideshow\":\"\",\"hide_price_for_guest\":0,\"redirect_on_action\":\"/login\",\"doctype\":\"E Commerce Settings\",\"filter_fields\":[{\"name\":\"8514212fae\",\"owner\":\"john.gasper@zenhillsllc.com\",\"creation\":\"2023-09-10 16:54:21.532110\",\"modified\":\"2023-09-18 20:51:27.508409\",\"modified_by\":\"Administrator\",\"docstatus\":0,\"idx\":1,\"fieldname\":\"item_group\",\"parent\":\"E Commerce Settings\",\"parentfield\":\"filter_fields\",\"parenttype\":\"E Commerce Settings\",\"doctype\":\"Website Filter Field\"},{\"name\":\"f8b7992cc5\",\"owner\":\"Administrator\",\"creation\":\"2023-09-18 20:15:15.899222\",\"modified\":\"2023-09-18 20:51:27.508409\",\"modified_by\":\"Administrator\",\"docstatus\":0,\"idx\":2,\"fieldname\":\"custom_area_group\",\"parent\":\"E Commerce Settings\",\"parentfield\":\"filter_fields\",\"parenttype\":\"E Commerce Settings\",\"doctype\":\"Website Filter Field\"}],\"filter_attributes\":[],\"__onload\":{\"quotation_series\":\"SAL-QTN-.YYYY.-\"},\"__last_sync_on\":\"2023-09-19T03:15:08.584Z\",\"__unsaved\":1}",
"action": "Save"
},
"btn": {
"jQuery370012629706213771721": {
"events": {
"click": [
{
"type": "click",
"origType": "click",
"guid": 3068,
"namespace": ""
}
]
}
}
},
"freeze": true,
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.form.save.savedocs",
"request_id": "3bb61cbe-df8c-41b5-b73b-22c220f9da11"
}
Response Data
{
"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'custom_area_group' in 'field list'\")",
"_exc_source": "erpnext (app)"
}