Validity date on new user #24

fartigue · 2019-09-25T14:35:47Z

Hello M. Tomolino,

Your plugin is great and match an important need in global environment!
However, since i installed the plugin, any new user has a date like 19/01/2038 as beginning of validity.
That is to say new user cannot login until i erase that field.

Even a desinstallation of the plugin does'nt change this behavior.

Do you have a way to hack that, or clean the plugin installation?

tomolimo · 2019-09-26T06:34:51Z

Hello @fartigue

Could you provide more information?
GLPI version, plugin version?
Screencopies of the issue?
PHP error logs?
MySQL error logs?

Thank you,
Regards,
Tomolimo

fartigue · 2019-09-26T07:43:42Z

Hello, Thank you for your fast answer. The GLPI version is 9.4.3 The plugin version is 2.5.2 No PHP error, no MySQL as far as I know. You have the trouble in the attached screenshot. When I do in database a explain glpi_users; I have the answer below. I hesitate to set the begin_date to NULL, but I’m not sure MariaDB [glpi]> explain glpi_users; +--------------------------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(255) | YES | MUL | NULL | | | password | varchar(255) | YES | | NULL | | | phone | varchar(255) | YES | | NULL | | | phone2 | varchar(255) | YES | | NULL | | | mobile | varchar(255) | YES | | NULL | | | realname | varchar(255) | YES | MUL | NULL | | | firstname | varchar(255) | YES | MUL | NULL | | | locations_id | int(11) | NO | MUL | 0 | | | language | char(10) | YES | | NULL | | | use_mode | int(11) | NO | | 0 | | | list_limit | int(11) | YES | | NULL | | | is_active | tinyint(1) | NO | MUL | 1 | | | comment | text | YES | | NULL | | | auths_id | int(11) | NO | | 0 | | | authtype | int(11) | NO | MUL | 0 | | | last_login | timestamp | YES | | 2038-01-19 04:14:07 | | | date_mod | timestamp | YES | MUL | 2038-01-19 04:14:07 | | | date_sync | timestamp | YES | | 2038-01-19 04:14:07 | | | is_deleted | tinyint(1) | NO | MUL | 0 | | | profiles_id | int(11) | NO | MUL | 0 | | | entities_id | int(11) | NO | MUL | 0 | | | usertitles_id | int(11) | NO | MUL | 0 | | | usercategories_id | int(11) | NO | MUL | 0 | | | date_format | int(11) | YES | | NULL | | | number_format | int(11) | YES | | NULL | | | names_format | int(11) | YES | | NULL | | | csv_delimiter | char(1) | YES | | NULL | | | is_ids_visible | tinyint(1) | YES | | NULL | | | use_flat_dropdowntree | tinyint(1) | YES | | NULL | | | show_jobs_at_login | tinyint(1) | YES | | NULL | | | priority_1 | char(20) | YES | | NULL | | | priority_2 | char(20) | YES | | NULL | | | priority_3 | char(20) | YES | | NULL | | | priority_4 | char(20) | YES | | NULL | | | priority_5 | char(20) | YES | | NULL | | | priority_6 | char(20) | YES | | NULL | | | followup_private | tinyint(1) | YES | | NULL | | | task_private | tinyint(1) | YES | | NULL | | | default_requesttypes_id | int(11) | YES | | NULL | | | password_forget_token | char(40) | YES | | NULL | | | password_forget_token_date | timestamp | YES | | 2038-01-19 04:14:07 | | | user_dn | text | YES | | NULL | | | registration_number | varchar(255) | YES | | NULL | | | show_count_on_tabs | tinyint(1) | YES | | NULL | | | refresh_ticket_list | int(11) | YES | | NULL | | | set_default_tech | tinyint(1) | YES | | NULL | | | personal_token | varchar(255) | YES | | NULL | | | personal_token_date | timestamp | YES | | 2038-01-19 04:14:07 | | | api_token | varchar(255) | YES | | NULL | | | api_token_date | timestamp | YES | | 2038-01-19 04:14:07 | | | cookie_token | varchar(255) | YES | | NULL | | | cookie_token_date | timestamp | YES | | 2038-01-19 04:14:07 | | | display_count_on_home | int(11) | YES | | NULL | | | notification_to_myself | tinyint(1) | YES | | NULL | | | duedateok_color | varchar(255) | YES | | NULL | | | duedatewarning_color | varchar(255) | YES | | NULL | | | duedatecritical_color | varchar(255) | YES | | NULL | | | duedatewarning_less | int(11) | YES | | NULL | | | duedatecritical_less | int(11) | YES | | NULL | | | duedatewarning_unit | varchar(255) | YES | | NULL | | | duedatecritical_unit | varchar(255) | YES | | NULL | | | display_options | text | YES | | NULL | | | is_deleted_ldap | tinyint(1) | NO | MUL | 0 | | | pdffont | varchar(255) | YES | | NULL | | | picture | varchar(255) | YES | | NULL | | | begin_date | timestamp | YES | MUL | 2038-01-19 04:14:07 | | | end_date | timestamp | YES | MUL | 2038-01-19 04:14:07 | | | keep_devices_when_purging_item | tinyint(1) | YES | | NULL | | | privatebookmarkorder | longtext | YES | | NULL | | | backcreated | tinyint(1) | YES | | NULL | | | task_state | int(11) | YES | | NULL | | | layout | char(20) | YES | | NULL | | | palette | char(20) | YES | | NULL | | | set_default_requester | tinyint(1) | YES | | NULL | | | lock_autolock_mode | tinyint(1) | YES | | NULL | | | lock_directunlock_notification | tinyint(1) | YES | | NULL | | | date_creation | timestamp | YES | MUL | 2038-01-19 04:14:07 | | | highcontrast_css | tinyint(1) | YES | | 0 | | | plannings | text | YES | | NULL | | | sync_field | varchar(255) | YES | MUL | NULL | | | groups_id | int(11) | NO | MUL | 0 | | | users_id_supervisor | int(11) | NO | MUL | 0 | | +--------------------------------+--------------+------+-----+---------------------+----------------+ 83 rows in set (0.001 sec)

