Error while doing bench update Version 7

vishnu@vishnu-VirtualBox:~/frappe-bench$ bench restart
frappe-bench-frappe-schedule: stopped
frappe-bench-frappe-default-worker-0: stopped
frappe-bench-frappe-long-worker-0: stopped
frappe-bench-frappe-short-worker-0: stopped
frappe-bench-frappe-web: stopped
frappe-bench-node-socketio: stopped
frappe-bench-frappe-schedule: started
frappe-bench-frappe-default-worker-0: started
frappe-bench-frappe-long-worker-0: started
frappe-bench-frappe-short-worker-0: started
frappe-bench-frappe-web: started
frappe-bench-node-socketio: started
vishnu@vishnu-VirtualBox:~/frappe-bench$ bench update
INFO:bench.utils:updating bench
remote: Counting objects: 10, done.
remote: Compressing objects: 100% (10/10), done.
remote: Total 10 (delta 4), reused 0 (delta 0), pack-reused 0
Unpacking objects: 100% (10/10), done.
From https://github.com/frappe/bench
164bc13…ed846f2 master -> origin/master
Updating 164bc13…ed846f2
Fast-forward
README.md | 145 +++++++++++++++++++++++++++++++++++++++++±-------------------
1 file changed, 98 insertions(+), 47 deletions(-)
remote: Counting objects: 66, done.
remote: Compressing objects: 100% (19/19), done.
remote: Total 66 (delta 57), reused 56 (delta 47), pack-reused 0
Unpacking objects: 100% (66/66), done.
From https://github.com/frappe/frappe
be49d43…1f3abe9 develop -> upstream/develop
8230bb7…f3f0f6f hotfix -> upstream/hotfix
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
    remote: Counting objects: 12, done.
    remote: Compressing objects: 100% (12/12), done.
    remote: Total 12 (delta 3), reused 0 (delta 0), pack-reused 0
    Unpacking objects: 100% (12/12), done.
    From https://github.com/frappe/erpnext
  • branch master -> FETCH_HEAD
    6835a6f…0967b17 master -> upstream/master
    Updating 6835a6f…0967b17
    Fast-forward
    erpnext/init.py | 2 ±
    …/report/sales_register/sales_register.py | 13 ++±—
    erpnext/patches.txt | 2 ±
    …/daily_timesheet_summary.py | 42 +++++++++++++±-------
    4 files changed, 36 insertions(+), 23 deletions(-)
    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.
    /home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.
    SNIMissingWarning
    /home/vishnu/frappe-bench/env/local/lib/python2.7/site-packages/pip/vendor/requests/packages/urllib3/util/ssl.py:122: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
    InsecurePlatformWarning
    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’)
    vishnu@vishnu-VirtualBox:~/frappe-bench$

Hi,
I appreciate if anyone can let me know how to resolve this issue?

Regards
Ruchin Sharma

Try this from sql console:

ALTER TABLE tabDocfield MODIFY columns INT(1) DEFAULT '0';

1 Like

@KanchanChauhan

Thanks for your reply but before your reply I have already re-installed it.

Regards
Ruchin Sharma