search

cconard96 / jamf

JAMF Plugin for GLPI
GNU General Public License v2.0
6 stars 5 forks source link

SQL DATE error during import #120

Closed Kzou closed 6 months ago

Kzou commented 1 year ago

Hi,

During the import, I have an SQL error on a date, for the column "entry_date" :

Unable to create new element or update existing one - Erreur durant l'éxecution de la requête : UPDATE glpi_plugin_jamf_devices SET itemtype = 'Computer', items_id = '2', activation_lock_enabled = '0', entry_date = '2019-11-26T14:06:50.793+0000', jamf_items_id = '3', udid = '****', managed = '1', supervised = '0', sync_date = '2023-04-11 16:54:44' WHERE itemtype = 'Computer' AND items_id = '2' - L'erreur est Incorrect datetime value: '2019-11-26T14:06:50.793+0000' for column c1glpidb.glpi_plugin_jamf_devices.entry_date at row 1

Have you ever encountered this error?

Thanks !

cconard96 commented 1 year ago

Hello. Which version of GLPI and the plugin are you using?

Kzou commented 1 year ago

Hi,

GLPI version 10.0.7 Plugin Jamf version 3.0.1

FlorentDerangere commented 1 year ago

I have the error too, have you find a fix ?

cconard96 commented 6 months ago

I cannot recreate the issue in 3.0.1. Importing and syncing computers is working as expected.