Error while setting any filter in sales invoice

Frappe Framework Bug
1

Check the following error i get

Traceback (most recent call last):
File “/home/erpdev/frappe-bench/apps/frappe/frappe/app.py”, line 57, in application
response = frappe.handler.handle()
File “/home/erpdev/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/erpdev/frappe-bench/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/erpdev/frappe-bench/apps/frappe/frappe/init.py”, line 935, in call
return fn(*args, **newargs)
File “/home/erpdev/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 590, in get_count
return frappe.db.count(doctype, filters=filters)
File “/home/erpdev/frappe-bench/apps/frappe/frappe/database.py”, line 802, in count
from tab%s where %s"“” % (dt, conditions), filters, debug=debug)[0][0]
File “/home/erpdev/frappe-bench/apps/frappe/frappe/database.py”, line 152, in sql
self._cursor.execute(query, values)
File “/home/erpdev/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/erpdev/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
OperationalError: (1054, “Unknown column ‘item_code’ in ‘where clause’”)

have some filter types been removed in the latest pull?
Also same error in stock entry,

regards,

2

A fix for this has already been pushed #4398 , you can pull it after its merged :+1:

1 Like
3

has the fix been merged yet… still getting the error after the latest pull.

4

Nope not yet, will be soon though :+1:

5

Thanks for all the effort.

I see the fix has been merged .
But i am getting the same error after the latest pull.

Error comes whenever i want to see all the sales invoices or stock entry for a particular item.

6

list-count-item

Can you share the error log and also a gif as to what you’re doing ?

7

Ok it is working now…
i had forgotten to migrate after the pull.

Thanks a ton .