Version 5 Upgrade Error

Here’s the latest error I get while trying to upgrade to ver 5:

promantest@promantest-erpn:~/frappe-bench$ bench update --upgrade
Already up-to-date.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)

  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/shopping_cart: Online Shopping Cart integrated with ERPNext
  • branch develop → FETCH_HEAD
    Already up-to-date.
    /home/promantest/frappe-bench/env/bin/python: cannot import name Retry
    Traceback (most recent call last):
    File “/usr/local/bin/bench”, line 9, in
    load_entry_point(‘bench==0.1’, ‘console_scripts’, ‘bench’)()
    File “/home/promantest/bench-repo/bench/cli.py”, line 55, in cli
    bench()
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 991, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 837, in invoke
    return ctx.invoke(self.callback, **ctx.params)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/promantest/bench-repo/bench/cli.py”, line 246, in update
    backup_all_sites()
    File “/home/promantest/bench-repo/bench/utils.py”, line 321, in backup_all_sites
    backup_site(site, bench=bench)
    File “/home/promantest/bench-repo/bench/utils.py”, line 317, in backup_site
    run_frappe_cmd(‘–site’, site, ‘backup’, bench=bench)
    File “/home/promantest/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 540, in check_call
    raise CalledProcessError(retcode, cmd)
    subprocess.CalledProcessError: Command ‘(’/home/promantest/frappe-bench/env/bin/python’, ‘-m’, ‘frappe.utils.bench_helper’, ‘frappe’, ‘–site’, ‘promantest.local’, ‘backup’)’ returned non-zero exit status 1

Run below command

bench update
bench switch-to-develop
bench retry-upgrade
sudo service nginx restart
sudo supervisorctl reload

After successful upgrade, there are chances you may get Redis error. To remove error use this

bench retry-upgrade
sudo service nginx restart
sudo supervisorctl reload

I am also getting a similar error.
Have tried the commands suggested, but still receive an error.

From GitHub - frappe/shopping_cart: Online Shopping Cart integrated with ERPNext

  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)
  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
  • branch develop → FETCH_HEAD
    Already up-to-date.
    /home/erpnext/frappe-bench/env/bin/python: cannot import name Retry
    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/core.py”, line 610, in call
    return self.main(*args, **kwargs)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 590, in main
    rv = self.invoke(ctx)
    File “/usr/local/lib/python2.7/dist-packages/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/core.py”, line 782, in invoke
    return ctx.invoke(self.callback, **ctx.params)
    File “/usr/local/lib/python2.7/dist-packages/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

Try bench update again

I did bench update again and made significant progress. Got stuck with this error though:

promantest@promantest-erpn:~/frappe-bench$ bench update
Already up-to-date.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)

  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/shopping_cart: Online Shopping Cart integrated with ERPNext
  • branch develop → FETCH_HEAD
    Already up-to-date.
    Migrating promantest.local
    Executing erpnext.patches.v5_0.capacity_planning in promantest.local (promantest.local)
    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/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 77, in
    main()
    File “/home/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 14, in main
    click.Group(commands=commands)(prog_name=‘bench’)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/home/promantest/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/promantest/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/promantest/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/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 28, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 202, in migrate
    frappe.modules.patch_handler.run_all()
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
    if not run_single(patchmodule = patch):
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
    return execute_patch(patchmodule, method, methodargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + “.execute”)()
    File “/home/promantest/frappe-bench/apps/erpnext/erpnext/patches/v5_0/capacity_planning.py”, line 8, in execute
    frappe.db.sql(“update tabStock Entry set additional_operating_cost = total_fixed_cost”)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/database.py”, line 143, in sql
    self._cursor.execute(query)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
    self.errorhandler(self, exc, value)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
    raise errorclass, errorvalue
    _mysql_exceptions.OperationalError: (1054, “Unknown column ‘total_fixed_cost’ in ‘field list’”)
    Traceback (most recent call last):
    File “/usr/local/bin/bench”, line 9, in
    load_entry_point(‘bench==0.1’, ‘console_scripts’, ‘bench’)()
    File “/home/promantest/bench-repo/bench/cli.py”, line 55, in cli
    bench()
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 991, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 837, in invoke
    return ctx.invoke(self.callback, **ctx.params)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/promantest/bench-repo/bench/cli.py”, line 247, in update
    patch_sites()
    File “/home/promantest/bench-repo/bench/utils.py”, line 118, in patch_sites
    run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
    File “/home/promantest/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 540, in check_call
    raise CalledProcessError(retcode, cmd)
    subprocess.CalledProcessError: Command ‘(’/home/promantest/frappe-bench/env/bin/python’, ‘-m’, ‘frappe.utils.bench_helper’, ‘frappe’, ‘–site’, ‘all’, ‘migrate’)’ returned non-zero exit status 1

