Errore fattura acquisto

dennyxx82

Importando una fattura acquisto mi si presenta il seguente errore:

Dettagli tecnici dell'errore:
Messaggio: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'idconto' cannot be null (Connection: default, SQL: insert into co_righe_documenti (iddocumento, order, descrizione, idiva, idconto, prezzo_unitario, iva_unitaria, prezzo_unitario_ivato, qta, ritenutaacconto, rivalsainps, subtotale, sconto, tipo_sconto, provvigione, tipo_provvigione, iva, desc_iva, iva_indetraibile, created_at) values (2061, 7, Arrotondamento calcolato in automatico, 103, ?, 66, 0, 66, 1, 0, 0, 66, 0, PRC, 0, UNT, 0, Es. art.10 n.18, 0, 2025-09-07 20:39:36))
File: /var/www/html/officine/vendor/illuminate/database/Connection.php
Linea: 829

Informazioni di sistema:
Versione PHP: 8.1.2-1ubuntu2.22
Sistema operativo: Linux cdnserver 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64

Versione OpenSTAManager: [2.9.1]

robporta

Ho lo stesso problema con fattura ENEL, altre fatture al momento non danno il problema
è una fattura senza articoli

lucas

Ciao, potresti provare ad applicare questa fix per verificare se il problema si risolve? devcode-it/openstamanager@2eaa725

robporta79

Ho applicato la correzione, non da più l'errore ma la fattura non viene caricata

da la seguente schermata

lucas

Nella cartella logs presente nella root del gestionale viene loggato qualche errore?
L'xml della fattura elettronica, se caricato in questo portale viene validato correttamente?
https://fex-app.com/servizi/verifica

robporta79

lucas La fattura è corretta, viene caricata da altro software normalmente, è del 2022, stiamo caricando tutta la vecchia contabilità
Dopo la correzione, non carica neppure le altre fatture, sempre stessa schermata
Non ci sono errori nel log dopo la correzione
Allego ultime righe log

