Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Script ocsng_fullsync.sh not working #351

Open
s3rgi opened this issue Mar 5, 2023 · 1 comment
Open

Script ocsng_fullsync.sh not working #351

s3rgi opened this issue Mar 5, 2023 · 1 comment

Comments

@s3rgi
Copy link

s3rgi commented Mar 5, 2023

  • Version of the plugin: 2.0.4
  • The version of GLPI: 10.0.1
  • OCS MariaDB version 10.3.27
  • GLPI MariaDB version 10.3.23

Sync script "ocsng_fullsync.sh" not working. Through the web interface I can import new machines perfectly.
When ran the script with the "--debug" option and it returns this message:

Sun Mar 5 13:32:56 CET 2023 /var/www/glpi/plugins/ocsinventoryng/scripts/ocsng_fullsync.sh started
Manage delete items in OCS server #5: "OCS IMAS"
=====================================================
Thread #1: starting (1/4)
Thread #1: import computers from server: 'OCS IMAS'
SQL Warnings:
1292: 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-03-05 12:53:18')  AND (`hardware`.`LASTDATE` < 'NOW()')  ORDER BY  LASTDATE   "
SQL Warnings:
1292: 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-03-05 12:53:18')  AND (`hardware`.`LASTDATE` < 'NOW()') "
SQL Warnings:
1292: 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 (('524287' & `hardware`.`CHECKSUM`) > 1) AND (`hardware`.`LASTDATE` < 'NOW()')  ORDER BY  LASTDATE   "
SQL Warnings:
1292: 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 (('524287' & `hardware`.`CHECKSUM`) > 1) AND (`hardware`.`LASTDATE` < 'NOW()') "
Thread #1: 0 computer(s)
Thread #1: done!!

and don't synchronize any machine.

@whasf
Copy link

whasf commented Nov 8, 2023

I am seeing the same thing, GLPI 10.0.10, OCS plugin version 2.04

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants