Something went wrong when clicked in Item Code box to type

Nawin_Kumar · January 6, 2019, 1:11pm

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 62, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 939, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/search.py”, line 51, in search_link
search_widget(doctype, txt, query, searchfield=searchfield, page_length=page_length, filters=filters)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/search.py”, line 73, in search_widget
searchfield, start, page_length, filters, as_dict=as_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 939, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/controllers/queries.py”, line 156, in item_query
if frappe.db.count(‘Item’, cache=True) < 50000:
TypeError: count() got an unexpected keyword argument ‘cache’

clarkej · January 6, 2019, 5:41pm

Hi welcome and ERPNext,

That code was added in April, 2018 [optimize] item queries by rmehta · Pull Request #13480 · frappe/erpnext · GitHub

and ‘cache’ is a legal optional argument

github.com

frappe/frappe/blob/develop/frappe/database/database.py#L778


      
          		distinct=False,
          		limit=None,
          	):
          		query = frappe.qb.engine.get_query(
          			table=doctype,
          			filters=filters,
          			orderby=order_by,
          			for_update=for_update,
          			fields=fields,
          			distinct=distinct,
          			limit=limit,
          		)
          		if fields == "*" and not isinstance(fields, (list, tuple)) and not isinstance(fields, Criterion):
          			as_dict = True
          
          
		return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
          
          
	def _get_value_for_many_names(
          		self,
          		doctype,
          		names,

What is your frappe and erpnext version?

Are you in a self-hosted environment, if yes a code recompile might fix this? Run ‘bench console’ then run this:

frappe-bench > cd apps/frappe
frappe-bench/apps/frappe > find . -name "*.pyc" | xargs rm -f