Upgrade error: V4 to V5

[betoled]

When upgrading from V4 to V5 I get an error. I run these bench update --upgrade but when it reaches the rename_table_fieldnames command I get following error :

Successfully installed unidecode erpnext Cleaning up... Database backed up /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/20150717_81758089_database.sql.gz Migrating erpnext.erpnext-vm Executing frappe.patches.v5_0.convert_to_barracuda_and_utf8mb4 in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('core', 'doctype', 'docfield', force=True) #2015-05-15 in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('email', 'doctype', 'email_alert') #2014-07-15 in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('desk', 'doctype', 'todo') #2014-12-31-1 in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('custom', 'doctype', 'property_setter') #2014-12-31-1 in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.v4_to_v5 in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.remove_shopping_cart_app in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.permissions.reset_perms("Module Def") in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.permissions.reset_perms("User") #2015-03-24 in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.rename_table_fieldnames in erpnext.erpnext-vm (erpnext) 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in main() File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main click.Group(commands=commands)(prog_name='bench') File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in call return self.main(_args, _kwargs) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main rv = self.invoke(ctx) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke return ctx.invoke(self.callback, _ctx.params) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke return callback(_args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func ret = f(frappe._dict(ctx.obj), args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate frappe.modules.patch_handler.run_all() File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all if not run_single(patchmodule = patch): File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/erpnext/frappe-bench/apps/frappe/frappe/patches/v5_0/rename_table_fieldnames.py", line 32, in execute rename_field(dt, field[0], field[1]) TypeError: 'module' object is not callable Traceback (most recent call last): File "/usr/local/bin/bench", line 9, in load_entry_point('bench==0.1', 'console_scripts', 'bench')() File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli bench() File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in call return self.main(_args, _kwargs) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke return ctx.invoke(self.callback, *_ctx.params) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke return callback(_args, **kwargs) File "/home/erpnext/bench-repo/bench/cli.py", line 247, in update patch_sites() File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites run_frappe_cmd('--site', 'all', 'migrate', bench=bench) File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir) File "/usr/lib/python2.7/subprocess.py", line 511, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

Does anyone know how to fix this ?

Thanks, Benjamien

[nabinhait]

Fixed in develop branch. It will be merged in master on Monday.

https://github.com/frappe/erpnext/commit/0a3be6da272610fba8ae500b09963948ef0ebcc8

You can make the changes manually to proceed.

[nabinhait]

Also apply changes below:

https://github.com/frappe/erpnext/commit/1401e3f679de58c8313feb144ea8571d7c86809c https://github.com/frappe/erpnext/commit/dae29bf2d4c403414376e6e4228ae80d8340998e

[betoled]

I switched to develop and tried the bench update again. But I still get the same error. My local files have the changes, I checked.

From https://github.com/frappe/frappe

