[RISOLTO] Errore importazione XML su OSM 2.5.5

sajo

stiamo testando una installazione pulita OSM 2.5.5 su server con requisiti richiesti.
( https://forum.openstamanager.com/d/3009-installazione-pulita-osm-255 )

precisiamo che tutti i controlli di integrità installazione e requisiti sono ok senza alcun problema.

se importiamo un XML e selezioniamo crea Creazione automatica articoli
il sistema presenta l'errore.

sembra che non riesce a creare la categoria Importazione automatica
se in tabelle creiamo tale categoria manualmente l'errore non si presenta più

e da un'altro errore sulla descrizione articolo.

sajo

questo l'errore nei logs

[2024-10-21 13:12:53] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (13, 1, Importazione automatica))" at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php line 712 {"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (13, 1, Importazione automatica)) at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php:712, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php:495)
[stacktrace]
#0 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run()
#2 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement()
#3 /var/www/html/openstamanager/vendor/illuminate/database/Query/Builder.php(2978): Illuminate\Database\Connection->insert()
#4 /var/www/html/openstamanager/src/Traits/RecordTrait.php(132): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/openstamanager/plugins/importFE/src/FatturaOrdinaria.php(275): Modules\Articoli\Categoria->setTranslation()
#6 /var/www/html/openstamanager/plugins/importFE/src/FatturaElettronica.php(393): Plugins\ImportFE\FatturaOrdinaria->saveRighe()
#7 /var/www/html/openstamanager/plugins/importFE/actions.php(147): Plugins\ImportFE\FatturaElettronica->save()
#8 /var/www/html/openstamanager/actions.php(489): include('...')
#9 /var/www/html/openstamanager/editor.php(69): include_once('...')
#10 {main}
"}
{"url":"/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","ip”:”XXXXX”,”http_method":"POST","server":"XXXXX","referrer":"http://XXXXX/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","uid":"5d9ca6c"}
[2024-10-21 13:12:53] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (13, 1, Importazione automatica)) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (13, 1, Importazione automatica))","file":"/var/www/html/openstamanager/vendor/illuminate/database/Connection.php","line":712,"trace":"#0 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run()
#2 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement()
#3 /var/www/html/openstamanager/vendor/illuminate/database/Query/Builder.php(2978): Illuminate\Database\Connection->insert()
#4 /var/www/html/openstamanager/src/Traits/RecordTrait.php(132): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/openstamanager/plugins/importFE/src/FatturaOrdinaria.php(275): Modules\Articoli\Categoria->setTranslation()
#6 /var/www/html/openstamanager/plugins/importFE/src/FatturaElettronica.php(393): Plugins\ImportFE\FatturaOrdinaria->saveRighe()
#7 /var/www/html/openstamanager/plugins/importFE/actions.php(147): Plugins\ImportFE\FatturaElettronica->save()
#8 /var/www/html/openstamanager/actions.php(489): include('...')
#9 /var/www/html/openstamanager/editor.php(69): include_once('...')
#10 {main}"}
{"url":"/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","ip":"XXXXX","http_method":"POST","server":"XXXXX","referrer":"http://XXXXX/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","uid":"5d9ca6c"}
[2024-10-21 13:12:57] Logs.ERROR: Uncaught Exception Illuminate\Database\QueryException: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (14, 1, Importazione automatica))" at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php line 712 {"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (14, 1, Importazione automatica)) at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php:712, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' at /var/www/html/openstamanager/vendor/illuminate/database/Connection.php:495)
[stacktrace]
#0 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run()
#2 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement()
#3 /var/www/html/openstamanager/vendor/illuminate/database/Query/Builder.php(2978): Illuminate\Database\Connection->insert()
#4 /var/www/html/openstamanager/src/Traits/RecordTrait.php(132): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/openstamanager/plugins/importFE/src/FatturaOrdinaria.php(275): Modules\Articoli\Categoria->setTranslation()
#6 /var/www/html/openstamanager/plugins/importFE/src/FatturaElettronica.php(393): Plugins\ImportFE\FatturaOrdinaria->saveRighe()
#7 /var/www/html/openstamanager/plugins/importFE/actions.php(147): Plugins\ImportFE\FatturaElettronica->save()
#8 /var/www/html/openstamanager/actions.php(489): include('...')
#9 /var/www/html/openstamanager/editor.php(69): include_once('...')
#10 {main}
"}
{"url":"/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","ip":"XXXXX","http_method":"POST","server":"XXXXX","referrer":"http://XXXXX/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","uid":"dec010f"}
[2024-10-21 13:12:57] Logs.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (14, 1, Importazione automatica)) {"code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nome' in 'field list' (SQL: insert into mg_categorie_lang (id_record, id_lang, nome) values (14, 1, Importazione automatica))","file":"/var/www/html/openstamanager/vendor/illuminate/database/Connection.php","line":712,"trace":"#0 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run()
#2 /var/www/html/openstamanager/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement()
#3 /var/www/html/openstamanager/vendor/illuminate/database/Query/Builder.php(2978): Illuminate\Database\Connection->insert()
#4 /var/www/html/openstamanager/src/Traits/RecordTrait.php(132): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/openstamanager/plugins/importFE/src/FatturaOrdinaria.php(275): Modules\Articoli\Categoria->setTranslation()
#6 /var/www/html/openstamanager/plugins/importFE/src/FatturaElettronica.php(393): Plugins\ImportFE\FatturaOrdinaria->saveRighe()
#7 /var/www/html/openstamanager/plugins/importFE/actions.php(147): Plugins\ImportFE\FatturaElettronica->save()
#8 /var/www/html/openstamanager/actions.php(489): include('...')
#9 /var/www/html/openstamanager/editor.php(69): include_once('...')
#10 {main}"}
{"url":"/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","ip":"XXXXX","http_method":"POST","server":"XXXXX","referrer":"http://XXXXX/openstamanager/editor.php?id_module=15&id_plugin=19&id_record=2&data_registrazione=&","uid":"dec010f"}

sajo

con questa FIX si risolve.
devcode-it/openstamanager@fa6a6bd (diff)

scusate, ho visto ora che c'era un post con lo stesso problema
https://forum.openstamanager.com/d/2974-problema-importa-xml-fattura-acquisto/11