Forum GLPI-Project

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

[solved ]Update 9.4.5 to 9.5.0

Hello everyone, everything good?

After upgrading from version 9.4.5 to 9.5.0. The warning below is displayed.

- 433 columns are not compatible with the use of time zones.

I'm not managing to solve it.

Thankful.

---

Márcio Machado
Brasília-DF / Brasil

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: [solved ]Update 9.4.5 to 9.5.0

Good Morning,
I started to have this warning after correcting Timezone in MariaDB.

https://github.com/glpi-project/glpi/issues/7498

https://glpi-install.readthedocs.io/en/ … zones.html

Thank you.

Last edited by machadomall (2020-07-08 14:30:05)

---

Márcio Machado
Brasília-DF / Brasil

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: [solved ]Update 9.4.5 to 9.5.0

@LaDenrée,
Is this warning a system error or in my database?

Thankful.

---

Márcio Machado
Brasília-DF / Brasil

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 326

Re: [solved ]Update 9.4.5 to 9.5.0

cara, seguinte

no glpi 9.5, precisa dar permissões ao usuário do banco glpi, na tabela mysql do próprio serviço mysql.

execute o comando mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql     (no servidor glpi) --> isso se o glpi e o mysql/mariadb estiverem no mesmo servidor

após isso vc deu acesso ao mysql para ler as permissões de fusos, mas ainda precisa executar GRANT SELECT ON `mysql`.`time_zone_name` TO 'glpi'@'localhost';
FLUSH PRIVILEGES;      (executando de usuario root no termnal mysql)

Supondo que seu usuário seja glpi@localhost, vc deve executar o comando acima

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 326

Re: [solved ]Update 9.4.5 to 9.5.0

Veja se nas configurações do usuário glpi, é possível selecionar um fuso horário, conforme a imagem

https://ibb.co/gdHp6Z7

Last edited by mecmav (2020-07-08 18:46:54)

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: [solved ]Update 9.4.5 to 9.5.0

Hello,
I had already carried out this whole process successfully.
It is only giving a warning on the home page as:

  -433 columns are not compatible with the use of time zones.

Thankful.

---

Márcio Machado
Brasília-DF / Brasil

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,167

Re: [solved ]Update 9.4.5 to 9.5.0

did you run this console command ?

php bin/console glpi:migration:timestamps

---

Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

machadomall

Member

From: Brazil, Brasilia, DF

Registered: 2011-10-30

Posts: 208

Re: [solved ]Update 9.4.5 to 9.5.0

[Solved]

Hello good afternoon,

Thank you very much @LaDenrée

Worked perfectly

[root@glpicentos82 glpi]# php bin/console glpi:migration:timestamps
Found 191 table(s) requiring migration.
Deseja continuar? [Yes/no]Yes
191/191 [============================] 100%
Migração concluída.

It was lack of attention on my part, at the time of the update, I had a warning that the command was necessary, but I passed by.

Last edited by machadomall (2020-07-09 22:24:35)

---

Márcio Machado
Brasília-DF / Brasil