Hallo,
ich kann bei einer einmal angelegten Stückliste die Teile weder umsortieren, noch löschen oder die Stückzahl ändern, nur neue Teile hinzufügen geht.
Ich verwende Dolibarr 17.0.0 unter
Ubuntu 22.04 mit
Apache 2.4.52
PHP 8.1.2
PostgreSQL-14.8-Datenbank
in einer VM (KVM/QEMU)
In der dolibarr.log steht folgendes:
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 1 WHERE rowid = 67
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error message: ERROR: 42703: record "new" has no field "tms"
CONTEXT: PL/pgSQL assignment "NEW.tms = now()"
PL/pgSQL function update_modified_column_tms() line 1 at assignment
LOCATION: plpgsql_exec_get_datum_type_info, pl_exec.c:5548 (DB_ERROR_NOSUCHFIELD)
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-30 14:31:15 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 1 WHERE rowid = 67, db_error=ERROR: 42703: record "new" has no field "tms"
CONTEXT: PL/pgSQL assignment "NEW.tms = now()"
PL/pgSQL function update_modified_column_tms() line 1 at assignment
LOCATION: plpgsql_exec_get_datum_type_info, pl_exec.c:5548
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 2 WHERE rowid = 68
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error message: ERROR: 42703: record "new" has no field "tms"
CONTEXT: PL/pgSQL assignment "NEW.tms = now()"
PL/pgSQL function update_modified_column_tms() line 1 at assignment
LOCATION: plpgsql_exec_get_datum_type_info, pl_exec.c:5548 (DB_ERROR_NOSUCHFIELD)
2023-06-30 14:31:15 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-30 14:31:15 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 2 WHERE rowid = 68, db_error=ERROR: 42703: record "new" has no field "tms"
CONTEXT: PL/pgSQL assignment "NEW.tms = now()"
PL/pgSQL function update_modified_column_tms() line 1 at assignment
LOCATION: plpgsql_exec_get_datum_type_info, pl_exec.c:5548
(...)
Hat jemand von Euch ein ähnliches Problem?
Grüße,
Frederic