bench update v11.1.18 - pymysql.err.InternalError: (1054, u"Unknown column 'tax_type' in 'field list'")

[lbazan]

Migrating erp.ibtechpa.com Executing erpnext.patches.v12_0.move_item_tax_to_item_tax_template in erp.ibtechpa.com (_1e0d7f289fc4ad6f) Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main "main", fname, loader, pkg_name) File "/usr/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 97, in main() File "/opt/bench/erpnext/apps/frappe/frappe/utils/bench_helper.py", line 18, in main click.Group(commands=commands)(prog_name='bench') File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 764, in call return self.main(args, kwargs) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 717, in main rv = self.invoke(ctx) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 956, in invoke return ctx.invoke(self.callback, ctx.params) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke return callback(args, kwargs) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, *kwargs) File "/opt/bench/erpnext/apps/frappe/frappe/commands/init.py", line 25, in _func ret = f(frappe._dict(ctx.obj), args, kwargs) File "/opt/bench/erpnext/apps/frappe/frappe/commands/site.py", line 228, in migrate migrate(context.verbose, rebuild_website=rebuild_website) File "/opt/bench/erpnext/apps/frappe/frappe/migrate.py", line 37, in migrate frappe.modules.patch_handler.run_all() File "/opt/bench/erpnext/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all if not run_single(patchmodule = patch): File "/opt/bench/erpnext/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single return execute_patch(patchmodule, method, methodargs) File "/opt/bench/erpnext/apps/frappe/frappe/modules/patch_handler.py", line 83, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/opt/bench/erpnext/apps/erpnext/erpnext/patches/v12_0/move_item_tax_to_item_tax_template.py", line 10, in execute for d in frappe.db.sql("""select parent as item_code, tax_type, tax_rate from tabItem Tax""", as_dict=1): File "/opt/bench/erpnext/apps/frappe/frappe/database/database.py", line 166, in sql self._cursor.execute(query) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute result = self._query(query) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query conn.query(q) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 732, in _read_query_result result.read() File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1075, in read first_packet = self.connection._read_packet() File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet packet.check_error() File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1054, u"Unknown column 'tax_type' in 'field list'") bench@erp:~/erpnext$

[nabinhait]

From which version are you trying to migrate?

[asbasawaraj]

bench update will resolve this issue.