Hi there team,
I have this error updating from v6 to v7. I did some testing in a exported vm and upgraded it some weeks ago (I mean the same bd/server) and it worked for me, but now I can’t upgrade the production server.
I have this error
File “/home/user/bench-repo/bench/utils.py”, line 501, in run_frappe_cmd
** raise CommandFailedError(args)**
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
I also find this information in the error code:
(1146, “Table ‘1bd3e0294d.tabDesktop Icon’ doesn’t exist”)
Any idea? Is it a local problem or a problem related to the git repositories?
Thanks!
Complete traceback:
varmys@erpdev:~/frappe-bench$ bench update --upgrade
INFO:bench.utils:updating bench
Already up-to-date.
Requirement already satisfied (use --upgrade to upgrade): Pillow in ./env/lib/python2.7/site-packages
INFO:bench.app:pulling frappe
De GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
- branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling erpnext
De GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP) - branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling base_vat
De GitHub - saguas/frappe_base_vat: Repository for frappe base vat application - branch master → FETCH_HEAD
Already up-to-date.
INFO:bench.app:pulling mandrill_integration
De GitHub - frappe/mandrill_integration: Set Communication status from Mandrill via webhooks - branch master → FETCH_HEAD
Already up-to-date.
Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages
Migrating site1.local
Executing finally:frappe.patches.v6_24.sync_desktop_icons in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v7_0.desktop_icons_hidden_by_admin_as_blocked in site1.local (1bd3e0294d)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, 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 “/home/varmys/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
main()
File “/home/varmys/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/varmys/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/varmys/frappe-bench/apps/frappe/frappe/commands/site.py”, line 206, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/varmys/frappe-bench/apps/frappe/frappe/migrate.py”, line 27, in migrate
frappe.modules.patch_handler.run_all()
File “/home/varmys/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 26, in run_all
if not run_single(patchmodule = patch):
File “/home/varmys/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 60, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/varmys/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 80, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/varmys/frappe-bench/apps/frappe/frappe/patches/v7_0/desktop_icons_hidden_by_admin_as_blocked.py”, line 9, in execute
frappe.db.sql(‘updatetabDesktop Icon
set blocked = 1 where standard=1 and hidden=1’)
File “/home/varmys/frappe-bench/apps/frappe/frappe/database.py”, line 148, in sql
self._cursor.execute(query)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/varmys/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, “Table ‘1bd3e0294d.tabDesktop Icon’ doesn’t exist”)
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 9, in
load_entry_point(‘bench==0.0.0’, ‘console_scripts’, ‘bench’)()
File “/home/varmys/bench-repo/bench/cli.py”, line 40, in cli
bench_command()
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 716, in call
return self.main(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 696, in main
rv = self.invoke(ctx)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 1060, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 534, in invoke
return callback(*args, **kwargs)
File “/home/varmys/bench-repo/bench/commands/update.py”, line 60, in update
_update(pull, patch, build, bench, auto, restart_supervisor, requirements, no_backup, upgrade, force=force)
File “/home/varmys/bench-repo/bench/commands/update.py”, line 90, in _update
patch_sites(bench_path=bench_path)
File “/home/varmys/bench-repo/bench/utils.py”, line 161, in patch_sites
run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench_path=bench_path)
File “/home/varmys/bench-repo/bench/utils.py”, line 501, in run_frappe_cmd
raise CommandFailedError(args)
bench.utils.CommandFailedError: (‘–site’, ‘all’, ‘migrate’)
Rubén