Error updating V5 - Updating. We will be back in a few moments

Hi all, I got the following error updating V5 on my test box. Debian 7, Digital Ocean. I read through the forums and tried everything I can think of with no luck.

When navigating to the URL it shows:

Updating. We will be back in a few moments…

debian7@erp:~/frappe-bench$ bench update
Already up-to-date.
remote: Counting objects: 68, done.
remote: Compressing objects: 100% (68/68), done.
remote: Total 68 (delta 19), reused 0 (delta 0)
Unpacking objects: 100% (68/68), done.
From https://github.com/frappe/erpnext
 * branch            v5.0       -> FETCH_HEAD
Updating e1cb0ae..738d4ef
Fast-forward
 erpnext/accounts/doctype/journal_entry/journal_entry.json            |    9 +-
 erpnext/accounts/doctype/journal_entry/journal_entry_list.html       |   15 --
 erpnext/accounts/doctype/pos_setting/pos_setting.js                  |   21 ++
 erpnext/accounts/doctype/pos_setting/pos_setting.json                |   20 +-
 erpnext/accounts/doctype/purchase_invoice/purchase_invoice.json      |    6 +-
 erpnext/accounts/doctype/purchase_invoice/purchase_invoice_list.html |   43 ----
 erpnext/accounts/doctype/purchase_invoice/purchase_invoice_list.js   |   13 +-
 erpnext/accounts/doctype/sales_invoice/pos.py                        |   18 +-
 erpnext/accounts/doctype/sales_invoice/sales_invoice.js              |    1 +
 erpnext/accounts/doctype/sales_invoice/sales_invoice.json            |    6 +-
 erpnext/accounts/doctype/sales_invoice/sales_invoice.py              |    3 +-
 erpnext/accounts/doctype/sales_invoice/sales_invoice_list.html       |   43 ----
 erpnext/accounts/doctype/sales_invoice/sales_invoice_list.js         |   11 +-
 erpnext/buying/doctype/purchase_order/purchase_order.json            | 1471 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++---------------------------------------------------------------
 erpnext/buying/doctype/supplier/supplier.json                        |    4 +-
 erpnext/buying/doctype/supplier/supplier_list.html                   |   15 --
 erpnext/public/css/erpnext.css                                       |    8 +-
 erpnext/public/js/pos/pos.html                                       |    9 +-
 erpnext/public/js/pos/pos.js                                         |  218 ++++++++++++++-----
 erpnext/public/js/pos/pos_item.html                                  |    9 +-
 erpnext/public/js/transaction.js                                     |   60 +-----
 erpnext/selling/doctype/customer/customer.json                       |    5 +-
 erpnext/selling/doctype/customer/customer_list.html                  |   28 ---
 erpnext/selling/doctype/lead/lead.json                               |    8 +-
 erpnext/selling/doctype/lead/lead_list.html                          |   12 --
 erpnext/selling/doctype/lead/lead_list.js                            |    8 +-
 erpnext/selling/doctype/quotation/quotation.json                     |    4 +-
 erpnext/selling/doctype/quotation/quotation_list.html                |   16 --
 erpnext/selling/doctype/quotation/quotation_list.js                  |   11 +-
 erpnext/selling/doctype/sales_order/sales_order.json                 |    7 +-
 erpnext/selling/doctype/sales_order/sales_order_list.html            |   35 ---
 erpnext/selling/doctype/sales_order/sales_order_list.js              |   20 +-
 erpnext/selling/sales_common.js                                      |    2 +
 erpnext/stock/doctype/delivery_note/delivery_note.json               |    5 +-
 erpnext/stock/doctype/delivery_note/delivery_note_list.html          |   28 ---
 erpnext/stock/doctype/material_request/material_request.json         |    7 +-
 erpnext/stock/doctype/material_request/material_request_list.html    |   20 --
 erpnext/stock/doctype/material_request/material_request_list.js      |   11 +-
 erpnext/stock/doctype/purchase_receipt/purchase_receipt.json         |    8 +-
 erpnext/stock/doctype/purchase_receipt/purchase_receipt_list.html    |   34 ---
 erpnext/support/doctype/issue/issue_list.js                          |    3 +
 41 files changed, 1063 insertions(+), 1212 deletions(-)
 delete mode 100644 erpnext/accounts/doctype/journal_entry/journal_entry_list.html
 delete mode 100644 erpnext/accounts/doctype/purchase_invoice/purchase_invoice_list.html
 delete mode 100644 erpnext/accounts/doctype/sales_invoice/sales_invoice_list.html
 delete mode 100644 erpnext/buying/doctype/supplier/supplier_list.html
 delete mode 100644 erpnext/selling/doctype/customer/customer_list.html
 delete mode 100644 erpnext/selling/doctype/lead/lead_list.html
 delete mode 100644 erpnext/selling/doctype/quotation/quotation_list.html
 delete mode 100644 erpnext/selling/doctype/sales_order/sales_order_list.html
 delete mode 100644 erpnext/stock/doctype/delivery_note/delivery_note_list.html
 delete mode 100644 erpnext/stock/doctype/material_request/material_request_list.html
 delete mode 100644 erpnext/stock/doctype/purchase_receipt/purchase_receipt_list.html
 create mode 100644 erpnext/support/doctype/issue/issue_list.js
