You are not logged in.
Pages: 1
Hello, I would like to do an automatic sync between ocs & glpi, but when I run the command:
sh ocsng_fullsync.sh --server_id=1 --thread_nbr=2 --nolog
unfortunately I have this error
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mer. 08 févr. 2023 18:46:57 CET ocsng_fullsync.sh started
Manage delete items in OCS server #1: "OCS Inventory"
=====================================================
Thread #1: starting (1/2)
Thread #1: import computers from server: 'OCS Inventory'
SQL Error "1525": Incorrect DATETIME value: 'NOW()' in query "SELECT DISTINCT `hardware`.`ID`,`hardware`.`LASTDATE`,`hardware`.`NAME` FROM `hardware` INNER JOIN `accountinfo` ON `accountinfo`.`HARDWARE_ID` = `hardware`.`ID` WHERE `hardware`.`DEVICEID` NOT LIKE '\_%' AND `hardware`.`ARCHIVE` IS NULL AND (`hardware`.`LASTDATE` > '2023-02-08 14:09:04') AND (`hardware`.`LASTDATE` < 'NOW()') ORDER BY LASTDATE "
SQL Error "1525": Incorrect DATETIME value: 'NOW()' in query "SELECT count(DISTINCT `hardware`.`ID`) as total FROM `hardware` INNER JOIN `accountinfo` ON `accountinfo`.`HARDWARE_ID` = `hardware`.`ID` WHERE `hardware`.`DEVICEID` NOT LIKE '\_%' AND `hardware`.`ARCHIVE` IS NULL AND (`hardware`.`LASTDATE` > '2023-02-08 14:09:04') AND (`hardware`.`LASTDATE` < 'NOW()') "
Uncaught Exception Error: Call to a member function fetch_assoc() on bool in /var/www/glpi/src/DBmysql.php at line 548
=====================================================
Thread #2: starting (2/2)
Thread #2: import computers from server: 'OCS Inventory'
SQL Error "1525": Incorrect DATETIME value: 'NOW()' in query "SELECT DISTINCT `hardware`.`ID`,`hardware`.`LASTDATE`,`hardware`.`NAME` FROM `hardware` INNER JOIN `accountinfo` ON `accountinfo`.`HARDWARE_ID` = `hardware`.`ID` WHERE `hardware`.`DEVICEID` NOT LIKE '\_%' AND `hardware`.`ARCHIVE` IS NULL AND (`hardware`.`LASTDATE` > '2023-02-08 14:09:04') AND (`hardware`.`LASTDATE` < 'NOW()') ORDER BY LASTDATE "
SQL Error "1525": Incorrect DATETIME value: 'NOW()' in query "SELECT count(DISTINCT `hardware`.`ID`) as total FROM `hardware` INNER JOIN `accountinfo` ON `accountinfo`.`HARDWARE_ID` = `hardware`.`ID` WHERE `hardware`.`DEVICEID` NOT LIKE '\_%' AND `hardware`.`ARCHIVE` IS NULL AND (`hardware`.`LASTDATE` > '2023-02-08 14:09:04') AND (`hardware`.`LASTDATE` < 'NOW()') "
Uncaught Exception Error: Call to a member function fetch_assoc() on bool in /var/www/glpi/src/DBmysql.php at line 548
cleaning up.
mer. 08 févr. 2023 18:46:59 CET ended
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
If you have an idea, I'll take it with pleasure.
Offline
Pages: 1