Erro when try update 2.2.0 to 3.2.0

[phamorais]

Hi

When trying to update the plugin to version 3.2.0 I get the error below

`Alteração de layout do banco de dados - glpi_plugin_actualtime_configs (0 segundo)

Installing glpi_plugin_actualtime_sourcetimers (0 segundo)

Alteração de layout do banco de dados - glpi_plugin_actualtime_tasks (0 segundo)

3.2.0 multiple alter in glpi_plugin_actualtime_tasks - Erro na consulta ao banco de dados: ALTER TABLE glpi_plugin_actualtime_tasks CHANGE origin_end origin_end INT NOT NULL DEFAULT '0' , ADD itemtype varchar(255) NOT NULL AFTER id - Erro é Invalid default value for 'override_begin'`

GLPI Version - 10.0.18 Previous ActualTime version: 2.2.0

[FrancisTicgal]

Hello,

I just tried updating the plugin from version 2.2.0 to 3.2.0 successfully. The error points to a column that is not modified in that statement, you can check in the database that the field has the following configuration?:

Column name: override_begin Data type: timestamp Default value: null

Same problem can happen with the column override_end.

[phamorais]

Hello,

I just tried updating the plugin from version 2.2.0 to 3.2.0 successfully. The error points to a column that is not modified in that statement, you can check in the database that the field has the following configuration?:

Column name: override_begin Data type: timestamp Default value: null

Same problem can happen with the column override_end.

hi!

[phamorais]

any?

[phamorais]

any?

[phamorais]

UP

[FrancisTicgal]

As indicated, the fields should be null by default, and here in the image we can see that they are marked as not null.

Checking previous versions, especially 2.2.0, we see that this configuration has always been this way.

If you manually change this setting in the database, you will be able to install the plugin and it will work correctly.