You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

Pages: 1

Topic closed

#1 2011-07-15 21:43:10

tsmr
GLPI-DEV
From: Rennes
Registered: 2005-08-26
Posts: 11,632
Website

[svn 0.83] sql-errors / php-errors rulecachedcollection

En testant l'import depuis le plugin j'ai :

15-07-2011 21:28 [6@P189]
Notice(8): Undefined index:  entities_id
Backtrace :
D:\OCSNG\xampp\htdocs\glpi83\inc\common.function.php:323        userErrorHandlerNormal()
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php:217        userErrorHandlerDebug()
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php:113        RuleCachedCollection->insertDataInCache()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php:4890        RuleCachedCollection->processAllRules()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php:1882        PluginOcsinventoryngOcsServer::updateSoftware()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php:1681        PluginOcsinventoryngOcsServer::updateComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php:1290        PluginOcsinventoryngOcsServer::importComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\front\ocsng.import.php:83        PluginOcsinventoryngOcsServer::processComputer()

15-07-2011 21:28 [6@P189]
*** MySQL query error :
***
SQL: INSERT INTO `glpi_rulecachesoftwares` (`old_value`, `manufacturer`, `old_entities_id`, `rules_id`, `new_value`, `version`, `new_manufacturer`, `is_helpdesk_visible`, `ignore_ocs_import`, `new_entities_id`)
              VALUES (\'Microsoft .NET Framework 1.1 Security Update (KB979906)\', \'Non déterminé\', \'\', 52 ,\'\' ,\'\' ,\'\' ,\'\' ,\'1\' ,\'\')
Error: Unknown column 'old_entities_id' in 'field list'
Backtrace :
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php :234        DBmysql->query()
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php :113        RuleCachedCollection->insertDataInCache()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :4890        RuleCachedCollection->processAllRules()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1882        PluginOcsinventoryngOcsServer::updateSoftware()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1681        PluginOcsinventoryngOcsServer::updateComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1290        PluginOcsinventoryngOcsServer::importComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\front\ocsng.import.php :83        PluginOcsinventoryngOcsServer::processComputer()
D:/OCSNG/xampp/htdocs/glpi83/plugins/ocsinventoryng/front/ocsng.import.php

Ca parle a quelqu'un ? ca vient de moi ?

Xavier Caillaud
Blog GLPI Infotel

Offline

#2 2011-07-16 18:38:18

wawa
GLPI-DEV
From: Montpellier / France
Registered: 2006-07-03
Posts: 6,019
Website

Re: [svn 0.83] sql-errors / php-errors rulecachedcollection

ta db est pas à jour on dirait smile

Offline

#3 2011-07-17 09:44:14

tsmr
GLPI-DEV
From: Rennes
Registered: 2005-08-26
Posts: 11,632
Website

Re: [svn 0.83] sql-errors / php-errors rulecachedcollection

oups je vais vérifier.

Par contre dans glpi-0.83-empty.sql y a pas les 2 nouveaux champs tongue

Xavier Caillaud
Blog GLPI Infotel

Offline

#4 2011-07-17 09:59:53

tsmr
GLPI-DEV
From: Rennes
Registered: 2005-08-26
Posts: 11,632
Website

Re: [svn 0.83] sql-errors / php-errors rulecachedcollection

Apres update db et correction de ma classe ocsserver, j'ai encore :

SQL: SELECT *
              FROM `glpi_rulecachesoftwares`
              WHERE  `old_value` = \'Microsoft Windows XP Professional\' AND  `manufacturer` = \'Microsoft Corporation\' AND  `old_entities_id` = \'1\'
Error: Unknown column 'old_entities_id' in 'where clause'
Backtrace :
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php :183        DBmysql->query()
D:\OCSNG\xampp\htdocs\glpi83\inc\rulecachedcollection.class.php :104        RuleCachedCollection->checkDataInCache()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :4902        RuleCachedCollection->processAllRules()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1887        PluginOcsinventoryngOcsServer::updateSoftware()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1686        PluginOcsinventoryngOcsServer::updateComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\inc\ocsserver.class.php :1295        PluginOcsinventoryngOcsServer::importComputer()
D:\OCSNG\xampp\htdocs\glpi83\plugins\ocsinventoryng\front\ocsng.import.php :83        PluginOcsinventoryngOcsServer::processComputer()
D:/OCSNG/xampp/htdocs/glpi83/plugins/ocsinventoryng/front/ocsng.import.php

Xavier Caillaud
Blog GLPI Infotel

Offline

#5 2011-07-17 10:19:58

wawa
GLPI-DEV
From: Montpellier / France
Registered: 2006-07-03
Posts: 6,019
Website

Re: [svn 0.83] sql-errors / php-errors rulecachedcollection

ok  et maintenant ?

Offline

#6 2011-07-17 14:47:25

tsmr
GLPI-DEV
From: Rennes
Registered: 2005-08-26
Posts: 11,632
Website

Re: [svn 0.83] sql-errors / php-errors rulecachedcollection

imppec. Plus d'erreurs.

Xavier Caillaud
Blog GLPI Infotel

Offline

Pages: 1

Topic closed

Board footer

Powered by FluxBB