• branch develop -> FETCH_HEAD Already up-to-date. From https://github.com/frappe/erpnext
• branch develop -> FETCH_HEAD Updating 3631e9c..1401e3f Fast-forward erpnext/patches/v4_0/fields_to_be_renamed.py | 2 +- erpnext/patches/v5_0/rename_table_fieldnames.py | 2 +- erpnext/patches/v5_0/rename_total_fields.py | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) Database backed up /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/20150717_30491605_database.sql.gz Migrating erpnext.erpnext-vm Executing frappe.patches.v5_0.rename_table_fieldnames in erpnext.erpnext-vm (erpnext) 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in main() File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main click.Group(commands=commands)(prog_name='bench') File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in call return self.main(_args, _kwargs) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main rv = self.invoke(ctx) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke return ctx.invoke(self.callback, _ctx.params) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke return callback(_args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func ret = f(frappe._dict(ctx.obj), args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate frappe.modules.patch_handler.run_all() File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all if not run_single(patchmodule = patch): File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/erpnext/frappe-bench/apps/frappe/frappe/patches/v5_0/rename_table_fieldnames.py", line 32, in execute rename_field(dt, field[0], field[1]) TypeError: 'module' object is not callable Traceback (most recent call last): File "/usr/local/bin/bench", line 9, in load_entry_point('bench==0.1', 'console_scripts', 'bench')() File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli bench() File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in call return self.main(_args, _kwargs) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke return ctx.invoke(self.callback, *_ctx.params) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke return callback(_args, **kwargs) File "/home/erpnext/bench-repo/bench/cli.py", line 247, in update patch_sites() File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites run_frappe_cmd('--site', 'all', 'migrate', bench=bench) File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir) File "/usr/lib/python2.7/subprocess.py", line 511, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

[nabinhait]

Sorry, it was not fixed properly, please try again.

[betoled]

I tried bench-update again, but the error remains the same.

[nabinhait]

Please check if it works now

[betoled]

No, still the same error.

[nabinhait]

please share the traceback

[betoled]

This is what I get :

From https://github.com/frappe/frappe
 * branch            develop    -> FETCH_HEAD
Already up-to-date.
From https://github.com/frappe/erpnext
 * branch            develop    -> FETCH_HEAD
Already up-to-date.
Migrating erpnext.erpnext-vm
Executing frappe.patches.v5_0.rename_table_fieldnames in erpnext.erpnext-vm (erpnext)
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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in <module>
    main()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main
    click.Group(commands=commands)(prog_name='bench')
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in __call__
    return self.main(*args, **kwargs)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main
    rv = self.invoke(ctx)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke
    return callback(*args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate
    frappe.modules.patch_handler.run_all()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all
    if not run_single(patchmodule = patch):
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + ".execute")()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/patches/v5_0/rename_table_fieldnames.py", line 32, in execute
    rename_field(dt, field[0], field[1])
TypeError: 'module' object is not callable
Traceback (most recent call last):
  File "/usr/local/bin/bench", line 9, in <module>
    load_entry_point('bench==0.1', 'console_scripts', 'bench')()
  File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli
    bench()
  File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke
    return callback(*args, **kwargs)
  File "/home/erpnext/bench-repo/bench/cli.py", line 263, in retry_upgrade
    patch_sites()
  File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites
    run_frappe_cmd('--site', 'all', 'migrate', bench=bench)
  File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd
    subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir)
  File "/usr/lib/python2.7/subprocess.py", line 511, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

[rmehta]

@betoled please format your trace when you post. Will save us a lot of effort.

[betoled]

I've just tried again, and I get a new error now

remote: Counting objects: 10, done. remote: Compressing objects: 100% (10/10), done. remote: Total 10 (delta 1), reused 0 (delta 0), pack-reused 0 Unpacking objects: 100% (10/10), done. From https://github.com/frappe/frappe a645016..c6f605b develop -> upstream/develop From https://github.com/frappe/frappe

• branch develop -> FETCH_HEAD Updating a645016..c6f605b Fast-forward frappe/patches/v4_0/rename_profile_to_user.py | 2 +- frappe/patches/v4_0/rename_sitemap_to_route.py | 2 +- frappe/patches/v5_0/rename_table_fieldnames.py | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) From https://github.com/frappe/erpnext
• branch develop -> FETCH_HEAD Already up-to-date. Database backed up /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/20150717_98023526_database.sql.gz Migrating erpnext.erpnext-vm Executing frappe.patches.v5_0.rename_table_fieldnames in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.communication_parent in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.clear_website_group_and_notifications in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.db.sql("""update tabComment set comment = substr(comment, 6, locate(":", comment)-6) where comment_type in ("Assigned", "Assignment Completed")""") in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.fix_feed in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.update_shared in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.bookmarks_to_stars in erpnext.erpnext-vm (erpnext) Success Executing frappe.patches.v5_0.style_settings_to_website_theme in erpnext.erpnext-vm (erpnext) 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in main() File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main click.Group(commands=commands)(prog_name='bench') File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in call return self.main(_args, _kwargs) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main rv = self.invoke(ctx) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke return ctx.invoke(self.callback, _ctx.params) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke return callback(_args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func ret = f(frappe._dict(ctx.obj), args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate frappe.modules.patch_handler.run_all() File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all if not run_single(patchmodule = patch): File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/erpnext/frappe-bench/apps/frappe/frappe/patches/v5_0/style_settings_to_website_theme.py", line 10, in execute migrate_style_settings() File "/home/erpnext/frappe-bench/apps/frappe/frappe/patches/v5_0/style_settings_to_website_theme.py", line 27, in migrate_style_settings website_theme.save() File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 216, in save self.insert() File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 188, in insert self.db_insert() File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/base_document.py", line 254, in db_insert ), d.values()) File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 135, in sql self._cursor.execute(query, values) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue frappe.exceptions.DuplicateEntryError: (u'Website Theme', u'Custom', IntegrityError(1062, "Duplicate entry 'Custom' for key 'PRIMARY'")) Traceback (most recent call last): File "/usr/local/bin/bench", line 9, in load_entry_point('bench==0.1', 'console_scripts', 'bench')() File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli bench() File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in call return self.main(_args, _kwargs) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke return ctx.invoke(self.callback, *_ctx.params) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke return callback(_args, **kwargs) File "/home/erpnext/bench-repo/bench/cli.py", line 247, in update patch_sites() File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites run_frappe_cmd('--site', 'all', 'migrate', bench=bench) File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir) File "/usr/lib/python2.7/subprocess.py", line 511, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

