Database migration error when upgrading from 1.21.15 to 1.21.19

[Stufo76]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

GLPI Version

10.0.17

Plugin version

1.21.15

Bug description

I'm encountering a database migration error when upgrading the Fields plugin from version 1.21.15 to 1.21.19 on my GLPI installation.

Relevant log output

glpi_plugin_fields_glpisocketassistenzas - Error during database query:
ALTER TABLE `glpi_plugin_fields_glpisocketassistenzas` 
ADD `is_recursive` TINYINT NOT NULL DEFAULT '0' AFTER `entities_id`,
ADD INDEX `is_recursive` (`is_recursive`)

Page URL

No response

Steps To reproduce

1. Installed version 1.21.15 of the plugin.
2. Attempted to upgrade to 1.21.19 via the GLPI web interface.
3. The upgrade fails with the above SQL error.

Your GLPI setup information

GLPI version: 10.0.17
PHP version: 8.2.26
Database version: mysql Ver 15.1 Distrib 10.11.6-MariaDB
OS: Debian 12.9

Anything else?

No response

[Stufo76]

desc glpi_plugin_fields_glpisocketassistenzas;
+-------------------------------------+------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------------+------------------+------+-----+------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| items_id | int(10) unsigned | NO | | NULL | |
| itemtype | varchar(255) | YES | MUL | GlpiSocket | |
| plugin_fields_containers_id | int(10) unsigned | NO | | 16 | |
| plugin_fields_tipofielddropdowns_id | int(10) unsigned | NO | | 0 | |
| numerofield | varchar(255) | YES | | NULL | |
| scadenzafield | varchar(255) | YES | | NULL | |
| notefield | text | YES | | NULL | |
+-------------------------------------+------------------+------+-----+------------+----------------+
8 rows in set (0.002 sec)

[stonebuzz]

Can you please try this ->glpi-project/glpi#18914 (glpi fix)

Best regards

[Stufo76]

Can you please try this ->glpi-project/glpi#18914 (glpi fix)

Best regards

I just tried and it crashes my GLPI, I must revert back!

[stonebuzz]

Oo

How did you apply the changes?

[Stufo76]

Oo

How did you apply the changes?

Sorry, my mistake, it works!