Getting Error While Updating Bench ERP Stopped Working

Hi
I just updated the bench and I am getting below errors.

ubuntu@ip-10-0-1-207:~/frappe-bench$ bench update --reset
INFO:bench.utils:updating bench
INFO:bench.utils:git pull
Already up-to-date.
INFO:bench.utils:./env/bin/pip install Pillow
Requirement already satisfied: Pillow in ./env/lib/python2.7/site-packages
INFO:bench.app:pulling frappe
INFO:bench.utils:git fetch --all
Fetching upstream
INFO:bench.utils:git reset --hard upstream/master
HEAD is now at 7a06746 Merge branch ‘develop’
INFO:bench.utils:find . -name “*.pyc” -delete
INFO:bench.app:pulling erpnext
INFO:bench.utils:git fetch --all
Fetching upstream
remote: Counting objects: 1653, done.
remote: Total 1653 (delta 1345), reused 1346 (delta 1345), pack-reused 307
Receiving objects: 100% (1653/1653), 575.76 KiB | 0 bytes/s, done.
Resolving deltas: 100% (1422/1422), completed with 725 local objects.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)

  • [new branch] Arundhatii-patch-1 → upstream/Arundhatii-patch-1
  • [new branch] Arundhatii-patch-2 → upstream/Arundhatii-patch-2
    5ad6126…78aac9e develop → upstream/develop
  • [new branch] eslintrc → upstream/eslintrc
    e0dc979…9e350ef gh-pages → upstream/gh-pages
    b596deb…654ccb8 hotfix → upstream/hotfix
  • [new branch] revert-9295-issue-7766-1 → upstream/revert-9295-issue-7766-1
  • [new tag] v8.0.25 → v8.0.25
  • [new tag] v8.0.26 → v8.0.26
  • [new tag] v8.0.27 → v8.0.27
  • [new tag] v8.0.28 → v8.0.28
  • [new tag] v8.0.29 → v8.0.29
  • [new tag] v8.0.30 → v8.0.30
  • [new tag] v8.0.31 → v8.0.31
  • [new tag] v8.0.32 → v8.0.32
  • [new tag] v8.0.33 → v8.0.33
  • [new tag] v8.0.34 → v8.0.34
  • [new tag] v8.0.35 → v8.0.35
  • [new tag] v8.0.36 → v8.0.36
  • [new tag] v8.0.37 → v8.0.37
  • [new tag] v8.0.38 → v8.0.38
  • [new tag] v8.0.39 → v8.0.39
  • [new tag] v8.0.40 → v8.0.40
  • [new tag] v8.0.41 → v8.0.41
  • [new tag] v8.0.42 → v8.0.42
  • [new tag] v8.0.43 → v8.0.43
  • [new tag] v8.0.44 → v8.0.44
  • [new tag] v8.0.45 → v8.0.45
  • [new tag] v8.0.46 → v8.0.46
  • [new tag] v8.0.47 → v8.0.47
  • [new tag] v8.0.48 → v8.0.48
  • [new tag] v8.0.49 → v8.0.49
  • [new tag] v8.0.50 → v8.0.50
  • [new tag] v8.0.51 → v8.0.51
  • [new tag] v8.1.0 → v8.1.0
    INFO:bench.utils:git reset --hard upstream/master
    HEAD is now at 78aac9e Merge branch ‘develop’
    INFO:bench.utils:find . -name “*.pyc” -delete
    Updating Python libraries…
    INFO:bench.utils:./env/bin/pip install --upgrade pip
    Requirement already up-to-date: pip in ./env/lib/python2.7/site-packages
    INFO:bench.utils:./env/bin/pip install -q -r /home/ubuntu/bench-repo/requirements.txt
    INFO:bench.utils:./env/bin/pip install -q -r ./apps/frappe/requirements.txt
    INFO:bench.utils:./env/bin/pip install -q -r ./apps/erpnext/requirements.txt
    INFO:bench.utils:./env/bin/pip install -q -r ./apps/library/requirements.txt
    Updating node libraries…
    INFO:bench.utils:npm install
    npm WARN optional Skipping failed optional dependency /chokidar/fsevents:
    npm WARN notsup Not compatible with your operating system or architecture: fsevents@1.1.2
    npm WARN frappe@ No description
    Backing up sites…
    Patching sites…
    Migrating library
    Updating DocTypes for frappe : [========================================]
    Syncing help database…
    Migrating site1.local
    Executing erpnext.patches.v8_0.change_in_words_varchar_length 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/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 91, in
    main()
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 17, in main
    click.Group(commands=commands)(prog_name=‘bench’)
    File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/home/ubuntu/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/ubuntu/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/ubuntu/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/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands/site.py”, line 216, in migrate
    migrate(context.verbose, rebuild_website=rebuild_website)
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/migrate.py”, line 31, in migrate
    frappe.modules.patch_handler.run_all()
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 29, in run_all
    if not run_single(patchmodule = patch):
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 63, in run_single
    return execute_patch(patchmodule, method, methodargs)
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 83, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + “.execute”)()
    File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/patches/v8_0/change_in_words_varchar_length.py”, line 13, in execute
    .format(dt, fieldname, fieldname))
    File “/home/ubuntu/frappe-bench/apps/frappe/frappe/database.py”, line 153, in sql
    self._cursor.execute(query)
    File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
    self.errorhandler(self, exc, value)
    File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 42, in defaulterrorhandler
    raise errorvalue
    _mysql_exceptions.OperationalError: (1118, ‘Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs’)

After that ERP Stopped Working:

Regards
Ruchin Sharma

https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/maximum-numbers-of-fields-in-a-form

I have updated the column type from VARCHAR(140) to text from the database itself, is that ok?

Regards
Ruchin Sharma

Yes, via alter table you can update type to BLOB or TEXT

Ya, its done then thanks @saurabh6790

@saurabh
After changing the datatype of custom fields it again got changed back to Varchar.
Is there any other way that we can permanently get rid-off this stuff without removing the fields itself?

Regards
Ruchin Sharma