Upgrade error - Version 14

ERPNext
,
1

Hi Guys,

I have just upgraded, using command bench update --pull --reset --force, a site that already had version 14 to the latest version 14 release.

ERPNext: HEAD is now at 028e939cca chore(release): Bumped to Version 14.0.1
Frappe: HEAD is now at 808eae5c7d chore(release): Bumped to Version 14.4.0

I’m getting the following error

image
image1392×320 22.5 KB

On the logs I see the below;

Traceback (most recent call last):
  File "apps/frappe/frappe/www/app.py", line 26, in get_context
    boot = frappe.sessions.get()
  File "apps/frappe/frappe/sessions.py", line 161, in get
    bootinfo = get_bootinfo()
  File "apps/frappe/frappe/boot.py", line 103, in get_bootinfo
    bootinfo.translated_doctypes = get_translated_doctypes()
  File "apps/frappe/frappe/translate.py", line 1300, in get_translated_doctypes
    dts = frappe.get_all("DocType", {"translated_doctype": 1}, pluck="name")
  File "apps/frappe/frappe/__init__.py", line 1915, in get_all
    return get_list(doctype, *args, **kwargs)
  File "apps/frappe/frappe/__init__.py", line 1887, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
  File "apps/frappe/frappe/model/db_query.py", line 172, in execute
    result = self.build_and_run()
  File "apps/frappe/frappe/model/db_query.py", line 212, in build_and_run
    return frappe.db.sql(
  File "apps/frappe/frappe/database/database.py", line 209, in sql
    self._cursor.execute(query, values)
  File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute
    result = self._query(query)
  File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query
    conn.query(q)
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result
    result.read()
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'tabDocType.translated_doctype' in 'where clause'")

Anyone run into a similar issue?

Regards
N002213F

2

Hi,

Perhaps try bench build ?

3

I tried bench build, this only built the frontend assets.

4

Same here, I had to alter the db manually.

5

Hi, could you please share what you edited in the db?

6

Hi, I am also face this issue when i update Version-13,
erpnext 13.37.0
frappe 13.40.0

Any Solution.???

Screenshot from 2022-08-31 00-03-54

7

I managed to fix my issue.

I had to make sure my ERPNext instance was running, bench start when doing the upgrade for that fixtures/patches are run during the update, bench update --reset --requirements.

8

I solved this error
(1054, "Unknown column 'tabDocType.translated_doctype' in 'where clause'")

I ran bench --site {you-site-name} migrate

9

It’s working properly. But the CRM module is not showing on the main homepage.