Forum GLPI-Project

Moody_Blue

Member

Registered: 2016-06-09

Posts: 22

[Solved] Trying to update from 10.0.10 to 10.0.11

I am receiving the following error when trying to update

Error during the database query: UPDATE `glpi_lockedfields` SET `value` =
   NULL WHERE `is_global` = '1' - Error is Unknown column 'is_global' in 'whe
  re clause'

Apache/2.4.58
PHP 8.1.27
MariaDB 10.5.8

Edit: created a new text field is_global in table glpi_lockedfields. That solved the issue.

Last edited by Moody_Blue (2024-01-15 14:49:54)

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,811

Website

Re: [Solved] Trying to update from 10.0.10 to 10.0.11

That column is not supposed to be a text field.
The schema for that column is:
`is_global` tinyint NOT NULL DEFAULT '0'

You should fix the datatype/schema of that column to avoid future issues.

Also, your database probably has other issues. Please run the following command from the root of your GLPI installation as the user used by your web server (www-data for example):
bin/console database:check_schema_integrity

This will compare your current GLPI database with the known-correct schema for your version and show you the differences.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

Moody_Blue

Member

Registered: 2016-06-09

Posts: 22

Re: [Solved] Trying to update from 10.0.10 to 10.0.11

Done. Thanks.