Forum GLPI-Project

ViktorG

Member

Registered: 2021-04-13

Posts: 19

Access Denied - The action you have requested is not allowed - v9.5.4.

Hello. Please Help!
After update GLPI on v9.5.4(Ubuntu 20.04.2 LTS, mysql 8, non plugins) authentification with standart login "glpi" - access denied - The action you have requested is not allowed.
---
sudo php bin/console glpi:system:check_requirements - all OK
---
user@glpi:~/glpi$ sudo php bin/console db:check
Unable to connect to database.
---
user@glpi:~/glpi$ sudo mysql -u glpi -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 52
Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| glpi               |
| information_schema |
| mysql              |
+--------------------+
3 rows in set (0.00 sec)

---
password in config_db.php right

oj69

Member

From: Somewhere in the cloud

Registered: 2021-02-01

Posts: 157

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

Have a look to the output for sudo php bin/console db:check. Something did wrong ...

ViktorG

Member

Registered: 2021-04-13

Posts: 19

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

sudo php bin/console db:check

primary key (`id`)
Table schema differs for table "glpi_rulerightparameters".
--- Original
+++ New
@@ @@
 create table `glpi_rulerightparameters` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `value` varchar(255) default null
   `comment` text not null
Table schema differs for table "glpi_rules".
--- Original
+++ New
@@ @@
 create table `glpi_rules` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `sub_type` varchar(255) not null default ''
-  `ranking` int(11) not null default '0'
+  `ranking` int not null default '0'
   `name` varchar(255) default null
   `description` text
   `match` char(10) default null
@@ @@
   `date_mod` timestamp null default null
   `is_recursive` tinyint(1) not null default '0'
   `uuid` varchar(255) default null
