Unable to confirm supplier order

Using my Dolibarr CRM/SRM Modules
1

Unfortunately, the error message does not provide any details on the nature of the error. Any hint where I should look further?

Das System hat einen technischen Fehler festgestellt.
Diese Informationen können für Diagnosezwecke nützlich sein (Sie können die Option $dolibarr_main_prod auf ‘1’ setzen, um sensible Informationen auszublenden):
Datum: 20230209115103
Dolibarr: 15.0.2 - https://www.dolibarr.org
Funktionslevel: 0
PHP: 7.4.33
Server: Apache/2.4.55 (Ubuntu)
OS: Linux al-doli 5.15.0-58-generic #64-Ubuntu SMP Thu Jan 5 11:43:13 UTC 2023 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0

Angefragte URL: /dolibarr/fourn/commande/card.php?id=5359&action=confirm_valid&confirm=yes&token=a95863ae87c122763b8193de6aeb45d1
Referer: http://10.2.0.3/dolibarr/fourn/commande/card.php?id=5359&action=valid
Menüverwaltung: eldy_menu.php

Module/Anwendungen: api, syslog, user, mylist, categorie, multicurrency, import, export, notification, myfield, propal, expedition, supplier_proposal, reception, workflow, product, clicktodial, stock, productbatch, projet, agenda, bom, barcode, commande, ecm, facture, fournisseur, mrp, printing, resource, service, societe, variants
Datenbank Type Manager: mysqli
Letzter Fehlerhafter Datenbankzugriff: Keine Anfrage im Fehler
Rückgabewert des letzten fehlerhaften Datenbankzugriff: Keine Anfrage im Fehler
Information zum letzten fehlerhaften Datenbankzugriff: Keine Anfrage im Fehler

Message: -1

As a workaround, we set up a new order with the same line items. Fortunately, this works well. However, understanding the root cause for this would help gaining trust with my client.

Thanks a lot for your thoughts.

Oliver

2

Consulting the log issue got identified: I renamed an ODT template that was originally used with that supplier order. When rejecting/reopening the order it is looking for that template. With the template back in place, error is gone.

2023-02-09 16:19:00 INFO    10.2.0.254       commonGenerateDocument modele=generic_supplier_order_odt:/var/documents/doctemplates/supplier_orders/PO_temp.odt
 outputlangs->defaultlang=de_DE
2023-02-09 16:19:00 WARNING 10.2.0.254       Failed to locate template file /var/documents/doctemplates/supplier_orders/PO_temp.odt
2023-02-09 16:19:00 ERR     10.2.0.254       Error url=/dolibarr/fourn/commande/card.php?id=5352&action=confirm_valid&confirm=yes&token=a95863ae8
7c122763b8193de6aeb45d1, query_string=id=5352&action=confirm_valid&confirm=yes&token=a95863ae87c122763b8193de6aeb45d1, sql=SELECT rowid, date_liv
raison, approved_delivery_date, manufacturer, manufacturer_partnumber, unit FROM llx_commande_fournisseurdet_extrafields WHERE fk_object = 14649, db_error=,
msg=-1
2023-02-09 16:19:00 DEBUG   10.2.0.254      ROLLBACK Transaction

Just FYI in case you’ll get across a similar issue.

1 Like