ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Error Stock Sumary & Stock Ledger V11 Staging


#1

I have this error after updating to:

ERPNext: v11.0.3-beta.24 () (staging)

Frappe Framework: v11.0.3-beta.30 () (staging)

When i try to run the stock ledger report and stock balance report without selecting a product.

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 56, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1007, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 489, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 174, in run
result = generate_report_result(report, filters, user)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 65, in generate_report_result
res = frappe.get_attr(method_name)(frappe._dict(filters))
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/report/stock_ledger/stock_ledger.py”, line 14, in execute
item_details = get_item_details(items, sl_entries, include_uom)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/report/stock_ledger/stock_ledger.py”, line 121, in get_item_details
{“include_uom”: include_uom}, as_dict=1):
File “/home/frappe/frappe-bench/apps/frappe/frappe/database.py”, line 199, in sql
self._cursor.execute(query, values)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 168, in execute
query = self.mogrify(query, args)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 147, in mogrify
query = query % self._escape_args(args, conn)
ValueError: unsupported format character ‘M’ (0x4d) at index 1068


#2

Nervermind i happen to be that some item codes used the % simbol as part of the name.