Configuration Item - pymysql.err.OperationalError: (1054, "Unknown column 'tabMaintenance Visit.dynamic_name' in 'where clause'")

[hreisenb]

App Versions

{
    "erpnext": "13.27.0",
    "frappe": "13.22.2",
    "it_management": "0.0.1"
}

Route

Form/Configuration Item/Test CI1

Trackeback

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 69, in application
    response = frappe.api.handle()
  File "apps/frappe/frappe/api.py", line 55, in handle
    return frappe.handler.handle()
  File "apps/frappe/frappe/handler.py", line 38, in handle
    data = execute_cmd(cmd)
  File "apps/frappe/frappe/handler.py", line 76, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "apps/frappe/frappe/__init__.py", line 1448, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/__init__.py", line 767, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "apps/frappe/frappe/desk/notifications.py", line 283, in get_open_count
    frappe.get_all(d, fields="name", filters=filters, limit=100, distinct=True, ignore_ifnull=True)
  File "apps/frappe/frappe/__init__.py", line 1732, in get_all
    return get_list(doctype, *args, **kwargs)
  File "apps/frappe/frappe/__init__.py", line 1704, in get_list
    return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
  File "apps/frappe/frappe/model/db_query.py", line 159, in execute
    result = self.build_and_run()
  File "apps/frappe/frappe/model/db_query.py", line 199, in build_and_run
    return frappe.db.sql(
  File "apps/frappe/frappe/database/database.py", line 180, in sql
    self._cursor.execute(query)
  File "env/lib/python3.9/site-packages/pymysql/cursors.py", line 148, in execute
    result = self._query(query)
  File "env/lib/python3.9/site-packages/pymysql/cursors.py", line 310, in _query
    conn.query(q)
  File "env/lib/python3.9/site-packages/pymysql/connections.py", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "env/lib/python3.9/site-packages/pymysql/connections.py", line 775, in _read_query_result
    result.read()
  File "env/lib/python3.9/site-packages/pymysql/connections.py", line 1156, in read
    first_packet = self.connection._read_packet()
  File "env/lib/python3.9/site-packages/pymysql/connections.py", line 725, in _read_packet
    packet.raise_for_error()
  File "env/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "env/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'tabMaintenance Visit.it_landscape' in 'where clause'")

Request Data

{
    "type": "GET",
    "args": {
        "doctype": "IT Landscape",
        "name": "Test-Landscape-L01",
        "items": "[\"Configuration Item\",\"Solution\",\"IT Backup\",\"Licence\",\"User Account\",\"User Group\",\"Location\",\"Location Room\",\"Host Domain\",\"Subnet\",\"Issue\",\"Maintenance Visit\",\"IT Checklist\",\"Project\",\"Task\"]"
    },
    "headers": {},
    "error_handlers": {},
    "url": "/api/method/frappe.desk.notifications.get_open_count"
}

Response Data

{
    "exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'tabMaintenance Visit.it_landscape' in 'where clause'\")"
}

[wojosc]

@hreisenb dürfte mit https://github.com/phamos-eu/it_management/commit/e7ebfde7dabe12f8db2fcb05da5bc3f4b670fb6b behoben sein.

Bitte kurz testen nach dem geupdated wurde. Danke.

Schneller dürfte es gehen, wenn sie in

frappe-bench/apps/it_management gehen... dort dann git pull und dann bench migrate .

Das dürfte schon reichen. Vorausgesetzt sie haben es zuvor in Ihren Fork gezogen.