Hello,
I am still learning the ERPNext, studying now the WO process. when I submit the WO and try to submit the pick list, i get the following error: MySQLdb.OperationalError: (1054, “Unknown column ‘tabDelivery Note.pick_list’ in ‘WHERE’”):
App Versions
{
"frappe": "16.0.0-dev",
"erpnext": "16.0.0-dev"
}
Route
Form/Pick List/STO-PICK-2025-00001
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 121, in application
response = frappe.api.handle(request)
File "apps/frappe/frappe/api/__init__.py", line 60, 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 52, 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 1127, in call
return fn(*args, **newargs)
File "apps/frappe/frappe/utils/typing_validations.py", line 36, in wrapper
return func(*args, **kwargs)
File "apps/frappe/frappe/__init__.py", line 489, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File "apps/frappe/frappe/desk/notifications.py", line 259, in get_open_count
return _get_linked_document_counts(doctype, name, items)
File "apps/frappe/frappe/desk/notifications.py", line 301, in _get_linked_document_counts
external_links_data_for_d = get_external_links(d, name, links)
File "apps/frappe/frappe/desk/notifications.py", line 348, in get_external_links
total_count = get_doc_count(doctype, filters)
File "apps/frappe/frappe/desk/notifications.py", line 360, in get_doc_count
docs = frappe.get_all(
File "apps/frappe/frappe/__init__.py", line 1385, in get_all
return get_list(doctype, *args, **kwargs)
File "apps/frappe/frappe/__init__.py", line 1360, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
File "apps/frappe/frappe/model/db_query.py", line 210, in execute
result = self.build_and_run()
File "apps/frappe/frappe/model/db_query.py", line 251, in build_and_run
return frappe.db.sql(
File "apps/frappe/frappe/database/database.py", line 271, in sql
self.execute_query(query, values)
File "apps/frappe/frappe/database/database.py", line 365, in execute_query
return self._cursor.execute(query, values)
File "env/lib/python3.10/site-packages/MySQLdb/cursors.py", line 179, in execute
res = self._query(mogrified_query)
File "env/lib/python3.10/site-packages/MySQLdb/cursors.py", line 330, in _query
db.query(q)
File "env/lib/python3.10/site-packages/MySQLdb/connections.py", line 280, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (1054, "Unknown column 'tabDelivery Note.pick_list' in 'WHERE'")
Request Data
{
"type": "GET",
"args": {
"doctype": "Pick List",
"name": "STO-PICK-2025-00001",
"items": "[\"Stock Entry\",\"Sales Order\",\"Delivery Note\",\"Stock Reservation Entry\"]"
},
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.notifications.get_open_count",
"request_id": null
}
Response Data
{
"exception": "MySQLdb.OperationalError: (1054, \"Unknown column 'tabDelivery Note.pick_list' in 'WHERE'\")",
"exc_type": "OperationalError"
}
Please advise, what is wrong?
Thank you in advance,
Igor.