Et pour corriger le problème suivant sur le networkports
SELECT `glpi_computers`.`id` FROM `glpi_computers`, `glpi_networkports`
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
Cordialement
Xavier
-----Original Message-----
From: MAILLARD Xavier
Sent: 08 September 2011 11:23
To: [email protected]
Subject: RE: [Glpi-dev] Error SQL syntax GLPI 0.80.2
Bonjour,
Essayer ceci plutôt:
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
Cordialement
Xavier
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
wolvverine
Sent: 08 September 2011 11:15
To: [email protected]
Subject: [Glpi-dev] Error SQL syntax GLPI 0.80.2
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
[email protected]
https://mail.gna.org/listinfo/glpi-dev
_______________________________________________
Glpi-dev mailing list
[email protected]
https://mail.gna.org/listinfo/glpi-dev