-  `condition` int(11) not null default '0'
+  `condition` int not null default '0'
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_slalevelactions".
--- Original
+++ New
@@ @@
 create table `glpi_slalevelactions` (
-  `id` int(11) not null auto_increment
-  `slalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `slalevels_id` int not null default '0'
   `action_type` varchar(255) default null
   `field` varchar(255) default null
   `value` varchar(255) default null
Table schema differs for table "glpi_slalevelcriterias".
--- Original
+++ New
@@ @@
 create table `glpi_slalevelcriterias` (
-  `id` int(11) not null auto_increment
-  `slalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `slalevels_id` int not null default '0'
   `criteria` varchar(255) default null
-  `condition` int(11) not null default '0'
+  `condition` int not null default '0'
   `pattern` varchar(255) default null
   primary key (`id`)
Table schema differs for table "glpi_slalevels".
--- Original
+++ New
@@ @@
 create table `glpi_slalevels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `slas_id` int(11) not null default '0'
-  `execution_time` int(11) not null
+  `slas_id` int not null default '0'
+  `execution_time` int not null
   `is_active` tinyint(1) not null default '1'
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `match` char(10) default null
   `uuid` varchar(255) default null
Table schema differs for table "glpi_slalevels_tickets".
--- Original
+++ New
@@ @@
 create table `glpi_slalevels_tickets` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
-  `slalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
+  `slalevels_id` int not null default '0'
   `date` timestamp null default null
   primary key (`id`)
   unique key `unicity` (`tickets_id`,`slalevels_id`)
Table schema differs for table "glpi_olalevelactions".
--- Original
+++ New
@@ @@
 create table `glpi_olalevelactions` (
-  `id` int(11) not null auto_increment
-  `olalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `olalevels_id` int not null default '0'
   `action_type` varchar(255) default null
   `field` varchar(255) default null
   `value` varchar(255) default null
Table schema differs for table "glpi_olalevelcriterias".
--- Original
+++ New
@@ @@
 create table `glpi_olalevelcriterias` (
-  `id` int(11) not null auto_increment
-  `olalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `olalevels_id` int not null default '0'
   `criteria` varchar(255) default null
-  `condition` int(11) not null default '0'
+  `condition` int not null default '0'
   `pattern` varchar(255) default null
   primary key (`id`)
Table schema differs for table "glpi_olalevels".
--- Original
+++ New
@@ @@
 create table `glpi_olalevels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `olas_id` int(11) not null default '0'
-  `execution_time` int(11) not null
+  `olas_id` int not null default '0'
+  `execution_time` int not null
   `is_active` tinyint(1) not null default '1'
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `match` char(10) default null
   `uuid` varchar(255) default null
Table schema differs for table "glpi_olalevels_tickets".
--- Original
+++ New
@@ @@
 create table `glpi_olalevels_tickets` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
-  `olalevels_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
+  `olalevels_id` int not null default '0'
   `date` timestamp null default null
   primary key (`id`)
   unique key `unicity` (`tickets_id`,`olalevels_id`)
Table schema differs for table "glpi_slms".
--- Original
+++ New
@@ @@
 create table `glpi_slms` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
-  `calendars_id` int(11) not null default '0'
+  `calendars_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_slas".
--- Original
+++ New
@@ @@
 create table `glpi_slas` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `type` int(11) not null default '0'
+  `type` int not null default '0'
   `comment` text
-  `number_time` int(11) not null
-  `calendars_id` int(11) not null default '0'
+  `number_time` int not null
+  `calendars_id` int not null default '0'
   `date_mod` timestamp null default null
   `definition_time` varchar(255) default null
   `end_of_working_day` tinyint(1) not null default '0'
   `date_creation` timestamp null default null
-  `slms_id` int(11) not null default '0'
+  `slms_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_olas".
--- Original
+++ New
@@ @@
 create table `glpi_olas` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `type` int(11) not null default '0'
+  `type` int not null default '0'
   `comment` text
-  `number_time` int(11) not null
-  `calendars_id` int(11) not null default '0'
+  `number_time` int not null
+  `calendars_id` int not null default '0'
   `date_mod` timestamp null default null
   `definition_time` varchar(255) default null
   `end_of_working_day` tinyint(1) not null default '0'
   `date_creation` timestamp null default null
-  `slms_id` int(11) not null default '0'
+  `slms_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_softwarecategories".
--- Original
+++ New
@@ @@
 create table `glpi_softwarecategories` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `softwarecategories_id` int(11) not null default '0'
+  `softwarecategories_id` int not null default '0'
   `completename` text
-  `level` int(11) not null default '0'
+  `level` int not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
   primary key (`id`)
Table schema differs for table "glpi_softwarelicenses".
--- Original
+++ New
@@ @@
 create table `glpi_softwarelicenses` (
-  `id` int(11) not null auto_increment
-  `softwares_id` int(11) not null default '0'
-  `softwarelicenses_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `softwares_id` int not null default '0'
+  `softwarelicenses_id` int not null default '0'
   `completename` text
-  `level` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `level` int not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `number` int(11) not null default '0'
-  `softwarelicensetypes_id` int(11) not null default '0'
+  `number` int not null default '0'
+  `softwarelicensetypes_id` int not null default '0'
   `name` varchar(255) default null
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `softwareversions_id_buy` int(11) not null default '0'
-  `softwareversions_id_use` int(11) not null default '0'
+  `softwareversions_id_buy` int not null default '0'
+  `softwareversions_id_use` int not null default '0'
   `expire` date default null
   `comment` text
   `date_mod` timestamp null default null
@@ @@
   `is_valid` tinyint(1) not null default '1'
   `date_creation` timestamp null default null
   `is_deleted` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
-  `groups_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `users_id_tech` int not null default '0'
+  `users_id` int not null default '0'
+  `groups_id_tech` int not null default '0'
+  `groups_id` int not null default '0'
   `is_helpdesk_visible` tinyint(1) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
-  `states_id` int(11) not null default '0'
-  `manufacturers_id` int(11) not null default '0'
+  `states_id` int not null default '0'
+  `manufacturers_id` int not null default '0'
   `contact` varchar(255) default null
   `contact_num` varchar(255) default null
   `allow_overquota` tinyint(1) not null default '0'
Table schema differs for table "glpi_softwarelicensetypes".
--- Original
+++ New
@@ @@
 create table `glpi_softwarelicensetypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
-  `softwarelicensetypes_id` int(11) not null default '0'
-  `level` int(11) not null default '0'
+  `softwarelicensetypes_id` int not null default '0'
+  `level` int not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `completename` text
   primary key (`id`)
Table schema differs for table "glpi_softwares".
--- Original
+++ New
@@ @@
 create table `glpi_softwares` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `comment` text
-  `locations_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `is_update` tinyint(1) not null default '0'
-  `softwares_id` int(11) not null default '0'
-  `manufacturers_id` int(11) not null default '0'
+  `softwares_id` int not null default '0'
+  `manufacturers_id` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   `date_mod` timestamp null default null
-  `users_id` int(11) not null default '0'
-  `groups_id` int(11) not null default '0'
+  `users_id` int not null default '0'
+  `groups_id` int not null default '0'
   `ticket_tco` decimal(20,4) default '0.0000'
   `is_helpdesk_visible` tinyint(1) not null default '1'
-  `softwarecategories_id` int(11) not null default '0'
+  `softwarecategories_id` int not null default '0'
   `is_valid` tinyint(1) not null default '1'
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_softwareversions".
--- Original
+++ New
@@ @@
 create table `glpi_softwareversions` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `softwares_id` int(11) not null default '0'
-  `states_id` int(11) not null default '0'
+  `softwares_id` int not null default '0'
+  `states_id` int not null default '0'
   `name` varchar(255) default null
   `comment` text
-  `operatingsystems_id` int(11) not null default '0'
+  `operatingsystems_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_solutiontemplates".
--- Original
+++ New
@@ @@
 create table `glpi_solutiontemplates` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `content` text
-  `solutiontypes_id` int(11) not null default '0'
+  `solutiontypes_id` int not null default '0'
   `comment` text
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_solutiontypes".
--- Original
+++ New
@@ @@
 create table `glpi_solutiontypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '1'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_itilsolutions".
--- Original
+++ New
@@ @@
 create table `glpi_itilsolutions` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `itemtype` varchar(100) not null
-  `items_id` int(11) not null default '0'
-  `solutiontypes_id` int(11) not null default '0'
-  `solutiontype_name` varchar(255) null default null
+  `items_id` int not null default '0'
+  `solutiontypes_id` int not null default '0'
+  `solutiontype_name` varchar(255) default null
   `content` longtext
   `date_creation` timestamp null default null
   `date_mod` timestamp null default null
   `date_approval` timestamp null default null
-  `users_id` int(11) not null default '0'
-  `user_name` varchar(255) null default null
-  `users_id_editor` int(11) not null default '0'
-  `users_id_approval` int(11) not null default '0'
-  `user_name_approval` varchar(255) null default null
-  `status` int(11) not null default '1'
-  `itilfollowups_id` int(11) default null
+  `users_id` int not null default '0'
+  `user_name` varchar(255) default null
+  `users_id_editor` int not null default '0'
+  `users_id_approval` int not null default '0'
+  `user_name_approval` varchar(255) default null
+  `status` int not null default '1'
+  `itilfollowups_id` int default null
   primary key (`id`)
Table schema differs for table "glpi_ssovariables".
--- Original
+++ New
@@ @@
 create table `glpi_ssovariables` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text not null
   `date_mod` timestamp null default null
Table schema differs for table "glpi_states".
--- Original
+++ New
@@ @@
 create table `glpi_states` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
-  `states_id` int(11) not null default '0'
+  `states_id` int not null default '0'
   `completename` text
-  `level` int(11) not null default '0'
+  `level` int not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
   `is_visible_computer` tinyint(1) not null default '1'
Table schema differs for table "glpi_suppliers".
--- Original
+++ New
@@ @@
 create table `glpi_suppliers` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
-  `suppliertypes_id` int(11) not null default '0'
+  `suppliertypes_id` int not null default '0'
   `address` text
   `postcode` varchar(255) default null
   `town` varchar(255) default null
Table schema differs for table "glpi_suppliers_tickets".
--- Original
+++ New
@@ @@
 create table `glpi_suppliers_tickets` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
-  `suppliers_id` int(11) not null default '0'
-  `type` int(11) not null default '1'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
+  `suppliers_id` int not null default '0'
+  `type` int not null default '1'
   `use_notification` tinyint(1) not null default '1'
   `alternative_email` varchar(255) default null
   primary key (`id`)
Table schema differs for table "glpi_suppliertypes".
--- Original
+++ New
@@ @@
 create table `glpi_suppliertypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_taskcategories".
--- Original
+++ New
@@ @@
 create table `glpi_taskcategories` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `taskcategories_id` int(11) not null default '0'
+  `taskcategories_id` int not null default '0'
   `name` varchar(255) default null
   `completename` text
   `comment` text
-  `level` int(11) not null default '0'
+  `level` int not null default '0'
   `ancestors_cache` longtext
   `sons_cache` longtext
   `is_active` tinyint(1) not null default '1'
@@ @@
   `is_helpdeskvisible` tinyint(1) not null default '1'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
-  `knowbaseitemcategories_id` int(11) not null default '0'
+  `knowbaseitemcategories_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_tasktemplates".
--- Original
+++ New
@@ @@
 create table `glpi_tasktemplates` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `content` text
-  `taskcategories_id` int(11) not null default '0'
-  `actiontime` int(11) not null default '0'
+  `taskcategories_id` int not null default '0'
+  `actiontime` int not null default '0'
   `comment` text
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
-  `state` int(11) not null default '0'
+  `state` int not null default '0'
   `is_private` tinyint(1) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_ticketcosts".
--- Original
+++ New
@@ @@
 create table `glpi_ticketcosts` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
   `name` varchar(255) default null
   `comment` text
   `begin_date` date default null
   `end_date` date default null
-  `actiontime` int(11) not null default '0'
+  `actiontime` int not null default '0'
   `cost_time` decimal(20,4) not null default '0.0000'
   `cost_fixed` decimal(20,4) not null default '0.0000'
   `cost_material` decimal(20,4) not null default '0.0000'
-  `budgets_id` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `budgets_id` int not null default '0'
+  `entities_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_ticketrecurrents".
--- Original
+++ New
@@ @@
 create table `glpi_ticketrecurrents` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `is_active` tinyint(1) not null default '0'
-  `tickettemplates_id` int(11) not null default '0'
+  `tickettemplates_id` int not null default '0'
   `begin_date` timestamp null default null
   `periodicity` varchar(255) default null
-  `create_before` int(11) not null default '0'
+  `create_before` int not null default '0'
   `next_creation_date` timestamp null default null
-  `calendars_id` int(11) not null default '0'
+  `calendars_id` int not null default '0'
   `end_date` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_tickets".
--- Original
+++ New
@@ @@
 create table `glpi_tickets` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `name` varchar(255) default null
   `date` timestamp null default null
   `closedate` timestamp null default null
   `solvedate` timestamp null default null
   `date_mod` timestamp null default null
-  `users_id_lastupdater` int(11) not null default '0'
-  `status` int(11) not null default '1'
-  `users_id_recipient` int(11) not null default '0'
-  `requesttypes_id` int(11) not null default '0'
+  `users_id_lastupdater` int not null default '0'
+  `status` int not null default '1'
+  `users_id_recipient` int not null default '0'
+  `requesttypes_id` int not null default '0'
   `content` longtext
-  `urgency` int(11) not null default '1'
-  `impact` int(11) not null default '1'
-  `priority` int(11) not null default '1'
-  `itilcategories_id` int(11) not null default '0'
-  `type` int(11) not null default '1'
-  `global_validation` int(11) not null default '1'
-  `slas_id_ttr` int(11) not null default '0'
-  `slas_id_tto` int(11) not null default '0'
-  `slalevels_id_ttr` int(11) not null default '0'
+  `urgency` int not null default '1'
+  `impact` int not null default '1'
+  `priority` int not null default '1'
+  `itilcategories_id` int not null default '0'
+  `type` int not null default '1'
+  `global_validation` int not null default '1'
+  `slas_id_ttr` int not null default '0'
+  `slas_id_tto` int not null default '0'
+  `slalevels_id_ttr` int not null default '0'
   `time_to_resolve` timestamp null default null
   `time_to_own` timestamp null default null
   `begin_waiting_date` timestamp null default null
-  `sla_waiting_duration` int(11) not null default '0'
-  `ola_waiting_duration` int(11) not null default '0'
-  `olas_id_tto` int(11) not null default '0'
-  `olas_id_ttr` int(11) not null default '0'
-  `olalevels_id_ttr` int(11) not null default '0'
+  `sla_waiting_duration` int not null default '0'
+  `ola_waiting_duration` int not null default '0'
+  `olas_id_tto` int not null default '0'
+  `olas_id_ttr` int not null default '0'
+  `olalevels_id_ttr` int not null default '0'
   `ola_ttr_begin_date` timestamp null default null
   `internal_time_to_resolve` timestamp null default null
   `internal_time_to_own` timestamp null default null
-  `waiting_duration` int(11) not null default '0'
-  `close_delay_stat` int(11) not null default '0'
-  `solve_delay_stat` int(11) not null default '0'
-  `takeintoaccount_delay_stat` int(11) not null default '0'
-  `actiontime` int(11) not null default '0'
+  `waiting_duration` int not null default '0'
+  `close_delay_stat` int not null default '0'
+  `solve_delay_stat` int not null default '0'
+  `takeintoaccount_delay_stat` int not null default '0'
+  `actiontime` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
-  `validation_percent` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `validation_percent` int not null default '0'
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_tickets_tickets".
--- Original
+++ New
@@ @@
 create table `glpi_tickets_tickets` (
-  `id` int(11) not null auto_increment
-  `tickets_id_1` int(11) not null default '0'
-  `tickets_id_2` int(11) not null default '0'
-  `link` int(11) not null default '1'
+  `id` int not null auto_increment
+  `tickets_id_1` int not null default '0'
+  `tickets_id_2` int not null default '0'
+  `link` int not null default '1'
   primary key (`id`)
   unique key `unicity` (`tickets_id_1`,`tickets_id_2`)
Table schema differs for table "glpi_tickets_users".
--- Original
+++ New
@@ @@
 create table `glpi_tickets_users` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `type` int(11) not null default '1'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
+  `users_id` int not null default '0'
+  `type` int not null default '1'
   `use_notification` tinyint(1) not null default '1'
   `alternative_email` varchar(255) default null
   primary key (`id`)
Table schema differs for table "glpi_ticketsatisfactions".
--- Original
+++ New
@@ @@
 create table `glpi_ticketsatisfactions` (
-  `id` int(11) not null auto_increment
-  `tickets_id` int(11) not null default '0'
-  `type` int(11) not null default '1'
+  `id` int not null auto_increment
+  `tickets_id` int not null default '0'
+  `type` int not null default '1'
   `date_begin` timestamp null default null
   `date_answered` timestamp null default null
-  `satisfaction` int(11) default null
+  `satisfaction` int default null
   `comment` text
   primary key (`id`)
   unique key `tickets_id` (`tickets_id`)
Table schema differs for table "glpi_tickettasks".
--- Original
+++ New
@@ @@
 create table `glpi_tickettasks` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `uuid` varchar(255) default null
-  `tickets_id` int(11) not null default '0'
-  `taskcategories_id` int(11) not null default '0'
+  `tickets_id` int not null default '0'
+  `taskcategories_id` int not null default '0'
   `date` timestamp null default null
-  `users_id` int(11) not null default '0'
-  `users_id_editor` int(11) not null default '0'
+  `users_id` int not null default '0'
+  `users_id_editor` int not null default '0'
   `content` longtext
   `is_private` tinyint(1) not null default '0'
-  `actiontime` int(11) not null default '0'
+  `actiontime` int not null default '0'
   `begin` timestamp null default null
   `end` timestamp null default null
-  `state` int(11) not null default '1'
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `state` int not null default '1'
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
-  `tasktemplates_id` int(11) not null default '0'
+  `tasktemplates_id` int not null default '0'
   `timeline_position` tinyint(1) not null default '0'
-  `sourceitems_id` int(11) not null default '0'
+  `sourceitems_id` int not null default '0'
   primary key (`id`)
   unique key `uuid` (`uuid`)
Table schema differs for table "glpi_tickettemplatehiddenfields".
--- Original
+++ New
@@ @@
 create table `glpi_tickettemplatehiddenfields` (
-  `id` int(11) not null auto_increment
-  `tickettemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickettemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`tickettemplates_id`,`num`)
Table schema differs for table "glpi_changetemplatehiddenfields".
--- Original
+++ New
@@ @@
 create table `glpi_changetemplatehiddenfields` (
-  `id` int(11) not null auto_increment
-  `changetemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `changetemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`changetemplates_id`,`num`)
Table schema differs for table "glpi_problemtemplatehiddenfields".
--- Original
+++ New
@@ @@
 create table `glpi_problemtemplatehiddenfields` (
-  `id` int(11) not null auto_increment
-  `problemtemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `problemtemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`problemtemplates_id`,`num`)
Table schema differs for table "glpi_tickettemplatemandatoryfields".
--- Original
+++ New
@@ @@
 create table `glpi_tickettemplatemandatoryfields` (
-  `id` int(11) not null auto_increment
-  `tickettemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickettemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`tickettemplates_id`,`num`)
Table schema differs for table "glpi_changetemplatemandatoryfields".
--- Original
+++ New
@@ @@
 create table `glpi_changetemplatemandatoryfields` (
-  `id` int(11) not null auto_increment
-  `changetemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `changetemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`changetemplates_id`,`num`)
Table schema differs for table "glpi_problemtemplatemandatoryfields".
--- Original
+++ New
@@ @@
 create table `glpi_problemtemplatemandatoryfields` (
-  `id` int(11) not null auto_increment
-  `problemtemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `problemtemplates_id` int not null default '0'
+  `num` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`problemtemplates_id`,`num`)
Table schema differs for table "glpi_tickettemplatepredefinedfields".
--- Original
+++ New
@@ @@
 create table `glpi_tickettemplatepredefinedfields` (
-  `id` int(11) not null auto_increment
-  `tickettemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `tickettemplates_id` int not null default '0'
+  `num` int not null default '0'
   `value` text
   primary key (`id`)
Table schema differs for table "glpi_changetemplatepredefinedfields".
--- Original
+++ New
@@ @@
 create table `glpi_changetemplatepredefinedfields` (
-  `id` int(11) not null auto_increment
-  `changetemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `changetemplates_id` int not null default '0'
+  `num` int not null default '0'
   `value` text
   primary key (`id`)
Table schema differs for table "glpi_problemtemplatepredefinedfields".
--- Original
+++ New
@@ @@
 create table `glpi_problemtemplatepredefinedfields` (
-  `id` int(11) not null auto_increment
-  `problemtemplates_id` int(11) not null default '0'
-  `num` int(11) not null default '0'
+  `id` int not null auto_increment
+  `problemtemplates_id` int not null default '0'
+  `num` int not null default '0'
   `value` text
   primary key (`id`)
Table schema differs for table "glpi_tickettemplates".
--- Original
+++ New
@@ @@
 create table `glpi_tickettemplates` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_changetemplates".
--- Original
+++ New
@@ @@
 create table `glpi_changetemplates` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_problemtemplates".
--- Original
+++ New
@@ @@
 create table `glpi_problemtemplates` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_ticketvalidations".
--- Original
+++ New
@@ @@
 create table `glpi_ticketvalidations` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `tickets_id` int(11) not null default '0'
-  `users_id_validate` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
+  `users_id` int not null default '0'
+  `tickets_id` int not null default '0'
+  `users_id_validate` int not null default '0'
   `comment_submission` text
   `comment_validation` text
-  `status` int(11) not null default '2'
+  `status` int not null default '2'
   `submission_date` timestamp null default null
   `validation_date` timestamp null default null
   `timeline_position` tinyint(1) not null default '0'
Table schema differs for table "glpi_transfers".
--- Original
+++ New
@@ @@
 create table `glpi_transfers` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `keep_ticket` int(11) not null default '0'
-  `keep_networklink` int(11) not null default '0'
-  `keep_reservation` int(11) not null default '0'
-  `keep_history` int(11) not null default '0'
-  `keep_device` int(11) not null default '0'
-  `keep_infocom` int(11) not null default '0'
-  `keep_dc_monitor` int(11) not null default '0'
-  `clean_dc_monitor` int(11) not null default '0'
-  `keep_dc_phone` int(11) not null default '0'
-  `clean_dc_phone` int(11) not null default '0'
-  `keep_dc_peripheral` int(11) not null default '0'
-  `clean_dc_peripheral` int(11) not null default '0'
-  `keep_dc_printer` int(11) not null default '0'
-  `clean_dc_printer` int(11) not null default '0'
-  `keep_supplier` int(11) not null default '0'
-  `clean_supplier` int(11) not null default '0'
-  `keep_contact` int(11) not null default '0'
-  `clean_contact` int(11) not null default '0'
-  `keep_contract` int(11) not null default '0'
-  `clean_contract` int(11) not null default '0'
-  `keep_software` int(11) not null default '0'
-  `clean_software` int(11) not null default '0'
-  `keep_document` int(11) not null default '0'
-  `clean_document` int(11) not null default '0'
-  `keep_cartridgeitem` int(11) not null default '0'
-  `clean_cartridgeitem` int(11) not null default '0'
-  `keep_cartridge` int(11) not null default '0'
-  `keep_consumable` int(11) not null default '0'
+  `keep_ticket` int not null default '0'
+  `keep_networklink` int not null default '0'
+  `keep_reservation` int not null default '0'
+  `keep_history` int not null default '0'
+  `keep_device` int not null default '0'
+  `keep_infocom` int not null default '0'
+  `keep_dc_monitor` int not null default '0'
+  `clean_dc_monitor` int not null default '0'
+  `keep_dc_phone` int not null default '0'
+  `clean_dc_phone` int not null default '0'
+  `keep_dc_peripheral` int not null default '0'
+  `clean_dc_peripheral` int not null default '0'
+  `keep_dc_printer` int not null default '0'
+  `clean_dc_printer` int not null default '0'
+  `keep_supplier` int not null default '0'
+  `clean_supplier` int not null default '0'
+  `keep_contact` int not null default '0'
+  `clean_contact` int not null default '0'
+  `keep_contract` int not null default '0'
+  `clean_contract` int not null default '0'
+  `keep_software` int not null default '0'
+  `clean_software` int not null default '0'
+  `keep_document` int not null default '0'
+  `clean_document` int not null default '0'
+  `keep_cartridgeitem` int not null default '0'
+  `clean_cartridgeitem` int not null default '0'
+  `keep_cartridge` int not null default '0'
+  `keep_consumable` int not null default '0'
   `date_mod` timestamp null default null
   `comment` text
-  `keep_disk` int(11) not null default '0'
+  `keep_disk` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_usercategories".
--- Original
+++ New
@@ @@
 create table `glpi_usercategories` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_useremails".
--- Original
+++ New
@@ @@
 create table `glpi_useremails` (
-  `id` int(11) not null auto_increment
-  `users_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `users_id` int not null default '0'
   `is_default` tinyint(1) not null default '0'
   `is_dynamic` tinyint(1) not null default '0'
   `email` varchar(255) default null
Table schema differs for table "glpi_users".
--- Original
+++ New
@@ @@
 create table `glpi_users` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `password` varchar(255) default null
   `password_last_update` timestamp null default null
@@ @@
   `mobile` varchar(255) default null
   `realname` varchar(255) default null
   `firstname` varchar(255) default null
-  `locations_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
   `language` char(10) default null
-  `use_mode` int(11) not null default '0'
-  `list_limit` int(11) default null
+  `use_mode` int not null default '0'
+  `list_limit` int default null
   `is_active` tinyint(1) not null default '1'
   `comment` text
-  `auths_id` int(11) not null default '0'
-  `authtype` int(11) not null default '0'
+  `auths_id` int not null default '0'
+  `authtype` int not null default '0'
   `last_login` timestamp null default null
   `date_mod` timestamp null default null
   `date_sync` timestamp null default null
   `is_deleted` tinyint(1) not null default '0'
-  `profiles_id` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
-  `usertitles_id` int(11) not null default '0'
-  `usercategories_id` int(11) not null default '0'
-  `date_format` int(11) default null
-  `number_format` int(11) default null
-  `names_format` int(11) default null
+  `profiles_id` int not null default '0'
+  `entities_id` int not null default '0'
+  `usertitles_id` int not null default '0'
+  `usercategories_id` int not null default '0'
+  `date_format` int default null
+  `number_format` int default null
+  `names_format` int default null
   `csv_delimiter` char(1) default null
   `is_ids_visible` tinyint(1) default null
   `use_flat_dropdowntree` tinyint(1) default null
@@ @@
   `priority_6` char(20) default null
   `followup_private` tinyint(1) default null
   `task_private` tinyint(1) default null
-  `default_requesttypes_id` int(11) default null
+  `default_requesttypes_id` int default null
   `password_forget_token` char(40) default null
   `password_forget_token_date` timestamp null default null
   `user_dn` text
   `registration_number` varchar(255) default null
   `show_count_on_tabs` tinyint(1) default null
-  `refresh_views` int(11) default null
+  `refresh_views` int default null
   `set_default_tech` tinyint(1) default null
   `personal_token` varchar(255) default null
   `personal_token_date` timestamp null default null
@@ @@
   `api_token_date` timestamp null default null
   `cookie_token` varchar(255) default null
   `cookie_token_date` timestamp null default null
-  `display_count_on_home` int(11) default null
+  `display_count_on_home` int default null
   `notification_to_myself` tinyint(1) default null
   `duedateok_color` varchar(255) default null
   `duedatewarning_color` varchar(255) default null
   `duedatecritical_color` varchar(255) default null
-  `duedatewarning_less` int(11) default null
-  `duedatecritical_less` int(11) default null
+  `duedatewarning_less` int default null
+  `duedatecritical_less` int default null
   `duedatewarning_unit` varchar(255) default null
   `duedatecritical_unit` varchar(255) default null
   `display_options` text
@@ @@
   `keep_devices_when_purging_item` tinyint(1) default null
   `privatebookmarkorder` longtext
   `backcreated` tinyint(1) default null
-  `task_state` int(11) default null
+  `task_state` int default null
   `layout` char(20) default null
   `palette` char(20) default null
   `set_default_requester` tinyint(1) default null
@@ @@
   `highcontrast_css` tinyint(1) default '0'
   `plannings` text
   `sync_field` varchar(255) default null
-  `groups_id` int(11) not null default '0'
-  `users_id_supervisor` int(11) not null default '0'
+  `groups_id` int not null default '0'
+  `users_id_supervisor` int not null default '0'
   `timezone` varchar(50) default null
   `default_dashboard_central` varchar(100) default null
   `default_dashboard_assets` varchar(100) default null
Table schema differs for table "glpi_usertitles".
--- Original
+++ New
@@ @@
 create table `glpi_usertitles` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_virtualmachinestates".
--- Original
+++ New
@@ @@
 create table `glpi_virtualmachinestates` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
   `date_mod` timestamp null default null
Table schema differs for table "glpi_virtualmachinesystems".
--- Original
+++ New
@@ @@
 create table `glpi_virtualmachinesystems` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
   `date_mod` timestamp null default null
Table schema differs for table "glpi_virtualmachinetypes".
--- Original
+++ New
@@ @@
 create table `glpi_virtualmachinetypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) not null default ''
   `comment` text not null
   `date_mod` timestamp null default null
Table schema differs for table "glpi_vlans".
--- Original
+++ New
@@ @@
 create table `glpi_vlans` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `comment` text
-  `tag` int(11) not null default '0'
+  `tag` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_wifinetworks".
--- Original
+++ New
@@ @@
 create table `glpi_wifinetworks` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `essid` varchar(255) default null
Table schema differs for table "glpi_knowbaseitems_items".
--- Original
+++ New
@@ @@
 create table `glpi_knowbaseitems_items` (
-  `id` int(11) not null auto_increment
-  `knowbaseitems_id` int(11) not null
+  `id` int not null auto_increment
+  `knowbaseitems_id` int not null
   `itemtype` varchar(100) not null
-  `items_id` int(11) not null default '0'
+  `items_id` int not null default '0'
   `date_creation` timestamp null default null
   `date_mod` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_knowbaseitems_revisions".
--- Original
+++ New
@@ @@
 create table `glpi_knowbaseitems_revisions` (
-  `id` int(11) not null auto_increment
-  `knowbaseitems_id` int(11) not null
-  `revision` int(11) not null
+  `id` int not null auto_increment
+  `knowbaseitems_id` int not null
+  `revision` int not null
   `name` text
   `answer` longtext
   `language` varchar(10) default null
-  `users_id` int(11) not null default '0'
+  `users_id` int not null default '0'
   `date_creation` timestamp null default null
   primary key (`id`)
   unique key `unicity` (`knowbaseitems_id`,`revision`,`language`)
Table schema differs for table "glpi_knowbaseitems_comments".
--- Original
+++ New
@@ @@
 create table `glpi_knowbaseitems_comments` (
-  `id` int(11) not null auto_increment
-  `knowbaseitems_id` int(11) not null
-  `users_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `knowbaseitems_id` int not null
+  `users_id` int not null default '0'
   `language` varchar(10) default null
   `comment` text not null
-  `parent_comment_id` int(11) default null
+  `parent_comment_id` int default null
   `date_creation` timestamp null default null
   `date_mod` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_devicebatterymodels".
--- Original
+++ New
@@ @@
 create table `glpi_devicebatterymodels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
Table schema differs for table "glpi_devicebatteries".
--- Original
+++ New
@@ @@
 create table `glpi_devicebatteries` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `designation` varchar(255) default null
   `comment` text
-  `manufacturers_id` int(11) not null default '0'
-  `voltage` int(11) default null
-  `capacity` int(11) default null
-  `devicebatterytypes_id` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `manufacturers_id` int not null default '0'
+  `voltage` int default null
+  `capacity` int default null
+  `devicebatterytypes_id` int not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `devicebatterymodels_id` int(11) default null
+  `devicebatterymodels_id` int default null
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_items_devicebatteries".
--- Original
+++ New
@@ @@
 create table `glpi_items_devicebatteries` (
-  `id` int(11) not null auto_increment
-  `items_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `items_id` int not null default '0'
   `itemtype` varchar(255) default null
-  `devicebatteries_id` int(11) not null default '0'
+  `devicebatteries_id` int not null default '0'
   `manufacturing_date` date default null
   `is_deleted` tinyint(1) not null default '0'
   `is_dynamic` tinyint(1) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `locations_id` int(11) not null default '0'
-  `states_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `states_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_devicebatterytypes".
--- Original
+++ New
@@ @@
 create table `glpi_devicebatterytypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_devicefirmwaremodels".
--- Original
+++ New
@@ @@
 create table `glpi_devicefirmwaremodels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
Table schema differs for table "glpi_devicefirmwares".
--- Original
+++ New
@@ @@
 create table `glpi_devicefirmwares` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `designation` varchar(255) default null
   `comment` text
-  `manufacturers_id` int(11) not null default '0'
+  `manufacturers_id` int not null default '0'
   `date` date default null
   `version` varchar(255) default null
-  `devicefirmwaretypes_id` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `devicefirmwaretypes_id` int not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `devicefirmwaremodels_id` int(11) default null
+  `devicefirmwaremodels_id` int default null
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_items_devicefirmwares".
--- Original
+++ New
@@ @@
 create table `glpi_items_devicefirmwares` (
-  `id` int(11) not null auto_increment
-  `items_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `items_id` int not null default '0'
   `itemtype` varchar(255) default null
-  `devicefirmwares_id` int(11) not null default '0'
+  `devicefirmwares_id` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
   `is_dynamic` tinyint(1) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `locations_id` int(11) not null default '0'
-  `states_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `states_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_devicefirmwaretypes".
--- Original
+++ New
@@ @@
 create table `glpi_devicefirmwaretypes` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_datacenters".
--- Original
+++ New
@@ @@
 create table `glpi_datacenters` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_dcrooms".
--- Original
+++ New
@@ @@
 create table `glpi_dcrooms` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
-  `vis_cols` int(11) default null
-  `vis_rows` int(11) default null
+  `locations_id` int not null default '0'
+  `vis_cols` int default null
+  `vis_rows` int default null
   `blueprint` text
-  `datacenters_id` int(11) not null default '0'
+  `datacenters_id` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_rackmodels".
--- Original
+++ New
@@ @@
 create table `glpi_rackmodels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
Table schema differs for table "glpi_racktypes".
--- Original
+++ New
@@ @@
 create table `glpi_racktypes` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `comment` text
Table schema differs for table "glpi_racks".
--- Original
+++ New
@@ @@
 create table `glpi_racks` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `rackmodels_id` int(11) default null
-  `manufacturers_id` int(11) not null default '0'
-  `racktypes_id` int(11) not null default '0'
-  `states_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
-  `width` int(11) default null
-  `height` int(11) default null
-  `depth` int(11) default null
-  `number_units` int(11) default '0'
+  `rackmodels_id` int default null
+  `manufacturers_id` int not null default '0'
+  `racktypes_id` int not null default '0'
+  `states_id` int not null default '0'
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
+  `width` int default null
+  `height` int default null
+  `depth` int default null
+  `number_units` int default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   `is_deleted` tinyint(1) not null default '0'
-  `dcrooms_id` int(11) not null default '0'
-  `room_orientation` int(11) not null default '0'
-  `position` varchar(50)
+  `dcrooms_id` int not null default '0'
+  `room_orientation` int not null default '0'
+  `position` varchar(50) default null
   `bgcolor` varchar(7) default null
-  `max_power` int(11) not null default '0'
-  `mesured_power` int(11) not null default '0'
-  `max_weight` int(11) not null default '0'
+  `max_power` int not null default '0'
+  `mesured_power` int not null default '0'
+  `max_weight` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_items_racks".
--- Original
+++ New
@@ @@
 create table `glpi_items_racks` (
-  `id` int(11) not null auto_increment
-  `racks_id` int(11) not null
+  `id` int not null auto_increment
+  `racks_id` int not null
   `itemtype` varchar(255) not null
-  `items_id` int(11) not null
-  `position` int(11) not null
-  `orientation` tinyint(1)
+  `items_id` int not null
+  `position` int not null
+  `orientation` tinyint(1) default null
   `bgcolor` varchar(7) default null
   `hpos` tinyint(1) not null default '0'
   `is_reserved` tinyint(1) not null default '0'
Table schema differs for table "glpi_enclosuremodels".
--- Original
+++ New
@@ @@
 create table `glpi_enclosuremodels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `weight` int(11) not null default '0'
-  `required_units` int(11) not null default '1'
+  `weight` int not null default '0'
+  `required_units` int not null default '1'
   `depth` float not null default '1'
-  `power_connections` int(11) not null default '0'
-  `power_consumption` int(11) not null default '0'
+  `power_connections` int not null default '0'
+  `power_consumption` int not null default '0'
   `is_half_rack` tinyint(1) not null default '0'
   `picture_front` text
   `picture_rear` text
Table schema differs for table "glpi_enclosures".
--- Original
+++ New
@@ @@
 create table `glpi_enclosures` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `enclosuremodels_id` int(11) default null
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `enclosuremodels_id` int default null
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   `is_deleted` tinyint(1) not null default '0'
-  `orientation` tinyint(1)
+  `orientation` tinyint(1) default null
   `power_supplies` tinyint(1) not null default '0'
-  `states_id` int(11) not null default '0'
+  `states_id` int not null default '0'
   `comment` text
-  `manufacturers_id` int(11) not null default '0'
+  `manufacturers_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_items_enclosures".
--- Original
+++ New
@@ @@
 create table `glpi_items_enclosures` (
-  `id` int(11) not null auto_increment
-  `enclosures_id` int(11) not null
+  `id` int not null auto_increment
+  `enclosures_id` int not null
   `itemtype` varchar(255) not null
-  `items_id` int(11) not null
-  `position` int(11) not null
+  `items_id` int not null
+  `position` int not null
   primary key (`id`)
   unique key `item` (`itemtype`,`items_id`)
Table schema differs for table "glpi_pdumodels".
--- Original
+++ New
@@ @@
 create table `glpi_pdumodels` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `product_number` varchar(255) default null
-  `weight` int(11) not null default '0'
-  `required_units` int(11) not null default '1'
+  `weight` int not null default '0'
+  `required_units` int not null default '1'
   `depth` float not null default '1'
-  `power_connections` int(11) not null default '0'
-  `max_power` int(11) not null default '0'
+  `power_connections` int not null default '0'
+  `max_power` int not null default '0'
   `is_half_rack` tinyint(1) not null default '0'
   `picture_front` text
   `picture_rear` text
Table schema differs for table "glpi_pdutypes".
--- Original
+++ New
@@ @@
 create table `glpi_pdutypes` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `comment` text
Table schema differs for table "glpi_pdus".
--- Original
+++ New
@@ @@
 create table `glpi_pdus` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `locations_id` int(11) not null default '0'
+  `locations_id` int not null default '0'
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
-  `pdumodels_id` int(11) default null
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `pdumodels_id` int default null
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `is_template` tinyint(1) not null default '0'
   `template_name` varchar(255) default null
   `is_deleted` tinyint(1) not null default '0'
-  `states_id` int(11) not null default '0'
+  `states_id` int not null default '0'
   `comment` text
-  `manufacturers_id` int(11) not null default '0'
-  `pdutypes_id` int(11) not null default '0'
+  `manufacturers_id` int not null default '0'
+  `pdutypes_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_plugs".
--- Original
+++ New
@@ @@
 create table `glpi_plugs` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_pdus_plugs".
--- Original
+++ New
@@ @@
 create table `glpi_pdus_plugs` (
-  `id` int(11) not null auto_increment
-  `plugs_id` int(11) not null default '0'
-  `pdus_id` int(11) not null default '0'
-  `number_plugs` int(11) default '0'
+  `id` int not null auto_increment
+  `plugs_id` int not null default '0'
+  `pdus_id` int not null default '0'
+  `number_plugs` int default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_pdus_racks".
--- Original
+++ New
@@ @@
 create table `glpi_pdus_racks` (
-  `id` int(11) not null auto_increment
-  `racks_id` int(11) not null default '0'
-  `pdus_id` int(11) not null default '0'
-  `side` int(11) default '0'
-  `position` int(11) not null
+  `id` int not null auto_increment
+  `racks_id` int not null default '0'
+  `pdus_id` int not null default '0'
+  `side` int default '0'
+  `position` int not null
   `bgcolor` varchar(7) default null
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_itilfollowuptemplates".
--- Original
+++ New
@@ @@
 create table `glpi_itilfollowuptemplates` (
-   `id` int(11) not null auto_increment
-   `date_creation` timestamp null default null
-   `date_mod` timestamp null default null
-   `entities_id` int(11) not null default '0'
-   `is_recursive` tinyint(1) not null default '0'
-   `name` varchar(255) null default null collate 'utf8_unicode_ci'
-   `content` text null collate 'utf8_unicode_ci'
-   `requesttypes_id` int(11) not null default '0'
-   `is_private` tinyint(1) not null default '0'
-   `comment` text null collate 'utf8_unicode_ci'
-   primary key (`id`)
+  `id` int not null auto_increment
+  `date_creation` timestamp null default null
+  `date_mod` timestamp null default null
+  `entities_id` int not null default '0'
+  `is_recursive` tinyint(1) not null default '0'
+  `name` varchar(255) default null
+  `content` text
+  `requesttypes_id` int not null default '0'
+  `is_private` tinyint(1) not null default '0'
+  `comment` text
+  primary key (`id`)
Table schema differs for table "glpi_itilfollowups".
--- Original
+++ New
@@ @@
 create table `glpi_itilfollowups` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `itemtype` varchar(100) not null
-  `items_id` int(11) not null default '0'
+  `items_id` int not null default '0'
   `date` timestamp null default null
-  `users_id` int(11) not null default '0'
-  `users_id_editor` int(11) not null default '0'
+  `users_id` int not null default '0'
+  `users_id_editor` int not null default '0'
   `content` longtext
   `is_private` tinyint(1) not null default '0'
-  `requesttypes_id` int(11) not null default '0'
+  `requesttypes_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   `timeline_position` tinyint(1) not null default '0'
-  `sourceitems_id` int(11) not null default '0'
-  `sourceof_items_id` int(11) not null default '0'
+  `sourceitems_id` int not null default '0'
+  `sourceof_items_id` int not null default '0'
   primary key (`id`)
Table schema differs for table "glpi_clustertypes".
--- Original
+++ New
@@ @@
 create table `glpi_clustertypes` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `comment` text
Table schema differs for table "glpi_clusters".
--- Original
+++ New
@@ @@
 create table `glpi_clusters` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) default null
   `uuid` varchar(255) default null
   `version` varchar(255) default null
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
-  `states_id` int(11) not null default '0'
+  `states_id` int not null default '0'
   `comment` text
-  `clustertypes_id` int(11) not null default '0'
-  `autoupdatesystems_id` int(11) not null default '0'
+  `clustertypes_id` int not null default '0'
+  `autoupdatesystems_id` int not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
   primary key (`id`)
Table schema differs for table "glpi_items_clusters".
--- Original
+++ New
@@ @@
 create table `glpi_items_clusters` (
-  `id` int(11) not null auto_increment
-  `clusters_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `clusters_id` int not null default '0'
   `itemtype` varchar(100) default null
-  `items_id` int(11) not null default '0'
+  `items_id` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`clusters_id`,`itemtype`,`items_id`)
Table schema differs for table "glpi_planningexternalevents".
--- Original
+++ New
@@ @@
 create table `glpi_planningexternalevents` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `uuid` varchar(255) default null
-  `planningexternaleventtemplates_id` int(11) not null default '0'
-  `entities_id` int(11) not null default '0'
+  `planningexternaleventtemplates_id` int not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '1'
   `date` timestamp null default null
-  `users_id` int(11) not null default '0'
+  `users_id` int not null default '0'
   `users_id_guests` text
-  `groups_id` int(11) not null default '0'
+  `groups_id` int not null default '0'
   `name` varchar(255) default null
   `text` text
   `begin` timestamp null default null
   `end` timestamp null default null
   `rrule` text
-  `state` int(11) not null default '0'
-  `planningeventcategories_id` int(11) not null default '0'
+  `state` int not null default '0'
+  `planningeventcategories_id` int not null default '0'
   `background` tinyint(1) not null default '0'
   `date_mod` timestamp null default null
   `date_creation` timestamp null default null
Table schema differs for table "glpi_planningexternaleventtemplates".
--- Original
+++ New
@@ @@
 create table `glpi_planningexternaleventtemplates` (
-   `id` int(11) not null auto_increment
-   `entities_id` int(11) not null default '0'
-   `name` varchar(255) default null
-   `text` text
-   `comment` text
-   `duration` int(11) not null default '0'
-   `before_time` int(11) not null default '0'
-   `rrule` text
-   `state` int(11) not null default '0'
-   `planningeventcategories_id` int(11) not null default '0'
-   `background` tinyint(1) not null default '0'
-   `date_mod` timestamp null default null
-   `date_creation` timestamp null default null
-   primary key (`id`)
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
+  `name` varchar(255) default null
+  `text` text
+  `comment` text
+  `duration` int not null default '0'
+  `before_time` int not null default '0'
+  `rrule` text
+  `state` int not null default '0'
+  `planningeventcategories_id` int not null default '0'
+  `background` tinyint(1) not null default '0'
+  `date_mod` timestamp null default null
+  `date_creation` timestamp null default null
+  primary key (`id`)
Table schema differs for table "glpi_planningeventcategories".
--- Original
+++ New
@@ @@
 create table `glpi_planningeventcategories` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `color` varchar(255) default null
   `comment` text
Table schema differs for table "glpi_items_kanbans".
--- Original
+++ New
@@ @@
 create table `glpi_items_kanbans` (
-   `id` int(11) not null auto_increment
-   `itemtype` varchar(100) not null
-   `items_id` int(11) default null
-   `users_id` int(11) not null
-   `state` text
-   `date_mod` timestamp null default null
-   `date_creation` timestamp null default null
-   primary key (`id`)
-   unique key `unicity` (`itemtype`,`items_id`,`users_id`)
+  `id` int not null auto_increment
+  `itemtype` varchar(100) not null
+  `items_id` int default null
+  `users_id` int not null
+  `state` text
+  `date_mod` timestamp null default null
+  `date_creation` timestamp null default null
+  primary key (`id`)
+  unique key `unicity` (`itemtype`,`items_id`,`users_id`)
Table schema differs for table "glpi_vobjects".
--- Original
+++ New
@@ @@
 create table `glpi_vobjects` (
-   `id` int(11) not null auto_increment
-   `itemtype` varchar(100) default null
-   `items_id` int(11) not null default '0'
-   `data` text
-   `date_mod` timestamp null default null
-   `date_creation` timestamp null default null
-   primary key (`id`)
-   unique key `unicity` (`itemtype`,`items_id`)
+  `id` int not null auto_increment
+  `itemtype` varchar(100) default null
+  `items_id` int not null default '0'
+  `data` text
+  `date_mod` timestamp null default null
+  `date_creation` timestamp null default null
+  primary key (`id`)
+  unique key `unicity` (`itemtype`,`items_id`)
Table schema differs for table "glpi_domaintypes".
--- Original
+++ New
@@ @@
 create table `glpi_domaintypes` (
-  `id` int(11) not null        auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null        default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_domainrelations".
--- Original
+++ New
@@ @@
 create table `glpi_domainrelations` (
-  `id` int(11) not null        auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null        default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_domains_items".
--- Original
+++ New
@@ @@
 create table `glpi_domains_items` (
-  `id` int(11) not null auto_increment
-  `domains_id` int(11) not null default '0'
-  `items_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `domains_id` int not null default '0'
+  `items_id` int not null default '0'
   `itemtype` varchar(100) not null
-  `domainrelations_id` int(11) not null default '0'
+  `domainrelations_id` int not null default '0'
   primary key (`id`)
   unique key `unicity` (`domains_id`,`itemtype`,`items_id`)
Table schema differs for table "glpi_domainrecordtypes".
--- Original
+++ New
@@ @@
 create table `glpi_domainrecordtypes` (
-  `id` int(11) not null        auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
-  `entities_id` int(11) not null        default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `comment` text
   primary key (`id`)
Table schema differs for table "glpi_domainrecords".
--- Original
+++ New
@@ @@
 create table `glpi_domainrecords` (
-  `id` int(11) not null auto_increment
+  `id` int not null auto_increment
   `name` varchar(255) default null
   `data` text
-  `entities_id` int(11) not null default '0'
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
-  `domains_id` int(11) not null default '0'
-  `domainrecordtypes_id` int(11) not null default '0'
-  `ttl` int(11) not null
-  `users_id_tech` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `domains_id` int not null default '0'
+  `domainrecordtypes_id` int not null default '0'
+  `ttl` int not null
+  `users_id_tech` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `is_deleted` tinyint(1) not null default '0'
   `comment` text
   `date_mod` timestamp null default null
Table schema differs for table "glpi_appliances".
--- Original
+++ New
@@ @@
 create table `glpi_appliances` (
-  `id` int(11) not null auto_increment
-  `entities_id` int(11) not null default '0'
+  `id` int not null auto_increment
+  `entities_id` int not null default '0'
   `is_recursive` tinyint(1) not null default '0'
   `name` varchar(255) not null default ''
   `is_deleted` tinyint(1) not null default '0'
-  `appliancetypes_id` int(11) not null default '0'
+  `appliancetypes_id` int not null default '0'
   `comment` text
-  `locations_id` int(11) not null default '0'
-  `manufacturers_id` int(11) not null default '0'
-  `applianceenvironments_id` int(11) not null default '0'
-  `users_id` int(11) not null default '0'
-  `users_id_tech` int(11) not null default '0'
-  `groups_id` int(11) not null default '0'
-  `groups_id_tech` int(11) not null default '0'
+  `locations_id` int not null default '0'
+  `manufacturers_id` int not null default '0'
+  `applianceenvironments_id` int not null default '0'
+  `users_id` int not null default '0'
+  `users_id_tech` int not null default '0'
+  `groups_id` int not null default '0'
+  `groups_id_tech` int not null default '0'
   `date_mod` timestamp null default null
-  `states_id` int(11) not null default '0'
+  `states_id` int not null default '0'
   `externalidentifier` varchar(255) default null
   `serial` varchar(255) default null
   `otherserial` varchar(255) default null
   `is_helpdesk_visible` tinyint(1) not null default '1'
-  primary key  (`id`)
+  primary key (`id`)
   unique key `unicity` (`externalidentifier`)

oj69

Member

From: Somewhere in the cloud

Registered: 2021-02-01

Posts: 157

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

Sounds that the database schema update is missing. Please check the glpi installation/update documentation how to do a schema upgrade by yourself.

IN ANY CASE MAKE SURE TO HAVE A RELIABLE BACKUP OF YOUR DATABASE AND GLPI FILES

ViktorG

Member

Registered: 2021-04-13

Posts: 19

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

the database has already been updated.

sudo php bin/console db:update
+-----------------------+-----------+------------+
|                       | Current   | Назначение |
+-----------------------+-----------+------------+
| Database host         | localhost |            |
| Database name         | glpi      |            |
| Database user         | glpi      |            |
| GLPI version          | 9.5.4     | 9.5.4      |
| GLPI database version | 9.5.4     | 9.5.4      |
+-----------------------+-----------+------------+
Миграция не требуется.

follet

Member

Registered: 2019-07-11

Posts: 18

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

Did you solve your issue with error: Access Denied - The action you have requested is not allowed?
I have some issue, I see login page but after try to login I see this error
I checked all works fine, I think so, but something went wrong...

ViktorG

Member

Registered: 2021-04-13

Posts: 19

Re: Access Denied - The action you have requested is not allowed - v9.5.4.

Did you solve your issue with error: Access Denied - The action you have requested is not allowed?
I have some issue, I see login page but after try to login I see this error
I checked all works fine, I think so, but something went wrong...

Hello, the problem is not solved.