Error while doing bench update Versio 7 Cont

Continuation to the below thread, however I have resolved this issue by re-installing the ERPNext but now whenever I do bench update I got the same error.

https://discuss.erpnext.com/t/error-while-doing-bench-update-version-7/16217/3?u=ruchin78

Even, I tried the ALTER TABLE COMMAND shared by Ms. Kanchan Chauhan but it says table doesn’t exists.

I appreciate if anyone can help me in this context.

Regards
Ruchin Sharma

Can you please share the error trace again and can you also check the branch you are on?

Hi Ms. Kanchan,

Below is the trace:
vishnu@vishnu-VirtualBox:~/frappe-bench$ bench update
INFO:bench.utils:updating bench
Already up-to-date.
remote: Counting objects: 29, done.
remote: Compressing objects: 100% (29/29), done.
remote: Total 29 (delta 7), reused 0 (delta 0), pack-reused 0
Unpacking objects: 100% (29/29), done.
From https://github.com/frappe/frappe
77af845…6e9fb3b develop -> upstream/develop
Requirement already satisfied (use --upgrade to upgrade): Pillow in ./env/lib/python2.7/site-packages
INFO:bench.app:pulling frappe
From https://github.com/frappe/frappe

  • branch master -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling erpnext
    From https://github.com/frappe/erpnext
  • branch master -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling mandrill_integration
    From https://github.com/frappe/mandrill_integration
  • branch master -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling paypal_integration
    From https://github.com/frappe/paypal_integration
  • branch master -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling erpnext_shopify
    From https://github.com/frappe/erpnext_shopify
  • branch develop -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling razorpay_integration
    From https://github.com/frappe/razorpay_integration
  • branch master -> FETCH_HEAD
    Already up-to-date.
    INFO:bench.app:pulling knowledge_base
    From https://github.com/frappe/knowledge_base
  • branch master -> FETCH_HEAD
    Already up-to-date.
    Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages
    Migrating library
    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/vishnu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 79, in
    main()
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 16, in main
    click.Group(commands=commands)(prog_name=‘bench’)
    File “/home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 716, in call
    return self.main(*args, **kwargs)
    File “/home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 696, in main
    rv = self.invoke(ctx)
    File “/home/vishnu/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/vishnu/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/vishnu/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/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 534, in invoke
    return callback(*args, **kwargs)
    File “/home/vishnu/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/vishnu/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/commands/site.py”, line 207, in migrate
    migrate(context.verbose, rebuild_website=rebuild_website)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/migrate.py”, line 29, in migrate
    frappe.model.sync.sync_all(verbose=verbose)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/model/sync.py”, line 19, in sync_all
    sync_for(app, force, verbose=verbose)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/model/sync.py”, line 43, in sync_for
    import_file_by_path(doc_path, force=force)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 54, in import_file_by_path
    import_doc(doc, force=force, data_import=data_import, pre_process=pre_process)
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/modules/import_file.py”, line 122, in import_doc
    doc.insert()
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/model/document.py”, line 227, in insert
    d.db_insert()
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/model/base_document.py”, line 284, in db_insert
    ), d.values())
    File “/home/vishnu/frappe-bench/apps/frappe/frappe/database.py”, line 137, in sql
    self._cursor.execute(query, values)
    File “/home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
    self.errorhandler(self, exc, value)
    File “/home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
    raise errorclass, errorvalue
    _mysql_exceptions.OperationalError: (1048, “Column ‘columns’ cannot be null”)
    Traceback (most recent call last):
    File “/usr/local/bin/bench”, line 9, in
    load_entry_point(‘bench==3.0.0’, ‘console_scripts’, ‘bench’)()
    File “/home/vishnu/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/vishnu/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/vishnu/bench-repo/bench/commands/update.py”, line 90, in _update
    patch_sites(bench_path=bench_path)
    File “/home/vishnu/bench-repo/bench/utils.py”, line 161, in patch_sites
    run_frappe_cmd(’–site’, ‘all’, ‘migrate’, bench_path=bench_path)
    File “/home/vishnu/bench-repo/bench/utils.py”, line 501, in run_frappe_cmd
    raise CommandFailedError(args)
    bench.utils.CommandFailedError: (’–site’, ‘all’, ‘migrate’)

As far as branch is concern, I have no idea how to check it.

Regards
Ruchin Sharma

I have this same error. Trying to update version 7 on develop branch (10 commits behind or so) and it fails at:

File "/home/frappe/.bench/bench/utils.py", line 501, in run_frappe_cmd raise CommandFailedError(args) bench.utils.CommandFailedError: ('--site', 'all', 'migrate')

Thoughts?

Just pushed a fix: https://github.com/frappe/frappe/commit/8a87064541dda2ea8f45ba6001d6c9d7b9ba2e7d

Please try if this works

1 Like

Restored to the backup I make before trying an update, works perfectly now. Thank you.

1 Like

@rmehta
It worked for me as well, thanks.

Regards
Rcchin Sharma