{"action":"created","issue":{"url":"https://api.github.com/repos/frappe/frappe/issues/3043","repository_url":"https://api.github.com/repos/frappe/frappe","labels_url":"https://api.github.com/repos/frappe/frappe/issues/3043/labels{/name}","comments_url":"https://api.github.com/repos/frappe/frappe/issues/3043/comments","events_url":"https://api.github.com/repos/frappe/frappe/issues/3043/events","html_url":"https://github.com/frappe/frappe/issues/3043","id":220444165,"number":3043,"title":"Issues with upgrading from V6 to V8","user":{"login":"SandeepAthiyarath","id":381748,"avatar_url":"https://avatars0.githubusercontent.com/u/381748?v=3","gravatar_id":"","url":"https://api.github.com/users/SandeepAthiyarath","html_url":"https://github.com/SandeepAthiyarath","followers_url":"https://api.github.com/users/SandeepAthiyarath/followers","following_url":"https://api.github.com/users/SandeepAthiyarath/following{/other_user}","gists_url":"https://api.github.com/users/SandeepAthiyarath/gists{/gist_id}","starred_url":"https://api.github.com/users/SandeepAthiyarath/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SandeepAthiyarath/subscriptions","organizations_url":"https://api.github.com/users/SandeepAthiyarath/orgs","repos_url":"https://api.github.com/users/SandeepAthiyarath/repos","events_url":"https://api.github.com/users/SandeepAthiyarath/events{/privacy}","received_events_url":"https://api.github.com/users/SandeepAthiyarath/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-09T03:21:26Z","updated_at":"2017-04-27T11:22:32Z","closed_at":"2017-04-27T11:22:32Z","body":"#### Expected Behaviour\r\nUpgrade from V6 to V8 should work without errors due to the changes in V7\r\n\r\n#### Actual Behaviour\r\nWhen I ran the 'bench update --upgrade' again. It stops at the following error.\r\nMigrating site1.local\r\nExecuting frappe.patches.v8_0.update_published_in_global_search in site1.local (1bd3e0294d)\r\nTraceback (most recent call last):\r\nFile \"/usr/lib/python2.7/runpy.py\", line 162, in runmodule_as_main\r\n\"main\", fname, loader, pkg_name)\r\nFile \"/usr/lib/python2.7/runpy.py\", line 72, in runcode\r\nexec code in run_globals\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py\", line 79, in\r\nmain()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py\", line 16, in main\r\nclick.Group(commands=commands)(prog_name='bench')\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 716, in call\r\nreturn self.main(*args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 696, in main\r\nrv = self.invoke(ctx)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 1060, in invoke\r\nreturn processresult(sub_ctx.command.invoke(sub_ctx))\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 1060, in invoke\r\nreturn processresult(sub_ctx.command.invoke(sub_ctx))\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 889, in invoke\r\nreturn ctx.invoke(self.callback, **ctx.params)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py\", line 534, in invoke\r\nreturn callback(*args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py\", line 17, in new_func\r\nreturn f(get_current_context(), *args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/commands/__init__.py\", line 24, in _func\r\nret = f(frappe._dict(ctx.obj), *args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/commands/site.py\", line 210, in migrate\r\nmigrate(context.verbose, rebuild_website=rebuild_website)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/migrate.py\", line 31, in migrate\r\nfrappe.modules.patch_handler.run_all()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py\", line 29, in run_all\r\nif not run_single(patchmodule = patch):\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py\", line 63, in run_single\r\nreturn execute_patch(patchmodule, method, methodargs)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py\", line 83, in execute_patch\r\nfrappe.get_attr(patchmodule.split()[0] + \".execute\")()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/patches/v8_0/update_published_in_global_search.py\", line 6, in execute\r\nrebuild_for_doctype(doctype)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/global_search.py\", line 96, in rebuild_for_doctype\r\nfor d in frappe.get_all(doctype):\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py\", line 1139, in get_all\r\nreturn get_list(doctype, *args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/__init__.py\", line 1112, in get_list\r\nreturn frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py\", line 83, in execute\r\nresult = self.build_and_run()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py\", line 95, in build_and_run\r\nargs = self.prepare_args()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py\", line 112, in prepare_args\r\nself.set_optional_columns()\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/model/db_query.py\", line 212, in set_optional_columns\r\ncolumns = frappe.db.get_table_columns(self.doctype)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py\", line 808, in get_table_columns\r\nreturn self.get_db_table_columns('tab' + doctype)\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py\", line 804, in get_db_table_columns\r\nreturn [r[0] for r in self.sql(\"DESC %s\" % table)]\r\nFile \"/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py\", line 149, in sql\r\nself._cursor.execute(query)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py\", line 205, in execute\r\nself.errorhandler(self, exc, value)\r\nFile \"/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py\", line 36, in defaulterrorhandler\r\nraise errorclass, errorvalue\r\nmysqlexceptions.ProgrammingError: (1146, \"Table '1bd3e0294d.tabStudent Admission' doesn't exist\")\r\nubuntu@ip-10-10-0-132:~/frappe-bench$ \r\n\r\n#### Steps to reproduce:\r\nUpdate directly from  any of the v6.23 to latest v8.\r\n\r\nV6 frappe version:\r\nFrappe version: \r\nbuntu@ip-10-10-0-11:~/frappe-bench$ bench version\r\nerpnext 6.23.6\r\nfrappe 6.24.7\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/frappe/frappe/issues/comments/297686591","html_url":"https://github.com/frappe/frappe/issues/3043#issuecomment-297686591","issue_url":"https://api.github.com/repos/frappe/frappe/issues/3043","id":297686591,"user":{"login":"rmehta","id":140076,"avatar_url":"https://avatars2.githubusercontent.com/u/140076?v=3","gravatar_id":"","url":"https://api.github.com/users/rmehta","html_url":"https://github.com/rmehta","followers_url":"https://api.github.com/users/rmehta/followers","following_url":"https://api.github.com/users/rmehta/following{/other_user}","gists_url":"https://api.github.com/users/rmehta/gists{/gist_id}","starred_url":"https://api.github.com/users/rmehta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmehta/subscriptions","organizations_url":"https://api.github.com/users/rmehta/orgs","repos_url":"https://api.github.com/users/rmehta/repos","events_url":"https://api.github.com/users/rmehta/events{/privacy}","received_events_url":"https://api.github.com/users/rmehta/received_events","type":"User","site_admin":false},"created_at":"2017-04-27T11:22:32Z","updated_at":"2017-04-27T11:22:32Z","body":"fixed please raise issues on frappe/erpnext where we are more actively monitoring"}}
{"actor":{"display_login":"rmehta"}}