Error when importing an excel to fill product stocks

[alihusseinc]

Bug

When I try to import an Excel to fill product stocks, I get a 500 error page

Dolibarr Version

No response

Environment PHP

No response

Environment Database

No response

Steps to reproduce the behavior and expected behavior

No response

Attached files

No response

[JonBendtsen]

which version of dolibarr? What kind of setup do you have? PHP version, database version, ...

What does the dolibarr.log file contain?

[alihusseinc]

dolibarr 19.0.1,php 8.2.12, phpMyAdmin 5.2.1, xampp
dolibarr.log

[JonBendtsen]

okay, and your webservers log file? what does that say?

[alihusseinc]

[Thu Mar 28 13:19:38.538505 2024] [php:warn] [pid 3156:tid 1900] [client ::1:59511] PHP Warning: file_get_contents(): Unable to find the wrapper "zip" - did you forget to enable it when you configured PHP? in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Security\XmlScanner.php on line 152, referer: http://localhost/
[Thu Mar 28 13:19:38.541540 2024] [php:warn] [pid 3156:tid 1900] [client ::1:59511] PHP Warning: file_get_contents(zip://C:\xampp\htdocs\dolibarr\documents\import\temp\20240328171935-teste.xlsx#xl/worksheets/sheet1.xml): Failed to open stream: No such file or directory in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Security\XmlScanner.php on line 152, referer: http://localhost/
[Thu Mar 28 13:19:38.542541 2024] [php:error] [pid 3156:tid 1900] [client ::1:59511] PHP Fatal error: Uncaught ValueError: XMLReader::XML(): Argument #1 ($source) cannot be empty in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php:206\nStack trace:\n#0 C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php(206): XMLReader->XML('', NULL, 12)\n#1 C:\xampp\htdocs\dolibarr\core\modules\import\import_xlsx.modules.php(310): PhpOffice\PhpSpreadsheet\Reader\Xlsx->listWorksheetInfo('C:/xampp/htdocs...')\n#2 C:\xampp\htdocs\dolibarr\imports\import.php(836): ImportXlsx->import_read_record()\n#3 {main}\n thrown in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php on line 206, referer: http://localhost/

[JonBendtsen]

[Thu Mar 28 13:19:38.538505 2024] [php:warn] [pid 3156:tid 1900] [client ::1:59511] PHP Warning: file_get_contents(): Unable to find the wrapper "zip" - did you forget to enable it when you configured PHP? in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Security\XmlScanner.php on line 152, referer: http://localhost/

Are php-zip package installed?

[Thu Mar 28 13:19:38.541540 2024] [php:warn] [pid 3156:tid 1900] [client ::1:59511] PHP Warning: file_get_contents(zip://C:\xampp\htdocs\dolibarr\documents\import\temp\20240328171935-teste.xlsx#xl/worksheets/sheet1.xml): Failed to open stream: No such file or directory in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Security\XmlScanner.php on line 152, referer: http://localhost/

Maybe it can not find that file because it doesn't have the zip thing?

[Thu Mar 28 13:19:38.542541 2024] [php:error] [pid 3156:tid 1900] [client ::1:59511] PHP Fatal error: Uncaught ValueError: XMLReader::XML(): Argument #1 ($source) cannot be empty in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php:206\nStack trace:\n#0 C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php(206): XMLReader->XML('', NULL, 12)\n#1 C:\xampp\htdocs\dolibarr\core\modules\import\import_xlsx.modules.php(310): PhpOffice\PhpSpreadsheet\Reader\Xlsx->listWorksheetInfo('C:/xampp/htdocs...')\n#2 C:\xampp\htdocs\dolibarr\imports\import.php(836): ImportXlsx->import_read_record()\n#3 {main}\n thrown in C:\xampp\htdocs\dolibarr\includes\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Reader\Xlsx.php on line 206, referer: http://localhost/

[alihusseinc]

This is my php.ini

[JonBendtsen]

This is my php.ini

Yes, but is it also actually installed in your OS?

[alihusseinc]

I think that if as I would in this case??

[frederic34]

fixed here #29011