Unknown column 'default_expense_claim_payable_account' in 'field list'

[olk]

Hallo,
ich habe ERPNext v15 + ERPNextSwiss installiert. Beim Aufruf von 'Bank wizard' erscheint die Meldung:

Please set the intermediate bank account in ERPNextSwiss Settings.
Please set the default customer in ERPNextSwiss Settings.
Please set the default supplier in ERPNextSwiss Settings.

Nach wegclicken der Meldung wird folgender Fehler ausgegeben:

App Versions

{
	"erpnext": "15.51.0",
	"erpnextswiss": "1.23.1",
	"frappe": "15.55.1",
	"print_designer": "1.0.0-dev"
}

Route

bank_wizard

Traceback

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 114, in application
    response = frappe.api.handle(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/__init__.py", line 49, in handle
    data = endpoint(**arguments)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
    return frappe.handler.handle()
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 50, in handle
    data = execute_cmd(cmd)
           ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 86, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 1726, in call
    return fn(*args, **newargs)
           ^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/erpnextswiss/erpnextswiss/erpnextswiss/page/bank_wizard/bank_wizard.py", line 158, in get_default_accounts
    expense_payable_account = frappe.get_value('Company', company, 'default_expense_claim_payable_account') or payable_account
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 2030, in get_value
    return db.get_value(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 515, in get_value
    result = self.get_values(
             ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 619, in get_values
    out = self._get_values_from_table(
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 892, in _get_values_from_table
    return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
    result = frappe.db.sql(query, params, *args, **kwargs)  # nosemgrep
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 230, in sql
    self._cursor.execute(query, values)
  File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
             ^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet
    packet.raise_for_error()
  File "env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'default_expense_claim_payable_account' in 'field list'")

Request Data

{
	"type": "POST",
	"args": {
		"bank_account": "1100 - Postbank - DK"
	},
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/erpnextswiss.erpnextswiss.page.bank_wizard.bank_wizard.get_default_accounts",
	"request_id": null
}

Response Data

{
	"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'default_expense_claim_payable_account' in 'field list'\")",
	"exc_type": "OperationalError",
	"_exc_source": "erpnextswiss (app)"
}

[lasalesi]

Die Ausgabe im Bankassistent verweist auf fehlende Konfigurationen. Bitte diese in der "ERPNextSwiss Einstellungen" entsprechend vornehmen (1 Kunde, 1 Lieferant und 1 Zwischenkonto setzen).

Die fehlende Spalte weist auf ein Problem in der Datenbankstruktur hin. Dies müsste sich mit

$ bench migrate

automatisch korrigieren.

[olk]

Nachdem ich die default-Einstellungen eingetragen hatte, traten die darauf bezogenen Fehlermeldungen icht mehr auf -danke.

Leider ist der Fehler 1054 bzl. "Unknown column 'default_expense_claim_payable_account' in 'field list'" trotz des Ausführens von 'bench migrate' vorhanden.

Installation von erpnextswiss:
bench get-app --branch v15 https://github.com/libracore/erpnextswiss.git
bench install-app erpnextswiss

Ich habe diesen weckgeclickt und eine CAMT053-Datein importiert - gleicher Fehler wird ausgegeben:

App Versions

{
	"banking": "15.12.6",
	"erpnext": "15.51.0",
	"erpnextswiss": "1.23.1",
	"frappe": "15.55.1"
}

Route

bank_wizard

Traceback

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 114, in application
    response = frappe.api.handle(request)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/__init__.py", line 49, in handle
    data = endpoint(**arguments)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
    return frappe.handler.handle()
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 50, in handle
    data = execute_cmd(cmd)
           ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/handler.py", line 86, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 1726, in call
    return fn(*args, **newargs)
           ^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/utils/typing_validations.py", line 31, in wrapper
    return func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^
  File "apps/erpnextswiss/erpnextswiss/erpnextswiss/page/bank_wizard/bank_wizard.py", line 158, in get_default_accounts
    expense_payable_account = frappe.get_value('Company', company, 'default_expense_claim_payable_account') or payable_account
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/__init__.py", line 2030, in get_value
    return db.get_value(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 515, in get_value
    result = self.get_values(
             ^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 619, in get_values
    out = self._get_values_from_table(
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 892, in _get_values_from_table
    return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query
    result = frappe.db.sql(query, params, *args, **kwargs)  # nosemgrep
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "apps/frappe/frappe/database/database.py", line 230, in sql
    self._cursor.execute(query, values)
  File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
             ^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet
    packet.raise_for_error()
  File "env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'default_expense_claim_payable_account' in 'field list'")

Request Data

{
	"type": "POST",
	"args": {
		"bank_account": "Bankkonto - DK"
	},
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/erpnextswiss.erpnextswiss.page.bank_wizard.bank_wizard.get_default_accounts",
	"request_id": null
}

Response Data

{
	"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'default_expense_claim_payable_account' in 'field list'\")",
	"exc_type": "OperationalError",
	"_exc_source": "erpnextswiss (app)"
}

[lasalesi]

Der neue Fehler deutet auf ein Problem mit der Datenstruktur hin. Ist das hrms-Modul installiert? Dieses muss in v15 installiert sein, und nach hrms muss erpnextswiss installiert werden - oder mit bench migrate die Strukturen erweitert.