frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
19.73k stars 7k forks source link

issue while saving purchase invoice #13947

Closed itskaps closed 6 years ago

itskaps commented 6 years ago

App Versions { "erpnext": "10.1.30", "frappe": "10.1.29" } Route Form/Purchase Invoice/PINV-00001 Error Report 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 942, in call return fn(*args, *newargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/notifications.py", line 267, in get_open_count filters={fieldname: name}, limit=100, distinct=True, ignore_ifnull=True)) File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1180, in get_all return get_list(doctype, args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1153, in get_list return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 87, in execute result = self.build_and_run() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 111, in build_and_run return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update) File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 205, in sql self._cursor.execute(query) File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py", line 165, in execute result = self._query(query) File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/cursors.py", line 321, in _query conn.query(q) File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 860, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 1061, in _read_query_result result.read() File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 1349, in read first_packet = self.connection._read_packet() File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 1018, in _read_packet packet.check_error() File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/connections.py", line 384, in check_error err.raise_mysql_exception(self._data) File "/home/frappe/frappe-bench/env/lib/python3.5/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, "Unknown column 'tabSubscription.purchase_invoice' in 'where clause'") Request Data { "type": "GET", "args": { "doctype": "Purchase Invoice", "name": "PINV-00001", "cmd": "frappe.desk.notifications.get_open_count" }, "url": "/" } Response JSON {}

Zlash65 commented 6 years ago

https://github.com/frappe/erpnext/issues/13949