remote: Counting objects: 32, done.
remote: Compressing objects: 100% (31/31), done.
remote: Total 32 (delta 25), reused 7 (delta 0)
Unpacking objects: 100% (32/32), done.
From https://github.com/frappe/frappe
 * branch            v5.0       -> FETCH_HEAD
Updating 7ae3ca2..b3254ac
Fast-forward
 frappe/desk/form/load.py                             |    2 +-
 frappe/public/build.json                             |    1 +
 frappe/public/js/frappe/form/toolbar.js              |   12 +++---------
 frappe/public/js/frappe/list/list_item_standard.html |   10 ++++++----
 frappe/public/js/frappe/list/listview.js             |   38 +++++++++++++++++++++++++++++---------
 frappe/public/js/frappe/model/indicator.js           |   34 ++++++++++++++++++++++++++++++++++
 frappe/public/js/frappe/ui/page.js                   |    4 ++++
 frappe/public/js/frappe/views/container.js           |    8 ++++----
 frappe/public/js/legacy/form.js                      |    2 +-
 frappe/templates/form_grid/fields.html               |    3 ++-
 10 files changed, 85 insertions(+), 29 deletions(-)
 create mode 100644 frappe/public/js/frappe/model/indicator.js
database backup taken - ./site1.local/private/backups/20150106_739722_database.sql.gz - on 2015-01-06 13:12:58.852505

Running latest for site1.local
--------------------------------------------------
Executing erpnext.patches.v5_0.rename_table_fieldnames in site1.local (site1.local)
Traceback (most recent call last):
  File "/home/debian7/frappe-bench/env/bin/frappe", line 9, in <module>
    load_entry_point('frappe==4.6.1', 'console_scripts', 'frappe')()
  File "/home/debian7/frappe-bench/apps/frappe/frappe/cli.py", line 40, in main
    ret = run(fn, args)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/cli.py", line 84, in run
    out = globals().get(fn)(**args)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/cli.py", line 68, in new_fn
    return fn(*args, **new_kwargs)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/cli.py", line 443, in latest
    frappe.modules.patch_handler.run_all()
  File "/home/debian7/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all
    if not run_single(patchmodule = patch):
  File "/home/debian7/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 52, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 68, in execute_patch
    frappe.get_attr(patchmodule.split()[0] + ".execute")()
  File "/home/debian7/frappe-bench/apps/erpnext/erpnext/patches/v5_0/rename_table_fieldnames.py", line 234, in execute
    frappe.rename_doc("DocType", old_dt, new_dt, force=True)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/__init__.py", line 478, in rename_doc
    return rename_doc(doctype, old, new, force=force, merge=merge, ignore_permissions=ignore_permissions)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/model/rename_doc.py", line 37, in rename_doc
    rename_dynamic_links(doctype, old, new)
  File "/home/debian7/frappe-bench/apps/frappe/frappe/model/rename_doc.py", line 316, in rename_dynamic_links
    fieldname=df.fieldname), (doctype, old)):
  File "/home/debian7/frappe-bench/apps/frappe/frappe/database.py", line 186, in sql_list
    return [r[0] for r in self.sql(query, values, debug=debug)]
  File "/home/debian7/frappe-bench/apps/frappe/frappe/database.py", line 129, in sql
    self._cursor.execute(query, values)
  File "/home/debian7/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/debian7/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 'Customer' in 'where clause'")
Error: None
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/debian7/bench-repo/bench/cli.py", line 38, in cli
    return 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/debian7/bench-repo/bench/cli.py", line 170, in update
    patch_sites()
  File "/home/debian7/bench-repo/bench/utils.py", line 91, in patch_sites
    exec_cmd("{frappe} --latest all".format(frappe=get_frappe(bench=bench)), cwd=os.path.join(bench, 'sites'))
  File "/home/debian7/bench-repo/bench/utils.py", line 61, in exec_cmd
    subprocess.check_call(cmd, cwd=cwd, shell=True)
  File "/usr/lib/python2.7/subprocess.py", line 511, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '/home/debian7/frappe-bench/env/bin/frappe --latest all' returned non-zero exit status 1
debian7@erp:~/frappe-bench$

Thanks!

We could not replicate the issue.
Looks like you have created a custom field of fieldtype=“Dynamic Link” and set a wrong options value in that.

Hi @nabinhait thanks for looking into this. I will take a look at the DB and try to replace the incorrect option to get this working again.

Best,