Host Domain - pymysql.err.OperationalError: (1054, "Unknown column 'tabConfiguration Item.domain_name' in 'where clause'")

[hreisenb]

Tritt beim Erstellen einer Host Domain aus einer IT Landscape heraus auf. Tritt beim Öffnen einer Host Domain auf.

App Versions

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

Route

Form/Host Domain/test.at

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.dynamic_name' in 'where clause'")

Request Data

{
    "type": "GET",
    "args": {
        "doctype": "Configuration Item",
        "name": "Test CI1",
        "items": "[\"Software Instance\",\"User Account\",\"Configuration Item\",\"Issue\",\"IT Backup\",\"Maintenance Schedule\",\"Maintenance Visit\",\"Task\"]"
    },
    "headers": {},
    "error_handlers": {},
    "url": "/api/method/frappe.desk.notifications.get_open_count"
}

Response Data

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

[wojosc]

@hreisenb sollte hiermit behoben sein: https://github.com/phamos-eu/it_management/commit/3b7ed6d56c15f182ad4b427a138e368d8d497933