You are not logged in.
Pages: 1
Topic closed
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
Offline
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
Offline
@LaDenrée,
Is this warning a system error or in my database?
Thankful.
Márcio Machado
Brasília-DF / Brasil
Offline
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
Offline
Veja se nas configurações do usuário glpi, é possível selecionar um fuso horário, conforme a imagem
Last edited by mecmav (2020-07-08 18:46:54)
Offline
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
Offline
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
Offline
[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
Offline
Pages: 1
Topic closed