cedric-anne
commented
3 months ago Hi,
This issue is fixed by #17481. You should restore you backup, reinstall the GLPI 10.0.16 source files, apply the patch (ignore the test file) and run the migration.
Closed NoxWorld2660 closed 3 months ago
cedric-anne
commented
3 months ago Hi,
This issue is fixed by #17481. You should restore you backup, reinstall the GLPI 10.0.16 source files, apply the patch (ignore the test file) and run the migration.
NoxWorld2660
commented
3 months ago @cedric-anne , thank you for your quick reply, i'll do that.
Code of Conduct
Is there an existing issue for this?
Version
10.0.9
Bug description
System Situation :
I run GLPI with Apache 2.4 ; PHP 8.2.10 ; on a Windows Server 2019 ; Database is on the localhost with a MySQL 8
Bug :
When upgrading from GLPI 10.0.9 to GLPI 10.0.16 i have a crash when migating DB at the step where i go from 10.0.11 to 10.0.12 , see the image in attachment in the section with "BEFORE".
The error i have seems totally ridiculous. I tried to make a fresh install of GLPI 10.0.16 and i don't have a column "field" in the "glpi_tickettemplatehiddenfields" table. After digging into the code it seems the problem is coming from this file : "D:\www\glpi-fresh-10-0-16\install\migrations\update_10.0.11_to_10.0.12\duplicate_searchop_fixes.php" I don't understand where the table name and fields are coming, but that's probably the issue. Maybe it's related to MySQL 8 specifically ?
When upgrading through web browser, i have the exact same issue & error.
Workaround :
I renamed this file in ".crap" so it's ignored by the migration. After that it works, see Attachment with "AFTER". However i don't know if i will experience bug after since i don't exactly get what this migration step does ? If anyone can tell me what SQL i can eventually execute manually to make sure i don't have any bug regarding research ?
So after that, i successfully upgraded to v10.0.16 but i am not very confident since i skipped a step of the migration to v10.0.12.
Relevant log output
No response
Page URL
No response
Steps To reproduce
Your GLPI setup information
Informations sur le système, l'installation et la configuration
Server
Operating system: Windows NT STXXXXV 10.0 build 17763 (Windows Server 2019) AMD64 PHP 8.2.10 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, gd, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlsrv, random, readline, session, sodium, sqlsrv, standard, tokenizer, xml, xmlreader, xmlwriter, zip, zlib) Setup: max_execution_time="300" memory_limit="512M" post_max_size="40M" safe_mode="" session.save_handler="files" upload_max_filesize="20M" disable_functions="" Software: Apache/2.4.59 (Win64) PHP/8.2.10 OpenSSL/3.1.5 () Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115.0 Server Software: MySQL Community Server - GPL Server Version: 8.1.0 Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION Parameters: glpi_test@localhost/glpi_test_restored Host info: localhost via TCP/IP PHP version (8.2.10) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (8.1.0) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to D:\www\glpi-fresh-10-0-16/files/_cache has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_cron has been validated. Write access to D:\www\glpi-fresh-10-0-16/files has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_dumps has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_graphs has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_lock has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_pictures has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_plugins has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_rss has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_sessions has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_tmp has been validated. Write access to D:\www\glpi-fresh-10-0-16/files/_uploads has been validated. Web server root directory configuration seems safe. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to D:\www\glpi-fresh-10-0-16/marketplace has been validated. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
fields Name: Additional fields Version: 1.20.6 State: Installed / not activated Install Method: Manual datainjection Name: Data Injection Version: 2.13.2 State: Installed / not activated Install Method: Manual useditemsexport Name: Export des éléments utilisés Version: 2.5.1 State: Installed / not activated Install Method: Manual formcreator Name: Form Creator Version: 2.13.6 State: Not installed Install Method: Manual mreporting Name: Plus de rapports Version: 1.8.2 State: Installed / not activated Install Method: ManualAnything else?
No response