tomolimo · 2019-09-26T11:26:28Z

Hello @fartigue

I believe this issue is due to the MariaDB server that is used.
Could you give me the content of the following table glpi_plugin_timezones_dbbackups?
This table contains the definition of the tables before the ALTER (= change datetime fields into timezone).

Thank you,
Regards,
Tomolimo

fartigue · 2019-09-26T11:30:04Z

Hello, Please find enclosed the requested table. Thanks for you help

tomolimo · 2019-09-26T11:31:30Z

I can't see the attached file!

fartigue · 2019-09-26T11:34:34Z

Oups… Copied in the mail core date table_name alter_table 17/07/2019 21:22 glpi_linetypes ALTER TABLE `glpi_linetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_authmails ALTER TABLE `glpi_authmails` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_blacklists ALTER TABLE `glpi_blacklists` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_calendars ALTER TABLE `glpi_calendars` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_apiclients ALTER TABLE `glpi_apiclients` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `app_token_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_states ALTER TABLE `glpi_states` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projects ALTER TABLE `glpi_projects` MODIFY `date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `plan_start_date` datetime DEFAULT NULL, MODIFY `plan_end_date` datetime DEFAULT NULL, MODIFY `real_start_date` datetime DEFAULT NULL, MODIFY `real_end_date` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_savedsearches_alerts ALTER TABLE `glpi_savedsearches_alerts` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_contracts ALTER TABLE `glpi_contracts` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_budgettypes ALTER TABLE `glpi_budgettypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_blacklistedmailcontents ALTER TABLE `glpi_blacklistedmailcontents` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_locations ALTER TABLE `glpi_locations` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projecttasks ALTER TABLE `glpi_projecttasks` MODIFY `date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `plan_start_date` datetime DEFAULT NULL, MODIFY `plan_end_date` datetime DEFAULT NULL, MODIFY `real_start_date` datetime DEFAULT NULL, MODIFY `real_end_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_phonetypes ALTER TABLE `glpi_phonetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_tickets ALTER TABLE `glpi_tickets` MODIFY `date` datetime DEFAULT NULL, MODIFY `closedate` datetime DEFAULT NULL, MODIFY `solvedate` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `time_to_resolve` datetime DEFAULT NULL, MODIFY `time_to_own` datetime DEFAULT NULL, MODIFY `begin_waiting_date` datetime DEFAULT NULL, MODIFY `internal_time_to_resolve` datetime DEFAULT NULL, MODIFY `internal_time_to_own` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_budgets ALTER TABLE `glpi_budgets` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_slas ALTER TABLE `glpi_slas` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_crontasks ALTER TABLE `glpi_crontasks` MODIFY `lastrun` datetime DEFAULT NULL COMMENT 'last run date', MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_cartridgeitems ALTER TABLE `glpi_cartridgeitems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_cartridgeitemtypes ALTER TABLE `glpi_cartridgeitemtypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_computertypes ALTER TABLE `glpi_computertypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_changetasks ALTER TABLE `glpi_changetasks` MODIFY `date` datetime DEFAULT NULL, MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_cartridges ALTER TABLE `glpi_cartridges` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_logs ALTER TABLE `glpi_logs` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networks ALTER TABLE `glpi_networks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_phonemodels ALTER TABLE `glpi_phonemodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_consumables ALTER TABLE `glpi_consumables` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_computerantiviruses ALTER TABLE `glpi_computerantiviruses` MODIFY `date_expiration` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_olas ALTER TABLE `glpi_olas` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_consumableitems ALTER TABLE `glpi_consumableitems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_alerts ALTER TABLE `glpi_alerts` MODIFY `date` datetime NOT NULL 17/07/2019 21:22 glpi_netpoints ALTER TABLE `glpi_netpoints` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_links ALTER TABLE `glpi_links` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_changevalidations ALTER TABLE `glpi_changevalidations` MODIFY `submission_date` datetime DEFAULT NULL, MODIFY `validation_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_computervirtualmachines ALTER TABLE `glpi_computervirtualmachines` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_peripherals ALTER TABLE `glpi_peripherals` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_changes ALTER TABLE `glpi_changes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date` datetime DEFAULT NULL, MODIFY `solvedate` datetime DEFAULT NULL, MODIFY `closedate` datetime DEFAULT NULL, MODIFY `time_to_resolve` datetime DEFAULT NULL, MODIFY `begin_waiting_date` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_tickettasks ALTER TABLE `glpi_tickettasks` MODIFY `date` datetime DEFAULT NULL, MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_contacts ALTER TABLE `glpi_contacts` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_consumableitemtypes ALTER TABLE `glpi_consumableitemtypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projectstates ALTER TABLE `glpi_projectstates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_contacttypes ALTER TABLE `glpi_contacttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_filesystems ALTER TABLE `glpi_filesystems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_fqdns ALTER TABLE `glpi_fqdns` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_contracttypes ALTER TABLE `glpi_contracttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_crontasklogs ALTER TABLE `glpi_crontasklogs` MODIFY `date` datetime NOT NULL 17/07/2019 21:22 glpi_groups ALTER TABLE `glpi_groups` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicecasetypes ALTER TABLE `glpi_devicecasetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_phones ALTER TABLE `glpi_phones` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_holidays ALTER TABLE `glpi_holidays` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicegraphiccards ALTER TABLE `glpi_devicegraphiccards` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicemotherboards ALTER TABLE `glpi_devicemotherboards` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicegenerics ALTER TABLE `glpi_devicegenerics` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicememorytypes ALTER TABLE `glpi_devicememorytypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicenetworkcards ALTER TABLE `glpi_devicenetworkcards` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_deviceprocessors ALTER TABLE `glpi_deviceprocessors` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_deviceharddrives ALTER TABLE `glpi_deviceharddrives` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_documenttypes ALTER TABLE `glpi_documenttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_events ALTER TABLE `glpi_events` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicesoundcards ALTER TABLE `glpi_devicesoundcards` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ipnetworks ALTER TABLE `glpi_ipnetworks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_suppliers ALTER TABLE `glpi_suppliers` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_monitormodels ALTER TABLE `glpi_monitormodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicecases ALTER TABLE `glpi_devicecases` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_datacenters ALTER TABLE `glpi_datacenters` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_entities ALTER TABLE `glpi_entities` MODIFY `max_closedate` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_items_disks ALTER TABLE `glpi_items_disks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_fieldunicities ALTER TABLE `glpi_fieldunicities` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_printers ALTER TABLE `glpi_printers` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_documents ALTER TABLE `glpi_documents` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_printermodels ALTER TABLE `glpi_printermodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_users ALTER TABLE `glpi_users` MODIFY `last_login` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_sync` datetime DEFAULT NULL, MODIFY `password_forget_token_date` datetime DEFAULT NULL, MODIFY `personal_token_date` datetime DEFAULT NULL, MODIFY `api_token_date` datetime DEFAULT NULL, MODIFY `begin_date` datetime DEFAULT NULL, MODIFY `end_date` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_problems ALTER TABLE `glpi_problems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date` datetime DEFAULT NULL, MODIFY `solvedate` datetime DEFAULT NULL, MODIFY `closedate` datetime DEFAULT NULL, MODIFY `time_to_resolve` datetime DEFAULT NULL, MODIFY `begin_waiting_date` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_notepads ALTER TABLE `glpi_notepads` MODIFY `date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_computermodels ALTER TABLE `glpi_computermodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_domains ALTER TABLE `glpi_domains` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_fieldblacklists ALTER TABLE `glpi_fieldblacklists` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_itilcategories ALTER TABLE `glpi_itilcategories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitems_comments ALTER TABLE `glpi_knowbaseitems_comments` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_authldaps ALTER TABLE `glpi_authldaps` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_profiles ALTER TABLE `glpi_profiles` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_interfacetypes ALTER TABLE `glpi_interfacetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_mailcollectors ALTER TABLE `glpi_mailcollectors` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_monitortypes ALTER TABLE `glpi_monitortypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projecttasktemplates ALTER TABLE `glpi_projecttasktemplates` MODIFY `plan_start_date` datetime DEFAULT NULL, MODIFY `plan_end_date` datetime DEFAULT NULL, MODIFY `real_start_date` datetime DEFAULT NULL, MODIFY `real_end_date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportaliases ALTER TABLE `glpi_networkportaliases` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitems_items ALTER TABLE `glpi_knowbaseitems_items` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportaggregates ALTER TABLE `glpi_networkportaggregates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_manufacturers ALTER TABLE `glpi_manufacturers` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_softwarelicensetypes ALTER TABLE `glpi_softwarelicensetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networknames ALTER TABLE `glpi_networknames` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_computers ALTER TABLE `glpi_computers` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicecontrols ALTER TABLE `glpi_devicecontrols` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkequipmenttypes ALTER TABLE `glpi_networkequipmenttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitemcategories ALTER TABLE `glpi_knowbaseitemcategories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicepcis ALTER TABLE `glpi_devicepcis` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportlocals ALTER TABLE `glpi_networkportlocals` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportwifis ALTER TABLE `glpi_networkportwifis` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemservicepacks ALTER TABLE `glpi_operatingsystemservicepacks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_phonepowersupplies ALTER TABLE `glpi_phonepowersupplies` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_rssfeeds ALTER TABLE `glpi_rssfeeds` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_formcreator_issues ALTER TABLE `glpi_plugin_formcreator_issues` MODIFY `date_creation` datetime NOT NULL, MODIFY `date_mod` datetime NOT NULL 17/07/2019 21:22 glpi_networkportdialups ALTER TABLE `glpi_networkportdialups` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportfiberchannels ALTER TABLE `glpi_networkportfiberchannels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemarchitectures ALTER TABLE `glpi_operatingsystemarchitectures` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemversions ALTER TABLE `glpi_operatingsystemversions` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_rules ALTER TABLE `glpi_rules` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_softwares ALTER TABLE `glpi_softwares` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkportethernets ALTER TABLE `glpi_networkportethernets` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkports ALTER TABLE `glpi_networkports` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_planningrecalls ALTER TABLE `glpi_planningrecalls` MODIFY `when` datetime DEFAULT NULL 17/07/2019 21:22 glpi_reminders ALTER TABLE `glpi_reminders` MODIFY `date` datetime DEFAULT NULL, MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `begin_view_date` datetime DEFAULT NULL, MODIFY `end_view_date` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_notificationtemplates ALTER TABLE `glpi_notificationtemplates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_notimportedemails ALTER TABLE `glpi_notimportedemails` MODIFY `date` datetime NOT NULL 17/07/2019 21:22 glpi_operatingsystems ALTER TABLE `glpi_operatingsystems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_peripheraltypes ALTER TABLE `glpi_peripheraltypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkequipments ALTER TABLE `glpi_networkequipments` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_ipdiscoverocslinks ALTER TABLE `glpi_plugin_ocsinventoryng_ipdiscoverocslinks` MODIFY `last_update` datetime DEFAULT NULL 17/07/2019 21:22 glpi_softwarelicenses ALTER TABLE `glpi_softwarelicenses` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_datainjection_models ALTER TABLE `glpi_plugin_datainjection_models` MODIFY `date_mod` datetime NOT NULL DEFAULT current_timestamp(), MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_order_bills ALTER TABLE `glpi_plugin_order_bills` MODIFY `billdate` datetime DEFAULT NULL, MODIFY `validationdate` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_notimportedcomputers ALTER TABLE `glpi_plugin_ocsinventoryng_notimportedcomputers` MODIFY `last_inventory` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_formcreator_formanswers ALTER TABLE `glpi_plugin_formcreator_formanswers` MODIFY `request_date` datetime NOT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_details ALTER TABLE `glpi_plugin_ocsinventoryng_details` MODIFY `process_time` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_projet_tasks ALTER TABLE `glpi_plugin_projet_tasks` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_servers ALTER TABLE `glpi_plugin_ocsinventoryng_servers` MODIFY `max_glpidate` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_threads ALTER TABLE `glpi_plugin_ocsinventoryng_threads` MODIFY `start_time` datetime DEFAULT NULL, MODIFY `end_time` datetime DEFAULT NULL 17/07/2019 21:22 glpi_slms ALTER TABLE `glpi_slms` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_dcrooms ALTER TABLE `glpi_dcrooms` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_order_orders ALTER TABLE `glpi_plugin_order_orders` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_order_references ALTER TABLE `glpi_plugin_order_references` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_pdf_configs ALTER TABLE `glpi_plugin_pdf_configs` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_projet_projets ALTER TABLE `glpi_plugin_projet_projets` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_projet_taskplannings ALTER TABLE `glpi_plugin_projet_taskplannings` MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projecttypes ALTER TABLE `glpi_projecttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_monitors ALTER TABLE `glpi_monitors` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_rackmodels ALTER TABLE `glpi_rackmodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_racks_racks ALTER TABLE `glpi_plugin_racks_racks` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_projecttasktypes ALTER TABLE `glpi_projecttasktypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_infocoms ALTER TABLE `glpi_infocoms` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `decommission_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_ocslinks ALTER TABLE `glpi_plugin_ocsinventoryng_ocslinks` MODIFY `last_update` datetime DEFAULT NULL, MODIFY `last_ocs_update` datetime DEFAULT NULL, MODIFY `last_ocs_conn` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_snmpocslinks ALTER TABLE `glpi_plugin_ocsinventoryng_snmpocslinks` MODIFY `last_update` datetime DEFAULT NULL 17/07/2019 21:22 glpi_racktypes ALTER TABLE `glpi_racktypes` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_printertypes ALTER TABLE `glpi_printertypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_reservations ALTER TABLE `glpi_reservations` MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL 17/07/2019 21:22 glpi_rulerightparameters ALTER TABLE `glpi_rulerightparameters` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_savedsearches ALTER TABLE `glpi_savedsearches` MODIFY `last_execution_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_slalevels_tickets ALTER TABLE `glpi_slalevels_tickets` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_virtualmachinestates ALTER TABLE `glpi_virtualmachinestates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_softwareversions ALTER TABLE `glpi_softwareversions` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_solutiontemplates ALTER TABLE `glpi_solutiontemplates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ssovariables ALTER TABLE `glpi_ssovariables` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_virtualmachinesystems ALTER TABLE `glpi_virtualmachinesystems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_virtualmachinetypes ALTER TABLE `glpi_virtualmachinetypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_transfers ALTER TABLE `glpi_transfers` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_suppliertypes ALTER TABLE `glpi_suppliertypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ticketfollowups ALTER TABLE `glpi_ticketfollowups` MODIFY `date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_lines ALTER TABLE `glpi_lines` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_vlans ALTER TABLE `glpi_vlans` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ticketsatisfactions ALTER TABLE `glpi_ticketsatisfactions` MODIFY `date_begin` datetime DEFAULT NULL, MODIFY `date_answered` datetime DEFAULT NULL 17/07/2019 21:22 glpi_solutiontypes ALTER TABLE `glpi_solutiontypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_usercategories ALTER TABLE `glpi_usercategories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_businesscriticities ALTER TABLE `glpi_businesscriticities` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_wifinetworks ALTER TABLE `glpi_wifinetworks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ticketrecurrents ALTER TABLE `glpi_ticketrecurrents` MODIFY `begin_date` datetime DEFAULT NULL, MODIFY `next_creation_date` datetime DEFAULT NULL, MODIFY `end_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_taskcategories ALTER TABLE `glpi_taskcategories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_queuednotifications ALTER TABLE `glpi_queuednotifications` MODIFY `create_time` datetime DEFAULT NULL, MODIFY `send_time` datetime DEFAULT NULL, MODIFY `sent_time` datetime DEFAULT NULL 17/07/2019 21:22 glpi_ticketvalidations ALTER TABLE `glpi_ticketvalidations` MODIFY `submission_date` datetime DEFAULT NULL, MODIFY `validation_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_usertitles ALTER TABLE `glpi_usertitles` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_tasktemplates ALTER TABLE `glpi_tasktemplates` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitemtranslations ALTER TABLE `glpi_knowbaseitemtranslations` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicefirmwares ALTER TABLE `glpi_devicefirmwares` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicememories ALTER TABLE `glpi_devicememories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicebatteries ALTER TABLE `glpi_devicebatteries` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicefirmwaretypes ALTER TABLE `glpi_devicefirmwaretypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitems_revisions ALTER TABLE `glpi_knowbaseitems_revisions` MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicedrives ALTER TABLE `glpi_devicedrives` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicesensors ALTER TABLE `glpi_devicesensors` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_racks ALTER TABLE `glpi_racks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicepowersupplies ALTER TABLE `glpi_devicepowersupplies` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicebatterytypes ALTER TABLE `glpi_devicebatterytypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_peripheralmodels ALTER TABLE `glpi_peripheralmodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_itilsolutions ALTER TABLE `glpi_itilsolutions` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_approval` datetime DEFAULT NULL 17/07/2019 21:22 glpi_documentcategories ALTER TABLE `glpi_documentcategories` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemkernelversions ALTER TABLE `glpi_operatingsystemkernelversions` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_certificatetypes ALTER TABLE `glpi_certificatetypes` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicesimcards ALTER TABLE `glpi_devicesimcards` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_items_operatingsystems ALTER TABLE `glpi_items_operatingsystems` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_genericobject_typefamilies ALTER TABLE `glpi_plugin_genericobject_typefamilies` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_certificates ALTER TABLE `glpi_certificates` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_knowbaseitems ALTER TABLE `glpi_knowbaseitems` MODIFY `date` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `begin_date` datetime DEFAULT NULL, MODIFY `end_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_olalevels_tickets ALTER TABLE `glpi_olalevels_tickets` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_notifications ALTER TABLE `glpi_notifications` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_genericobject_types ALTER TABLE `glpi_plugin_genericobject_types` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemkernels ALTER TABLE `glpi_operatingsystemkernels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_certificates_items ALTER TABLE `glpi_certificates_items` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_devicesimcardtypes ALTER TABLE `glpi_devicesimcardtypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_requesttypes ALTER TABLE `glpi_requesttypes` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 ocs_glpi_rules ALTER TABLE `ocs_glpi_rules` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_documents_items ALTER TABLE `glpi_documents_items` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_enclosures ALTER TABLE `glpi_enclosures` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_operatingsystemeditions ALTER TABLE `glpi_operatingsystemeditions` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_lineoperators ALTER TABLE `glpi_lineoperators` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_problemtasks ALTER TABLE `glpi_problemtasks` MODIFY `date` datetime DEFAULT NULL, MODIFY `begin` datetime DEFAULT NULL, MODIFY `end` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_networkportconnectionlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportconnectionlogs` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_nebackup_logs ALTER TABLE `glpi_plugin_nebackup_logs` MODIFY `datetime` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_ocsservers ALTER TABLE `glpi_plugin_ocsinventoryng_ocsservers` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_ocsinventoryng_winupdates ALTER TABLE `glpi_plugin_ocsinventoryng_winupdates` MODIFY `scheduleinstalldate` datetime DEFAULT NULL, MODIFY `lastsuccesstime` datetime DEFAULT NULL, MODIFY `detectsuccesstime` datetime DEFAULT NULL, MODIFY `downloadsuccesstime` datetime DEFAULT NULL 17/07/2019 21:22 glpi_networkequipmentmodels ALTER TABLE `glpi_networkequipmentmodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_agents ALTER TABLE `glpi_plugin_fusioninventory_agents` MODIFY `last_contact` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_tasks ALTER TABLE `glpi_plugin_fusioninventory_tasks` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `datetime_start` datetime DEFAULT NULL, MODIFY `datetime_end` datetime DEFAULT NULL, MODIFY `last_agent_wakeup` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_taskjobs ALTER TABLE `glpi_plugin_fusioninventory_taskjobs` MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_taskjoblogs ALTER TABLE `glpi_plugin_fusioninventory_taskjoblogs` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_deployfiles ALTER TABLE `glpi_plugin_fusioninventory_deployfiles` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_statediscoveries ALTER TABLE `glpi_plugin_fusioninventory_statediscoveries` MODIFY `start_time` datetime DEFAULT NULL, MODIFY `end_time` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_taskjobstates ALTER TABLE `glpi_plugin_fusioninventory_taskjobstates` MODIFY `date_start` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_unmanageds ALTER TABLE `glpi_plugin_fusioninventory_unmanageds` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_credentials ALTER TABLE `glpi_plugin_fusioninventory_credentials` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_credentialips ALTER TABLE `glpi_plugin_fusioninventory_credentialips` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_ignoredimportdevices ALTER TABLE `glpi_plugin_fusioninventory_ignoredimportdevices` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_rulematchedlogs ALTER TABLE `glpi_plugin_fusioninventory_rulematchedlogs` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_inventorycomputercomputers ALTER TABLE `glpi_plugin_fusioninventory_inventorycomputercomputers` MODIFY `operatingsystem_installationdate` datetime DEFAULT NULL, MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_networkequipments ALTER TABLE `glpi_plugin_fusioninventory_networkequipments` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_printers ALTER TABLE `glpi_plugin_fusioninventory_printers` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_printerlogs ALTER TABLE `glpi_plugin_fusioninventory_printerlogs` MODIFY `date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_networkports ALTER TABLE `glpi_plugin_fusioninventory_networkports` MODIFY `lastup` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_networkportlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportlogs` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_computerlicenseinfos ALTER TABLE `glpi_plugin_fusioninventory_computerlicenseinfos` MODIFY `activation_date` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_deploypackages ALTER TABLE `glpi_plugin_fusioninventory_deploypackages` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_pdumodels ALTER TABLE `glpi_pdumodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_enclosuremodels ALTER TABLE `glpi_enclosuremodels` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_deploymirrors ALTER TABLE `glpi_plugin_fusioninventory_deploymirrors` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_deployuserinteractiontemplates ALTER TABLE `glpi_plugin_fusioninventory_deployuserinteractiontemplates` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_pdutypes ALTER TABLE `glpi_pdutypes` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_pdus ALTER TABLE `glpi_pdus` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugin_fusioninventory_timeslots ALTER TABLE `glpi_plugin_fusioninventory_timeslots` MODIFY `date_mod` datetime DEFAULT NULL 17/07/2019 21:22 glpi_plugs ALTER TABLE `glpi_plugs` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_pdus_plugs ALTER TABLE `glpi_pdus_plugs` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 17/07/2019 21:22 glpi_pdus_racks ALTER TABLE `glpi_pdus_racks` MODIFY `date_mod` datetime DEFAULT NULL, MODIFY `date_creation` datetime DEFAULT NULL 19/07/2019 15:49 glpi_plugin_behaviors_configs ALTER TABLE `glpi_plugin_behaviors_configs` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_agents ALTER TABLE `glpi_plugin_fusioninventory_agents` MODIFY `last_contact` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_unmanageds ALTER TABLE `glpi_plugin_fusioninventory_unmanageds` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_ignoredimportdevices ALTER TABLE `glpi_plugin_fusioninventory_ignoredimportdevices` MODIFY `date` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_inventorycomputercomputers ALTER TABLE `glpi_plugin_fusioninventory_inventorycomputercomputers` MODIFY `operatingsystem_installationdate` datetime DEFAULT NULL, MODIFY `last_fusioninventory_update` datetime DEFAULT NULL, MODIFY `last_boot` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_computerlicenseinfos ALTER TABLE `glpi_plugin_fusioninventory_computerlicenseinfos` MODIFY `activation_date` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_networkports ALTER TABLE `glpi_plugin_fusioninventory_networkports` MODIFY `lastup` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_networkequipments ALTER TABLE `glpi_plugin_fusioninventory_networkequipments` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_tasks ALTER TABLE `glpi_plugin_fusioninventory_tasks` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `datetime_start` datetime DEFAULT NULL, MODIFY `datetime_end` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_taskjobs ALTER TABLE `glpi_plugin_fusioninventory_taskjobs` MODIFY `date_creation` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_taskjoblogs ALTER TABLE `glpi_plugin_fusioninventory_taskjoblogs` MODIFY `date` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_deployfiles ALTER TABLE `glpi_plugin_fusioninventory_deployfiles` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_statediscoveries ALTER TABLE `glpi_plugin_fusioninventory_statediscoveries` MODIFY `start_time` datetime DEFAULT NULL, MODIFY `end_time` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_taskjobstates ALTER TABLE `glpi_plugin_fusioninventory_taskjobstates` MODIFY `date_start` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_credentials ALTER TABLE `glpi_plugin_fusioninventory_credentials` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_credentialips ALTER TABLE `glpi_plugin_fusioninventory_credentialips` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_printers ALTER TABLE `glpi_plugin_fusioninventory_printers` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_timeslots ALTER TABLE `glpi_plugin_fusioninventory_timeslots` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_printerlogs ALTER TABLE `glpi_plugin_fusioninventory_printerlogs` MODIFY `date` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_networkportlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportlogs` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_deploymirrors ALTER TABLE `glpi_plugin_fusioninventory_deploymirrors` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_networkportconnectionlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportconnectionlogs` MODIFY `date_mod` datetime DEFAULT NULL 02/08/2019 23:27 glpi_plugin_fusioninventory_deploypackages ALTER TABLE `glpi_plugin_fusioninventory_deploypackages` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_users ALTER TABLE `glpi_users` MODIFY `cookie_token_date` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_agents ALTER TABLE `glpi_plugin_fusioninventory_agents` MODIFY `last_contact` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_ignoredimportdevices ALTER TABLE `glpi_plugin_fusioninventory_ignoredimportdevices` MODIFY `date` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_networkports ALTER TABLE `glpi_plugin_fusioninventory_networkports` MODIFY `lastup` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_unmanageds ALTER TABLE `glpi_plugin_fusioninventory_unmanageds` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_deployfiles ALTER TABLE `glpi_plugin_fusioninventory_deployfiles` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_timeslots ALTER TABLE `glpi_plugin_fusioninventory_timeslots` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_tasks ALTER TABLE `glpi_plugin_fusioninventory_tasks` MODIFY `date_creation` datetime DEFAULT NULL, MODIFY `datetime_start` datetime DEFAULT NULL, MODIFY `datetime_end` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_taskjoblogs ALTER TABLE `glpi_plugin_fusioninventory_taskjoblogs` MODIFY `date` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_statediscoveries ALTER TABLE `glpi_plugin_fusioninventory_statediscoveries` MODIFY `start_time` datetime DEFAULT NULL, MODIFY `end_time` datetime DEFAULT NULL, MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_taskjobstates ALTER TABLE `glpi_plugin_fusioninventory_taskjobstates` MODIFY `date_start` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_inventorycomputercomputers ALTER TABLE `glpi_plugin_fusioninventory_inventorycomputercomputers` MODIFY `operatingsystem_installationdate` datetime DEFAULT NULL, MODIFY `last_fusioninventory_update` datetime DEFAULT NULL, MODIFY `last_boot` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_credentials ALTER TABLE `glpi_plugin_fusioninventory_credentials` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_credentialips ALTER TABLE `glpi_plugin_fusioninventory_credentialips` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_taskjobs ALTER TABLE `glpi_plugin_fusioninventory_taskjobs` MODIFY `date_creation` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_networkequipments ALTER TABLE `glpi_plugin_fusioninventory_networkequipments` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_computerlicenseinfos ALTER TABLE `glpi_plugin_fusioninventory_computerlicenseinfos` MODIFY `activation_date` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_printers ALTER TABLE `glpi_plugin_fusioninventory_printers` MODIFY `last_fusioninventory_update` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_printerlogs ALTER TABLE `glpi_plugin_fusioninventory_printerlogs` MODIFY `date` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_networkportlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportlogs` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_deploymirrors ALTER TABLE `glpi_plugin_fusioninventory_deploymirrors` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_deploypackages ALTER TABLE `glpi_plugin_fusioninventory_deploypackages` MODIFY `date_mod` datetime DEFAULT NULL 23/09/2019 18:10 glpi_plugin_fusioninventory_networkportconnectionlogs ALTER TABLE `glpi_plugin_fusioninventory_networkportconnectionlogs` MODIFY `date_mod` datetime DEFAULT NULL

tomolimo · 2019-09-26T11:53:03Z

Hello @fartigue,

I don't really understand I've written such new default values....
You may clear the timezone default values. Just set them to NULL
First try on the glpi_users table, before applying this to all the tables.

Thank you
Regards,
Tomolimo

fartigue · 2019-09-26T11:56:02Z

OK, i’ve tried with glpi_users.begindate and that’s worked. That is to say your plugin mechanism isn’t based on these default values and I can erase them ? Anyway, thanks a lot for your contribution

tomolimo · 2019-09-26T12:00:43Z

Hello @fartigue,

I confirm that the plugin doesn't use this default value nowhere.

Thank you,
Regards,
Tomolimo

fartigue · 2019-09-26T15:04:21Z

Hello again, I applied the fix you told me, but, strange thing, the values get back to 2038/01/19 after a few hours Does your plugin can change frequently theses values ?

tomolimo · 2019-09-27T07:14:29Z

Hello @fartigue

This is crazy: the plugin will change a field only when the type is DATETIME. It will change it to TIMESTAMP.
But it will not check for default values.

You may have a look into the needConvert() function in setup.php file

Thank you
Regards,
Tomolimo

pablitobin · 2020-03-04T15:42:58Z

Same problem to me. Any fix? It happens when I create a new ticket, time to resolve, time to own are filled automatically with same date 01-18-2038

tomolimo · 2020-03-05T07:53:08Z

Hello @pablitobin

Could you provide more information?
GLPI version, plugin version?
Screencopies of the issue?
PHP error logs?
MySQL error logs?

Thank you,
Regards,
Tomolimo

brncardoso · 2020-07-09T18:18:42Z

Hello, @tomolimo

Same problem to me. Any fix? It happens when I create a new ticket, time to resolve, time to own are filled automatically with same date "19-01-2038 00:14"

GLPI 9.4.5
PHP 7.0.33
Apache/2.4.6
MariaDB Server: 10.4.13-MariaDB

pablitobin · 2020-07-09T21:13:02Z

That happens to me too. I had to fix it editing the database table by table.

…

On Thu, Jul 9, 2020, 1:18 PM brncardoso ***@***.***> wrote: Hello, @tomolimo <https://github.com/tomolimo> Same problem to me. Any fix? It happens when I create a new ticket, time to resolve, time to own are filled automatically with same date "19-01-2038 00:14" — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#24 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJUGLQ7FIGUPFQ7IJWY42M3R2YCZDANCNFSM4I2NXFAA> .

tomolimo · 2020-07-13T09:53:51Z

Hello,
Could it be that MariaDB will use a specific default value for TIMESTAMP fields?
I'm going to try to reproduce this behavior, but as I don't use MariaDB, I'll have to install it first :(
Thank you if you can give more details for me to try to reproduce.
Regards,
Tomolimo

tomolimo · 2020-07-13T16:03:09Z

Hello,
It seems to be an issue with MariaDB...
During DATETIME to TIMESAMP field conversion, there is an issue about the values of the default column.

Here is a fix that you may apply in the glpi_folder/plugins/timezone/hook.php file

line 125, replace the following code:

         if (is_null($column['COLUMN_DEFAULT']) && $column['IS_NULLABLE']=='NO') { // no default
            $defaultalter=" DEFAULT '0000-00-00 00:00:00'";
         } else if (is_null($column['COLUMN_DEFAULT']) && $column['IS_NULLABLE']=='YES') {
            $defaultalter = " DEFAULT NULL";
         } else if (!is_null($column['COLUMN_DEFAULT'])) {

by the following one:

         if ($column['COLUMN_DEFAULT'] == 'NULL' && $column['IS_NULLABLE']=='NO') { // no default
            $defaultalter=" DEFAULT '0000-00-00 00:00:00'";
         } else if ($column['COLUMN_DEFAULT'] == 'NULL' && $column['IS_NULLABLE']=='YES') {
            $defaultalter = " DEFAULT NULL";
         } else if ($column['COLUMN_DEFAULT'] != 'NULL') {

This new code has only been tested for MariaDB 10.4.13,

Beware that this will not change anything if plugin is already activated. If this is the case, the only way is to manually set default values for TIMESTAMP fields to NULL.

Keep me informed about evolution of the issue.

Thank you
Regards,
Tomolimo

tomolimo self-assigned this Jul 13, 2020

tomolimo added the bug label Jul 13, 2020

tomolimo mentioned this issue Nov 10, 2020

Date '2038-01-18 22:14' is being inserted automatically in different parts of GLPI. glpi-project/glpi#8250

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Validity date on new user #24

Validity date on new user #24

fartigue commented Sep 25, 2019

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email •

edited

Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email •

edited

Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email •

edited

Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email •

edited

Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email •

edited

Loading

tomolimo commented Sep 27, 2019

pablitobin commented Mar 4, 2020

tomolimo commented Mar 5, 2020

brncardoso commented Jul 9, 2020 •

edited

Loading

pablitobin commented Jul 9, 2020 via email

tomolimo commented Jul 13, 2020

tomolimo commented Jul 13, 2020

Validity date on new user #24

Validity date on new user #24

Comments

fartigue commented Sep 25, 2019

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email • edited Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email • edited Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email • edited Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email • edited Loading

tomolimo commented Sep 26, 2019

fartigue commented Sep 26, 2019 via email • edited Loading

tomolimo commented Sep 27, 2019

pablitobin commented Mar 4, 2020

tomolimo commented Mar 5, 2020

brncardoso commented Jul 9, 2020 • edited Loading

pablitobin commented Jul 9, 2020 via email

tomolimo commented Jul 13, 2020

tomolimo commented Jul 13, 2020

fartigue commented Sep 26, 2019 via email •

edited

Loading

fartigue commented Sep 26, 2019 via email •

edited

Loading

fartigue commented Sep 26, 2019 via email •

edited

Loading

fartigue commented Sep 26, 2019 via email •

edited

Loading

fartigue commented Sep 26, 2019 via email •

edited

Loading

brncardoso commented Jul 9, 2020 •

edited

Loading