[betoled]

I got past this by removing the 'Custom' record from the table. I tried bench update again and got a new error

From https://github.com/frappe/frappe

• branch develop -> FETCH_HEAD Already up-to-date. From https://github.com/frappe/erpnext
• branch develop -> FETCH_HEAD Already up-to-date. Database backed up /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/20150717_75423054_database.sql.gz Migrating erpnext.erpnext-vm Executing execute:frappe.rename_doc("DocType", "Support Ticket", "Issue", force=True) in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v4_4.make_email_accounts in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v4_2.reset_bom_costs in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_frozen_accounts_permission_role in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_dn_against_doc_fields in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.db.sql("update tabMaterial Request set material_request_type = 'Material Transfer' where material_request_type = 'Transfer'") in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('stock', 'doctype', 'item') in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.db.sql("update tabItem i set apply_warehouse_wise_reorder_level=1, re_order_level=0, re_order_qty=0 where exists(select name from tabItem Reorder where parent=i.name)") in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.set_default_company_in_bom in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.capacity_planning in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('crm', 'doctype', 'lead') in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('crm', 'doctype', 'opportunity') in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.rename_taxes_and_charges_master in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_1.sales_bom_rename in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.rename_table_fieldnames in erpnext.erpnext-vm (erpnext) 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in main() File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main click.Group(commands=commands)(prog_name='bench') File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in call return self.main(_args, _kwargs) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main rv = self.invoke(ctx) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke return ctx.invoke(self.callback, _ctx.params) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke return callback(_args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func ret = f(frappe._dict(ctx.obj), args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate frappe.modules.patch_handler.run_all() File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all if not run_single(patchmodule = patch): File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/patches/v5_0/rename_table_fieldnames.py", line 238, in execute rename_field(dt, field[0], field[1]) File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/utils/rename_field.py", line 23, in rename_field elif new_field.fieldtype not in no_value_fields: NameError: global name 'no_value_fields' is not defined Traceback (most recent call last): File "/usr/local/bin/bench", line 9, in load_entry_point('bench==0.1', 'console_scripts', 'bench')() File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli bench() File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in call return self.main(_args, _kwargs) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke return ctx.invoke(self.callback, *_ctx.params) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke return callback(_args, **kwargs) File "/home/erpnext/bench-repo/bench/cli.py", line 247, in update patch_sites() File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites run_frappe_cmd('--site', 'all', 'migrate', bench=bench) File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir) File "/usr/lib/python2.7/subprocess.py", line 511, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

[nabinhait]

Pushed fix.

[betoled]

New error

From https://github.com/frappe/frappe

• branch develop -> FETCH_HEAD Already up-to-date. From https://github.com/frappe/erpnext
• branch develop -> FETCH_HEAD Already up-to-date. Database backed up /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/private/backups/20150717_68267011_database.sql.gz Migrating erpnext.erpnext-vm Executing erpnext.patches.v5_0.rename_customer_issue in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.rename_total_fields in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.new_crm_module in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_material_transfer_for_manufacture in erpnext.erpnext-vm (erpnext) Success Executing execute:frappe.reload_doc('crm', 'doctype', 'opportunity_item') in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_item_description_and_image in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_material_transferred_for_manufacturing in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.stock_entry_update_value in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.convert_stock_reconciliation in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_projects in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.item_patches in erpnext.erpnext-vm (erpnext) Success Executing erpnext.patches.v5_0.update_journal_entry_title in erpnext.erpnext-vm (erpnext) 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in main() File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main click.Group(commands=commands)(prog_name='bench') File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 664, in call return self.main(_args, _kwargs) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 644, in main rv = self.invoke(ctx) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 991, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 837, in invoke return ctx.invoke(self.callback, _ctx.params) File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 464, in invoke return callback(_args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func ret = f(frappe._dict(ctx.obj), args, _kwargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 205, in migrate frappe.modules.patch_handler.run_all() File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all if not run_single(patchmodule = patch): File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/patches/v5_0/update_journal_entry_title.py", line 8, in execute frappe.reload_doctype("Journal Entry") File "/home/erpnext/frappe-bench/apps/frappe/frappe/init.py", line 543, in reload_doctype reload_doc(scrub(db.getvalue("DocType", doctype, "module")), "doctype", scrub(doctype), force=force) File "/home/erpnext/frappe-bench/apps/frappe/frappe/init.py", line 568, in scrub return txt.replace(' ','').replace('-', '_').lower() AttributeError: 'NoneType' object has no attribute 'replace' Traceback (most recent call last): File "/usr/local/bin/bench", line 9, in load_entry_point('bench==0.1', 'console_scripts', 'bench')() File "/home/erpnext/bench-repo/bench/cli.py", line 55, in cli bench() File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 610, in call return self.main(_args, _kwargs) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 590, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 936, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 782, in invoke return ctx.invoke(self.callback, *_ctx.params) File "/usr/local/lib/python2.7/dist-packages/click-3.3-py2.7.egg/click/core.py", line 416, in invoke return callback(_args, **kwargs) File "/home/erpnext/bench-repo/bench/cli.py", line 247, in update patch_sites() File "/home/erpnext/bench-repo/bench/utils.py", line 118, in patch_sites run_frappe_cmd('--site', 'all', 'migrate', bench=bench) File "/home/erpnext/bench-repo/bench/utils.py", line 427, in run_frappe_cmd subprocess.check_call((f, '-m', 'frappe.utils.bench_helper', 'frappe') + args, cwd=sites_dir) File "/usr/lib/python2.7/subprocess.py", line 511, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command '('/home/erpnext/frappe-bench/env/bin/python', '-m', 'frappe.utils.bench_helper', 'frappe', '--site', 'all', 'migrate')' returned non-zero exit status 1

[nabinhait]

Somehow "Journal Voucher" has not renamed to "Journal Entry" before running this patch.

Try bench --site <your_site_name> execute erpnext.patches.v5_0.rename_table_fieldnames.execute first and then retry upgrade.

[betoled]

I tried the patch again but that did not work. I manually changed the names in the database and ran the upgrade again. Now it worked !

It seems like the complete upgrade worked, and we now have version 5.

Thank you very much for your support !!!

[rmehta]

@betoled please do consider donating :)