Validity date on new user

[fartigue]

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]

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]

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]

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]

Hello,

Please find enclosed the requested table.

Thanks for you help

[tomolimo]

I can't see the attached file!

[fartigue]

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]

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]

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]

Hello @fartigue,

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

Thank you, Regards, Tomolimo

[fartigue]

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]

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]

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]

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]

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]

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 notifications@github.com 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 https://github.com/tomolimo/timezones/issues/24#issuecomment-656278383, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJUGLQ7FIGUPFQ7IJWY42M3R2YCZDANCNFSM4I2NXFAA .

[tomolimo]

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]

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