[2025-09-08T19:38:10.118589+02:00] Logs.ERROR: round(): Passing null to parameter #1 ($num) of type int|float is deprecated {"code":8192,"message":"round(): Passing null to parameter #1 ($num) of type int|float is deprecated","file":"/var/www/html/sardomgest2025/modules/fatture/actions.php","line":311,"trace":"#0 /var/www/html/sardomgest2025/vendor/monolog/monolog/src/Monolog/ErrorHandler.php(224): Whoops\Run->handleError()\n#1 [internal function]: Monolog\ErrorHandler->handleError()\n#2 /var/www/html/sardomgest2025/modules/fatture/actions.php(311): round()\n#3 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#4 {main}"}
{"url":"/sardomgest2025/actions.php","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_record=225","uid":"d28cf56"}
[2025-09-08T19:39:02.098552+02:00] Logs.ERROR: round(): Passing null to parameter #1 ($num) of type int|float is deprecated {"code":8192,"message":"round(): Passing null to parameter #1 ($num) of type int|float is deprecated","file":"/var/www/html/sardomgest2025/modules/fatture/actions.php","line":311,"trace":"#0 /var/www/html/sardomgest2025/vendor/monolog/monolog/src/Monolog/ErrorHandler.php(224): Whoops\Run->handleError()\n#1 [internal function]: Monolog\ErrorHandler->handleError()\n#2 /var/www/html/sardomgest2025/modules/fatture/actions.php(311): round()\n#3 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#4 {main}"}
{"url":"/sardomgest2025/actions.php","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_record=225","uid":"40ba298"}
[2025-09-08T19:39:27.607952+02:00] Logs.ERROR: round(): Passing null to parameter #1 ($num) of type int|float is deprecated {"code":8192,"message":"round(): Passing null to parameter #1 ($num) of type int|float is deprecated","file":"/var/www/html/sardomgest2025/modules/fatture/actions.php","line":311,"trace":"#0 /var/www/html/sardomgest2025/vendor/monolog/monolog/src/Monolog/ErrorHandler.php(224): Whoops\Run->handleError()\n#1 [internal function]: Monolog\ErrorHandler->handleError()\n#2 /var/www/html/sardomgest2025/modules/fatture/actions.php(311): round()\n#3 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#4 {main}"}
{"url":"/sardomgest2025/actions.php","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_record=225","uid":"33637dd"}
[2025-09-08T19:40:07.330742+02:00] Logs.ERROR: round(): Passing null to parameter #1 ($num) of type int|float is deprecated {"code":8192,"message":"round(): Passing null to parameter #1 ($num) of type int|float is deprecated","file":"/var/www/html/sardomgest2025/modules/fatture/actions.php","line":311,"trace":"#0 /var/www/html/sardomgest2025/vendor/monolog/monolog/src/Monolog/ErrorHandler.php(224): Whoops\Run->handleError()\n#1 [internal function]: Monolog\ErrorHandler->handleError()\n#2 /var/www/html/sardomgest2025/modules/fatture/actions.php(311): round()\n#3 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#4 {main}"}
{"url":"/sardomgest2025/actions.php","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_record=225&visualizza_movimenti=1","uid":"8e7bb7e"}
[2025-09-08T19:40:34.203198+02:00] Logs.ERROR: round(): Passing null to parameter #1 ($num) of type int|float is deprecated {"code":8192,"message":"round(): Passing null to parameter #1 ($num) of type int|float is deprecated","file":"/var/www/html/sardomgest2025/modules/fatture/actions.php","line":311,"trace":"#0 /var/www/html/sardomgest2025/vendor/monolog/monolog/src/Monolog/ErrorHandler.php(224): Whoops\Run->handleError()\n#1 [internal function]: Monolog\ErrorHandler->handleError()\n#2 /var/www/html/sardomgest2025/modules/fatture/actions.php(311): round()\n#3 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#4 {main}"}
{"url":"/sardomgest2025/actions.php","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_record=225","uid":"e3fd6da"}
[2025-09-08T20:26:14.750079+02:00] Logs.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'idconto' cannot be null (Connection: default, SQL: insert into co_righe_documenti (iddocumento, order, descrizione, idiva, idconto, prezzo_unitario, iva_unitaria, prezzo_unitario_ivato, qta, ritenutaacconto, rivalsainps, subtotale, sconto, tipo_sconto, provvigione, tipo_provvigione, iva, desc_iva, iva_indetraibile, created_at) values (1084, 23, Arrotondamento calcolato in automatico, 103, ?, 33.74, 0, 33.74, 1, 0, 0, 33.74, 0, PRC, 0, UNT, 0, Es. art.10 n.18, 0, 2025-09-08 20:26:14)) {"code":"23000","message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'idconto' cannot be null (Connection: default, SQL: insert into co_righe_documenti (iddocumento, order, descrizione, idiva, idconto, prezzo_unitario, iva_unitaria, prezzo_unitario_ivato, qta, ritenutaacconto, rivalsainps, subtotale, sconto, tipo_sconto, provvigione, tipo_provvigione, iva, desc_iva, iva_indetraibile, created_at) values (1084, 23, Arrotondamento calcolato in automatico, 103, ?, 33.74, 0, 33.74, 1, 0, 0, 33.74, 0, PRC, 0, UNT, 0, Es. art.10 n.18, 0, 2025-09-08 20:26:14))","file":"/var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php","line":829,"trace":"#0 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()\n#1 /var/www/html/sardomgest2025/vendor/illuminate/database/MySqlConnection.php(34): Illuminate\Database\Connection->run()\n#2 /var/www/html/sardomgest2025/vendor/illuminate/database/Query/Processors/MySqlProcessor.php(35): Illuminate\Database\MySqlConnection->insert()\n#3 /var/www/html/sardomgest2025/vendor/illuminate/database/Query/Builder.php(3549): Illuminate\Database\Query\Processors\MySqlProcessor->processInsertGetId()\n#4 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Builder.php(1982): Illuminate\Database\Query\Builder->insertGetId()\n#5 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Model.php(1334): Illuminate\Database\Eloquent\Builder->__call()\n#6 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Model.php(1299): Illuminate\Database\Eloquent\Model->insertAndSetId()\n#7 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert()\n#8 /var/www/html/sardomgest2025/src/Common/Components/Component.php(360): Illuminate\Database\Eloquent\Model->save()\n#9 /var/www/html/sardomgest2025/src/Common/Components/Accounting.php(417): Common\Components\Component->save()\n#10 /var/www/html/sardomgest2025/modules/fatture/src/Components/RelationTrait.php(168): Common\Components\Accounting->save()\n#11 /var/www/html/sardomgest2025/plugins/importFE/src/FatturaOrdinaria.php(526): Modules\Fatture\Components\Riga->save()\n#12 /var/www/html/sardomgest2025/plugins/importFE/src/FatturaElettronica.php(407): Plugins\ImportFE\FatturaOrdinaria->saveRighe()\n#13 /var/www/html/sardomgest2025/plugins/importFE/actions.php(149): Plugins\ImportFE\FatturaElettronica->save()\n#14 /var/www/html/sardomgest2025/actions.php(530): include('...')\n#15 /var/www/html/sardomgest2025/editor.php(69): include_once('...')\n#16 {main}"}
{"url":"/sardomgest2025/editor.php?id_module=15&id_plugin=19&id_record=1&","ip":"192.168.0.79","http_method":"POST","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/editor.php?id_module=15&id_plugin=19&id_record=1&","uid":"e1b3c55"}
[2025-09-08T22:32:00.040286+02:00] Logs.ERROR: SQLSTATE[HY000] [2002] No such file or directory (Connection: default, SQL: update zz_cache set content = true, expire_at = 2025-10-08 22:32:00, zz_cache.updated_at = 2025-09-08 22:32:00 where id = 7) {"code":2002,"message":"SQLSTATE[HY000] [2002] No such file or directory (Connection: default, SQL: update zz_cache set content = true, expire_at = 2025-10-08 22:32:00, zz_cache.updated_at = 2025-09-08 22:32:00 where id = 7)","file":"/var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php","line":829,"trace":"#0 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(983): Illuminate\Database\Connection->runQueryCallback()\n#1 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(962): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()\n#2 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(785): Illuminate\Database\Connection->handleQueryException()\n#3 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(600): Illuminate\Database\Connection->run()\n#4 /var/www/html/sardomgest2025/vendor/illuminate/database/Connection.php(552): Illuminate\Database\Connection->affectingStatement()\n#5 /var/www/html/sardomgest2025/vendor/illuminate/database/Query/Builder.php(3602): Illuminate\Database\Connection->update()\n#6 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Builder.php(1061): Illuminate\Database\Query\Builder->update()\n#7 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Model.php(1214): Illuminate\Database\Eloquent\Builder->update()\n#8 /var/www/html/sardomgest2025/vendor/illuminate/database/Eloquent/Model.php(1131): Illuminate\Database\Eloquent\Model->performUpdate()\n#9 /var/www/html/sardomgest2025/src/Models/Cache.php(90): Illuminate\Database\Eloquent\Model->save()\n#10 /var/www/html/sardomgest2025/src/Models/Cache.php(77): Models\Cache->save()\n#11 /var/www/html/sardomgest2025/cron.php(119): Models\Cache->set()\n#12 {main}"}
{"url":"/sardomgest2025/cron.php","ip":"192.168.0.232","http_method":"GET","server":"192.168.0.232","referrer":"http://192.168.0.232/sardomgest2025/controller.php?id_module=14","uid":"430673f"}

robporta79

Server Linux Mint desktop con PHP 8.3.24, dove girava la versione 2.8.3