Hi ,
Every time I open the stock entry module , it automatically picks this qty in the sort view button and I am getting this error ,
Traceback (most recent call last):
File "/home/ommi/frappe-bench/apps/frappe/frappe/app.py", line 55, in application
response = frappe.handler.handle()
File "/home/ommi/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle
execute_cmd(cmd)
File "/home/ommi/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd
ret = frappe.call(method, **frappe.form_dict)
File "/home/ommi/frappe-bench/apps/frappe/frappe/__init__.py", line 876, in call
return fn(*args, **newargs)
File "/home/ommi/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 16, in get
data = compress(execute(**args))
File "/home/ommi/frappe-bench/apps/frappe/frappe/desk/reportview.py", line 21, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
File "/home/ommi/frappe-bench/apps/frappe/frappe/model/db_query.py", line 79, in execute
result = self.build_and_run()
File "/home/ommi/frappe-bench/apps/frappe/frappe/model/db_query.py", line 103, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File "/home/ommi/frappe-bench/apps/frappe/frappe/database.py", line 148, in sql
self._cursor.execute(query)
File "/home/ommi/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/ommi/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'qty' in 'order clause'")
And when I change this qty to title , I am able to open the stock entry ,
How do I get out of this problem ?
Thanks