Hi Sven,
ich habe die Funktion aktiviert und etwas mit den Stücklisten gearbeitet. Dabei ist mir aufgefallen, daß Einträge sich nicht löschen oder umsortieren lassen. Es kommt zwar die Meldung, der Datensatz werde gelöscht, er steht aber immer noch in der Liste.
2023-06-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 1 WHERE rowid = 67
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 2 WHERE rowid = 68
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 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
2023-06-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 3 WHERE rowid = 75
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 3 WHERE rowid = 75, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 4 WHERE rowid = 69
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 4 WHERE rowid = 69, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 5 WHERE rowid = 70
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 5 WHERE rowid = 70, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 6 WHERE rowid = 71
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 6 WHERE rowid = 71, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 7 WHERE rowid = 72
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 7 WHERE rowid = 72, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 8 WHERE rowid = 73
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 8 WHERE rowid = 73, 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET position = 9 WHERE rowid = 74
2023-06-29 13:47:06 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-29 13:47:06 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:06 ERR 192.168.178.24 Error url=/core/ajax/row.php, query_string=, sql=UPDATE llx_bom_bomline SET position = 9 WHERE rowid = 74, 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-29 13:47:10 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET fk_bom=7, fk_product=29, fk_bom_child=NULL, description=NULL, qty=1, qty_frozen=0, disable_stock_change=0, efficiency=1, fk_unit=NULL, position=3, import_key=NULL WHERE rowid=70
2023-06-29 13:47:10 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-29 13:47:10 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:41 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: UPDATE llx_bom_bomline SET fk_bom=7, fk_product=21, fk_bom_child=NULL, description=NULL, qty=0, qty_frozen=0, disable_stock_change=0, efficiency=1, fk_unit=NULL, position=3, import_key=NULL WHERE rowid=69
2023-06-29 13:47:41 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-29 13:47:41 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
2023-06-29 13:47:41 ERR 192.168.178.24 BOM::addLine error=
2023-06-29 13:48:05 ERR 192.168.178.24 DoliDBPgsql::query SQL Error query: SELECT u.rowid, u.firstname, u.lastname, u.birth as datea, 'birth' as typea, u.email, u.statut as status FROM llx_user as u WHERE u.entity IN (0,1) AND u.statut = 1 AND date_format( u.birth, '%c') = '6' UNION SELECT u.rowid, u.firstname, u.lastname, u.dateemployment as datea, 'employment' as typea, u.email, u.statut as status FROM llx_user as u WHERE u.entity IN (0,1) AND u.statut = 1 AND date_format( u.dateemployment, '%c') = '6' ORDER BY DAY(datea) ASC
2023-06-29 13:48:05 ERR 192.168.178.24 DoliDBPgsql::query SQL Error message: ERROR: 0A000: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
LINE 1: ...te_format( u.dateemployment, '%c') = '6' ORDER BY DAY(datea)...
^
DETAIL: Only result column names can be used, not expressions or functions.
HINT: Add the expression/function to every SELECT, or move the UNION into a FROM clause.
LOCATION: transformSetOperationStmt, analyze.c:1808 (DB_ERROR_ERROR: 0A000: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
LINE 1: ...te_format( u.dateemployment, '%c') = '6' ORDER BY DAY(datea)...
^
DETAIL: Only result column names can be used, not expressions or functions.
HINT: Add the expression/function to every SELECT, or move the UNION into a FROM clause.
LOCATION: transformSetOperationStmt, analyze.c:1808)
2023-06-29 13:48:05 ERR 192.168.178.24 DoliDBPgsql::query SQL Error usesavepoint = 0
Man kann Stücklisten erstellen, wenn man das Attribut Produktart entfernt und hinterher wieder setzt, die Fehlermeldung „Error forging a SQL request…“ (siehe oben) bleibt aber.
Welche Informationen über mein System könnten noch hilfreich sein?
Grüße,
Ernst