phamos-eu / it_management

Management von IT-Bausteinen. Hierzu gehören IT-Geräte und IT-Lösungen wie Server, Rechner, Netzwerke und E-Mailserver sowie auch Backups, Dienstleistungsverträge, Accounts und Internetleistungen.
https://phamos.eu/module/it_management
GNU General Public License v3.0
64 stars 69 forks source link

Host Domain OnLoad ... pymysql.err.OperationalError: (1054, "Unknown column 'tabConfiguration Item.host_domain' in 'where clause'") #236

Open hreisenb opened 2 years ago

hreisenb commented 2 years ago

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 288, in get_open_count
    frappe.get_all(
  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 'tabConfiguration Item.host_domain' in 'where clause'")

Request Data

{
    "type": "GET",
    "args": {
        "doctype": "Host Domain",
        "name": "test.at",
        "items": "[\"Configuration Item\",\"Issue\"]"
    },
    "headers": {},
    "error_handlers": {},
    "url": "/api/method/frappe.desk.notifications.get_open_count"
}

Response Data

{
    "exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'tabConfiguration Item.host_domain' in 'where clause'\")"
}