La liaison OCS sur IP ou MAC a fait l'objet d'un ticket https://forge.indepnet.net/issues/3088
La correction sera intégrée en 0.80.3 Au besoin, il faut récupérer les patch https://forge.indepnet.net/projects/glpi/repository/revisions/15565 https://forge.indepnet.net/projects/glpi/repository/revisions/15599 Cdlt. ----- Mail original ----- > 07-09-2011 15:35 > *** MySQL query error : > *** > SQL: SELECT `glpi_computers`.`id` > FROM `glpi_computers` > WHERE `glpi_computers`.`entities_id` IN (0) > AND `glpi_computers`.`is_template` = \'0\' AND > `glpi_networkports`.`mac` IN (00:24:xx:xx:BF:DA,00:21:6A:xx:xx:xx) > AND > (`glpi_computers`.`name`=\'NB-367\') AND `glpi_computers`.`serial`= > \'6ZMBH4J\' > ORDER BY `glpi_computers`.`is_deleted` ASC > Error: You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near ':24:xx:xx:BF:DA,00:21:6A:xx:xx:xx) AND > (`glpi_computers`.`name`='Notebook-xxx') AND `' at line 4 > Backtrace : > /usr/share/glpi/inc/ruleimportcomputer.class.php :338 > DBmysql->query() > /usr/share/glpi/inc/rule.class.php :826 > RuleImportComputer->findWithGlobalCriteria() > /usr/share/glpi/inc/rule.class.php :769 Rule->checkCriterias() > /usr/share/glpi/inc/rulecollection.class.php :668 > Rule->process() > /usr/share/glpi/inc/ocsserver.class.php :1523 > RuleCollection->processAllRules() > /usr/share/glpi/inc/ocsserver.class.php :1182 > OcsServer::importComputer() > /usr/share/glpi/inc/ocsserver.class.php :5649 > OcsServer::processComputer() > : OcsServer::cronOcsng() > /usr/share/glpi/inc/crontask.class.php :750 call_user_func() > /usr/share/glpi/front/cron.php :80 CronTask::launch() > /usr/share/glpi/front/cron.php > > > > > _______________________________________________ > Glpi-dev mailing list > Glpi-dev@gna.org > https://mail.gna.org/listinfo/glpi-dev > _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