If it helps, bench start, throws up the following in the console:

19:09:19 system | workerbeat.1 started (pid=7380)
19:09:19 system | web.1 started (pid=7378)
19:09:19 system | worker.1 started (pid=7379)
19:09:22 workerbeat.1 | celery beat v3.1.13 (Cipater) is starting.
19:09:22 web.1 | * Running on http://0.0.0.0:8000/
19:09:22 web.1 | * Restarting with reloader
19:09:23 workerbeat.1 | __ - … __ - _
19:09:23 workerbeat.1 | Configuration →
19:09:23 workerbeat.1 | . broker → redis://localhost:6379//
19:09:23 workerbeat.1 | . loader → celery.loaders.app.AppLoader
19:09:23 workerbeat.1 | . scheduler → celery.beat.PersistentScheduler
19:09:23 workerbeat.1 | . db → scheduler.schedule
19:09:23 workerbeat.1 | . logfile → [stderr]@%INFO
19:09:23 workerbeat.1 | . maxinterval → now (0s)
19:09:23 workerbeat.1 | [2015-05-01 19:09:23,100: INFO/MainProcess] beat: Starting…
19:09:23 worker.1 |
19:09:23 worker.1 | -------------- celery@promantest-erpn v3.1.13 (Cipater)
19:09:23 worker.1 | ---- **** -----
19:09:23 worker.1 | — * *** * – Linux-3.13.0-32-generic-i686-athlon-with-Ubuntu-14.04-trusty
19:09:23 worker.1 | – * - **** —
19:09:23 worker.1 | - ** ---------- [config]
19:09:23 worker.1 | - ** ---------- .> app: frappe:0xb66f21cc
19:09:23 worker.1 | - ** ---------- .> transport: redis://localhost:6379//
19:09:23 worker.1 | - ** ---------- .> results: disabled
19:09:23 worker.1 | - *** — * — .> concurrency: 2 (prefork)
19:09:23 worker.1 | – ******* ----
19:09:23 worker.1 | — ***** ----- [queues]
19:09:23 worker.1 | -------------- .> celery exchange=celery(direct) key=celery
19:09:23 worker.1 |
19:09:23 worker.1 |
19:09:24 workerbeat.1 | [2015-05-01 19:09:24,596: INFO/MainProcess] Scheduler: Sending due task scheduler (frappe.tasks.enqueue_scheduler_events)
19:09:25 worker.1 | [2015-05-01 19:09:25,778: WARNING/MainProcess] celery@promantest-erpn ready.
19:09:30 worker.1 | [2015-05-01 19:09:30,972: WARNING/Worker-1] frappe.tasks.scheduler_task[527e471a-e52e-4b80-9306-64940d537cdf]: Method: daily, Handler: erpnext.controllers.recurring_document.create_recurring_documents
19:09:30 worker.1 | Traceback (innermost last):
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/tasks.py”, line 77, in scheduler_task
19:09:30 worker.1 | frappe.get_attr(handler)()
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/controllers/recurring_document.py”, line 25, in create_recurring_documents
19:09:30 worker.1 | manage_recurring_documents(“Purchase Order”)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/controllers/recurring_document.py”, line 40, in manage_recurring_documents
19:09:30 worker.1 | and next_date <= ifnull(end_date, ‘2199-12-31’)“”“.format(doctype, next_date))
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/database.py”, line 143, in sql
19:09:30 worker.1 | self._cursor.execute(query)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
19:09:30 worker.1 | self.errorhandler(self, exc, value)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
19:09:30 worker.1 | raise errorclass, errorvalue
19:09:30 worker.1 | OperationalError: (1054, “Unknown column ‘recurring_id’ in ‘field list’”)
19:09:30 worker.1 |
19:09:30 worker.1 | [2015-05-01 19:09:30,990: ERROR/MainProcess] Task frappe.tasks.scheduler_task[527e471a-e52e-4b80-9306-64940d537cdf] raised unexpected: OperationalError(1054, “Unknown column ‘recurring_id’ in ‘field list’”)
19:09:30 worker.1 | Traceback (most recent call last):
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py”, line 240, in trace_task
19:09:30 worker.1 | R = retval = fun(*args, **kwargs)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py”, line 437, in protected_call
19:09:30 worker.1 | return self.run(*args, **kwargs)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/tasks.py”, line 77, in scheduler_task
19:09:30 worker.1 | frappe.get_attr(handler)()
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/controllers/recurring_document.py”, line 25, in create_recurring_documents
19:09:30 worker.1 | manage_recurring_documents(“Purchase Order”)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/controllers/recurring_document.py”, line 40, in manage_recurring_documents
19:09:30 worker.1 | and next_date <= ifnull(end_date, ‘2199-12-31’)”“”.format(doctype, next_date))
19:09:30 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/database.py”, line 143, in sql
19:09:30 worker.1 | self._cursor.execute(query)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
19:09:30 worker.1 | self.errorhandler(self, exc, value)
19:09:30 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
19:09:30 worker.1 | raise errorclass, errorvalue
19:09:30 worker.1 | OperationalError: (1054, “Unknown column ‘recurring_id’ in ‘field list’”)
19:10:01 web.1 | 127.0.0.1 - - [01/May/2015 19:10:01] “GET / HTTP/1.1” 503 -
19:10:01 web.1 | 127.0.0.1 - - [01/May/2015 19:10:01] “GET /favicon.ico HTTP/1.1” 503 -
19:10:48 worker.1 | [2015-05-01 19:10:48,294: WARNING/Worker-1] Traceback (innermost last):
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 36, in take_backups_dropbox
19:10:48 worker.1 | send_email(True, “Dropbox”)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 78, in send_email
19:10:48 worker.1 | frappe.sendmail(recipients=recipients, subject=subject, message=message)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/init.py”, line 340, in sendmail
19:10:48 worker.1 | cc=cc, message_id=message_id)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/init.py”, line 23, in sendmail
19:10:48 worker.1 | send(mail)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 30, in send
19:10:48 worker.1 | smtpserver.sess.sendmail(email.sender, email.recipients + (email.cc or []),
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 133, in sess
19:10:48 worker.1 | raise frappe.OutgoingEmailError, err_msg
19:10:48 worker.1 | OutgoingEmailError: Email Account not setup. Please create a new Email Account from Setup > Email > Email Account
19:10:48 worker.1 | [2015-05-01 19:10:48,893: WARNING/Worker-1] frappe.tasks.scheduler_task[c44822a1-f586-4594-b3af-a10db9250d73]: Method: daily_long, Handler: erpnext.setup.doctype.backup_manager.backup_manager.take_backups_daily
19:10:48 worker.1 | Traceback (innermost last):
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/tasks.py”, line 77, in scheduler_task
19:10:48 worker.1 | frappe.get_attr(handler)()
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 16, in take_backups_daily
19:10:48 worker.1 | take_backups_if(“Daily”)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 23, in take_backups_if
19:10:48 worker.1 | take_backups_dropbox()
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 41, in take_backups_dropbox
19:10:48 worker.1 | send_email(False, “Dropbox”, error_message)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 78, in send_email
19:10:48 worker.1 | frappe.sendmail(recipients=recipients, subject=subject, message=message)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/init.py”, line 340, in sendmail
19:10:48 worker.1 | cc=cc, message_id=message_id)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/init.py”, line 23, in sendmail
19:10:48 worker.1 | send(mail)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 30, in send
19:10:48 worker.1 | smtpserver.sess.sendmail(email.sender, email.recipients + (email.cc or []),
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 133, in sess
19:10:48 worker.1 | raise frappe.OutgoingEmailError, err_msg
19:10:48 worker.1 | OutgoingEmailError: Email Account not setup. Please create a new Email Account from Setup > Email > Email Account
19:10:48 worker.1 |
19:10:48 worker.1 | [2015-05-01 19:10:48,914: ERROR/MainProcess] Task frappe.tasks.scheduler_task[c44822a1-f586-4594-b3af-a10db9250d73] raised unexpected: OutgoingEmailError(u’Email Account not setup. Please create a new Email Account from Setup > Email > Email Account’,)
19:10:48 worker.1 | Traceback (most recent call last):
19:10:48 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py”, line 240, in trace_task
19:10:48 worker.1 | R = retval = fun(*args, **kwargs)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/celery/app/trace.py”, line 437, in protected_call
19:10:48 worker.1 | return self.run(*args, **kwargs)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/tasks.py”, line 77, in scheduler_task
19:10:48 worker.1 | frappe.get_attr(handler)()
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 16, in take_backups_daily
19:10:48 worker.1 | take_backups_if(“Daily”)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 23, in take_backups_if
19:10:48 worker.1 | take_backups_dropbox()
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 41, in take_backups_dropbox
19:10:48 worker.1 | send_email(False, “Dropbox”, error_message)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/erpnext/erpnext/setup/doctype/backup_manager/backup_manager.py”, line 78, in send_email
19:10:48 worker.1 | frappe.sendmail(recipients=recipients, subject=subject, message=message)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/init.py”, line 340, in sendmail
19:10:48 worker.1 | cc=cc, message_id=message_id)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/init.py”, line 23, in sendmail
19:10:48 worker.1 | send(mail)
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 30, in send
19:10:48 worker.1 | smtpserver.sess.sendmail(email.sender, email.recipients + (email.cc or []),
19:10:48 worker.1 | File “/home/promantest/frappe-bench/apps/frappe/frappe/email/smtp.py”, line 133, in sess
19:10:48 worker.1 | raise frappe.OutgoingEmailError, err_msg
19:10:48 worker.1 | OutgoingEmailError: Email Account not setup. Please create a new Email Account from Setup > Email > Email Account

hi @jramns as per error log seems like site1.local is renamed as promantest.local. Can you pls first migrate your sites . Just try in same sequence

bench clear cache
bench migrate site promantest.local
bench udpate

Hi Sunil,

Thanks for all your help to try and resolve my issue.

I guess I’m doing something wrong and I should feel sheepinh, but heck, what the heck:

When I try bench migrate site promantest.local, I get the follwoing error:

Usage: bench migrate [OPTIONS]

Error: Got unexpected extra arguments (site promantest.local)

But when I try bench migrate, I get the following error:

Migrating promantest.local
Executing erpnext.patches.v5_0.capacity_planning in promantest.local (promantest.local)
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/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 77, in
main()
File “/home/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 14, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
return self.main(*args, **kwargs)
File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
rv = self.invoke(ctx)
File “/home/promantest/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/promantest/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/promantest/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/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
return callback(*args, **kwargs)
File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 28, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 202, in migrate
frappe.modules.patch_handler.run_all()
File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
if not run_single(patchmodule = patch):
File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/promantest/frappe-bench/apps/erpnext/erpnext/patches/v5_0/capacity_planning.py”, line 8, in execute
frappe.db.sql(“update tabStock Entry set additional_operating_cost = total_fixed_cost”)
File “/home/promantest/frappe-bench/apps/frappe/frappe/database.py”, line 143, in sql
self._cursor.execute(query)
File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
self.errorhandler(self, exc, value)
File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, “Unknown column ‘total_fixed_cost’ in ‘field list’”)

Running bench update as is gives the following error:

Already up-to-date.
From GitHub - frappe/erpnext: Free and Open Source Enterprise Resource Planning (ERP)

  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/frappe: Low code web framework for real world applications, in Python and Javascript
  • branch develop → FETCH_HEAD
    Already up-to-date.
    From GitHub - frappe/shopping_cart: Online Shopping Cart integrated with ERPNext
  • branch develop → FETCH_HEAD
    Already up-to-date.
    Migrating promantest.local
    Executing erpnext.patches.v5_0.capacity_planning in promantest.local (promantest.local)
    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/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 77, in
    main()
    File “/home/promantest/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 14, in main
    click.Group(commands=commands)(prog_name=‘bench’)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/home/promantest/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/promantest/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/promantest/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/promantest/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 28, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/commands.py”, line 202, in migrate
    frappe.modules.patch_handler.run_all()
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
    if not run_single(patchmodule = patch):
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
    return execute_patch(patchmodule, method, methodargs)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + “.execute”)()
    File “/home/promantest/frappe-bench/apps/erpnext/erpnext/patches/v5_0/capacity_planning.py”, line 8, in execute
    frappe.db.sql(“update tabStock Entry set additional_operating_cost = total_fixed_cost”)
    File “/home/promantest/frappe-bench/apps/frappe/frappe/database.py”, line 143, in sql
    self._cursor.execute(query)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 205, in execute
    self.errorhandler(self, exc, value)
    File “/home/promantest/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
    raise errorclass, errorvalue
    _mysql_exceptions.OperationalError: (1054, “Unknown column ‘total_fixed_cost’ in ‘field list’”)
    Traceback (most recent call last):
    File “/usr/local/bin/bench”, line 9, in
    load_entry_point(‘bench==0.1’, ‘console_scripts’, ‘bench’)()
    File “/home/promantest/bench-repo/bench/cli.py”, line 55, in cli
    bench()
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 664, in call
    return self.main(*args, **kwargs)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 644, in main
    rv = self.invoke(ctx)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 991, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 837, in invoke
    return ctx.invoke(self.callback, **ctx.params)
    File “/usr/local/lib/python2.7/dist-packages/click/core.py”, line 464, in invoke
    return callback(*args, **kwargs)
    File “/home/promantest/bench-repo/bench/cli.py”, line 247, in update
    patch_sites()
    File “/home/promantest/bench-repo/bench/utils.py”, line 118, in patch_sites
    run_frappe_cmd(‘–site’, ‘all’, ‘migrate’, bench=bench)
    File “/home/promantest/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 540, in check_call
    raise CalledProcessError(retcode, cmd)
    subprocess.CalledProcessError: Command ‘(’/home/promantest/frappe-bench/env/bin/python’, ‘-m’, ‘frappe.utils.bench_helper’, ‘frappe’, ‘–site’, ‘all’, ‘migrate’)’ returned non-zero exit status 1

Hi,

I know you guys have a zillion things going on, but would you please help me resolve this issue?

Thanks

Jay