Hi,
Upgraded to v7.1 and found when adding new Chart of Account (Accounts > Chart of Accounts) as soon as I select the ‘currency’ field it produces below error. Tested another site on same multi-tenant system - same issue. Tested on dev box - same issue. Both instances do not have column 'tabCurrency.company' in DB.
Update: As workaround, kept blank and saved to use company default. I then edited the CoA and updated to alternate currency without issue.
Traceback (most recent call last): File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 55, in application response = frappe.handler.handle() File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 19, in handle execute_cmd(cmd) File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 36, in execute_cmd ret = frappe.call(method, **frappe.form_dict) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 890, in call return fn(*args, **newargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/search.py", line 12, in search_link search_widget(doctype, txt, query, searchfield=searchfield, page_len=page_len, filters=filters) File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/search.py", line 91, in search_widget as_list=not as_dict) File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 1069, 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 80, in execute result = self.build_and_run() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py", line 104, 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 148, in sql self._cursor.execute(query) File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/frappe/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1054, "Unknown column 'tabCurrency.company' in 'where clause'")