Forums FusionInventory
fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - Printable Version

+- Forums FusionInventory (https://forum.fusioninventory.org)
+-- Forum: English (https://forum.fusioninventory.org/forumdisplay.php?fid=3)
+--- Forum: FusionInventory for GLPI - BETA Test (https://forum.fusioninventory.org/forumdisplay.php?fid=12)
+--- Thread: fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) (/showthread.php?tid=330)



fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-03

I'm running into this:

Error: Unknown column 'glpi_plugin_fusinvsnmp_models_id.name' in 'field list'

It looks like there are quite a few references to glpi_plugin_fusinvsnmp_models_id in hook.php, but the table does not exist in the database...


*** MySQL query error :
***
SQL: SELECT `glpi_networkequipments`.`entities_id`, `glpi_networkequipments`.`is_recursive`, `glpi_networkequipments`.`name` AS ITEM_0,
`glpi_networkequipments`.`id` AS ITEM_0_2, `glpi_entities`.`completename` AS ITEM_1,
`glpi_entities`.`id` AS ITEM_1_2, `glpi_manufacturers`.`name` AS ITEM_2, `glpi_networkequipments`.`serial` AS ITEM_3, `glpi_networkequipmenttypes`.`name` AS ITEM_4, `glpi_networkequipmentmodels`.`name` AS ITEM_5, `glpi_networkequipmentfirmwares`.`name` AS ITEM_6, `glpi_networkequipments`.`date_mod` AS ITEM_7, `glpi_plugin_fusinvsnmp_models_id`.`name` AS ITEM_8,
`glpi_plugin_fusinvsnmp_models_id`.`id` AS ITEM_8_2, `glpi_networkequipments`.`id` AS id FROM `glpi_networkequipments`LEFT JOIN `glpi_entities`
ON (`glpi_networkequipments`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_manufacturers`
ON (`glpi_networkequipments`.`manufacturers_id` = `glpi_manufacturers`.`id`
)LEFT JOIN `glpi_networkequipmenttypes`
ON (`glpi_networkequipments`.`networkequipmenttypes_id` = `glpi_networkequipmenttypes`.`id`
)LEFT JOIN `glpi_networkequipmentmodels`
ON (`glpi_networkequipments`.`networkequipmentmodels_id` = `glpi_networkequipmentmodels`.`id`
)LEFT JOIN `glpi_networkequipmentfirmwares`
ON (`glpi_networkequipments`.`networkequipmentfirmwares_id` = `glpi_networkequipmentfirmwares`.`id`
) LEFT JOIN glpi_plugin_fusinvsnmp_networkequipments ON (glpi_networkequipments.id = glpi_plugin_fusinvsnmp_networkequipments.networkequipments_id) LEFT JOIN glpi_plugin_fusinvsnmp_models ON (glpi_plugin_fusinvsnmp_networkequipments.plugin_fusinvsnmp_models_id = glpi_plugin_fusinvsnmp_models.id) WHERE `glpi_networkequipments`.`is_deleted` = \'0\' AND `glpi_networkequipments`.`is_template` = \'0\' ORDER BY ITEM_0 ASC LIMIT 0, 15
Error: Unknown column 'glpi_plugin_fusinvsnmp_models_id.name' in 'field list'
Backtrace :
/var/www/glpi/inc/search.class.php :719 DBmysql->query()
/var/www/glpi/inc/search.class.php :49 Search:ConfusedhowList()
/var/www/glpi/front/networkequipment.php :43 Search:Confusedhow()
/var/www/glpi/front/networkequipment.php


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - ddurieux - 2011-05-03

We are updating DB, code upgrade plugins, etc... since this morning, so you will have some bugs for 1 or 2 next days :p and probably need reinstall the plugins


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-03

heh, ok, just my luck Wink


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-09

I'm still seeing the same error with the incorrect table name. Is there somewhere in the code I can quickly fix it on my side for now? Or should the table be renamed? I'm trying to get a demo up and we need some of the features in GLPI 0.80...

I've also found two other problems in the installation scripts:

Code:
*** MySQL query error :
***
SQL: SELECT `glpi_networkports`.`id` as nid FROM `glpi_networkports`
         LEFT JOIN `glpi_plugin_fusioninventory_unknowndevices`
            ON `glpi_plugin_fusioninventory_unknowndevices`.`id` = `glpi_networkports`.`items_id`
         WHERE `itemtype`=\'PluginFusioninventoryUnknownDevice\'
            AND `glpi_plugin_fusioninventory_unknowndevices`.`id` IS NULL
Error: Table 'glpi.glpi_plugin_fusioninventory_unknowndevices' doesn't exist
Backtrace :
/var/www/glpi/plugins/fusioninventory/install/install.php :105             DBmysql->query()
/var/www/glpi/plugins/fusioninventory/hook.php :124                pluginFusioninventoryInstall()
/var/www/glpi/inc/plugin.class.php :531            plugin_fusioninventory_install()
/var/www/glpi/front/plugin.php :56         Plugin->install()
/var/www/glpi/front/plugin.php

the above works now, but it did throw an error during installation

The second one:

Code:
*** MySQL query error :
***
SQL:

## INSERT
## glpi_displaypreferences
INSERT INTO `glpi_displaypreferences` (`id`, `itemtype`, `num`, `rank`, `users_id`)
   VALUES (NULL,\'PluginFusioninventoryAgent\', \'2\', \'1\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'4\', \'2\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'5\', \'3\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'6\', \'4\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'7\', \'5\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'8\', \'6\', \'0\'),
          (NULL,\'PluginFusioninventoryAgent\', \'9\', \'7\', \'0\'),

          (NULL, \'PluginFusioninventoryUnknownDevice\', \'2\', \'1\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'4\', \'2\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'3\', \'3\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'5\', \'4\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'7\', \'5\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'10\', \'6\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'11\', \'7\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'18\', \'8\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'14\', \'9\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'15\', \'10\', \'0\'),
          (NULL, \'PluginFusioninventoryUnknownDevice\', \'9\', \'11\', \'0\'),

          (NULL, \'PluginFusioninventoryTask\', \'2\', \'1\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'3\', \'2\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'4\', \'3\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'5\', \'4\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'6\', \'5\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'7\', \'6\', \'0\'),
          (NULL, \'PluginFusioninventoryTask\', \'30\', \'7\', \'0\'),

          (NULL,\'PluginFusinvsnmpIPRange\', \'2\', \'1\', \'0\'),
          (NULL,\'PluginFusinvsnmpIPRange\', \'3\', \'2\', \'0\'),
-         (NULL,\'PluginFusinvsnmpIPRange\', \'4\', \'3\', \'0\'),

          (NULL,\'PluginFusioninventoryTaskjob\', \'1\', \'1\', \'0\'),
          (NULL,\'PluginFusioninventoryTaskjob\', \'2\', \'2\', \'0\'),
          (NULL,\'PluginFusioninventoryTaskjob\', \'3\', \'3\', \'0\'),
          (NULL,\'PluginFusioninventoryTaskjob\', \'4\', \'4\', \'0\'),
          (NULL,\'PluginFusioninventoryTaskjob\', \'5\', \'5\', \'0\')
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 '-         (NULL,'PluginFusinvsnmpIPRange', '4', '3', '0'),

there's a hyphen that shouldn't be there in column 1 on about line 34.

thanks!


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-11

Actually, I can't seem to find any reference to glpi_plugin_fusinvsnmp_models_id in the code, so I guess it is either buried in a variable somewhere or in the db somewhere. The only place I do find a direct reference to it in the entire glpi directory tree is in the sql error log.

This error is completely breaking the network equipment page in GLPI


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-18

It looks like this is preventing the snmp inventory from running as well. If there is a temporary workaround, or you can give me some advice as to where to look to fix this, I'd appreciate it...

Thanks!


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - ddurieux - 2011-05-18

I have made some fixes on this last week and you will not have this error


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-18

still getting the same error. I've completely removed the plugin and re-installed it using the procedure on the download page for 2.4.0...


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-24

I pulled version 2.4.0 again this morning after yesterdays update, and I'm still getting the same error:


*** MySQL query error :
***
SQL: SELECT `glpi_networkequipments`.`entities_id`, `glpi_networkequipments`.`is_recursive`, `glpi_networkequipments`.`name` AS ITEM_0,
`glpi_networkequipments`.`id` AS ITEM_0_2, `glpi_entities`.`completename` AS ITEM_1,
`glpi_entities`.`id` AS ITEM_1_2, `glpi_manufacturers`.`name` AS ITEM_2, `glpi_networkequipments`.`serial` AS ITEM_3, `glpi_networkequipmenttypes`.`name` AS ITEM_4, `glpi_networkequipmentmodels`.`name` AS ITEM_5, `glpi_networkequipmentfirmwares`.`name` AS ITEM_6, `glpi_networkequipments`.`date_mod` AS ITEM_7, `glpi_plugin_fusinvsnmp_models_id`.`name` AS ITEM_8,
`glpi_plugin_fusinvsnmp_models_id`.`id` AS ITEM_8_2, `glpi_networkequipments`.`id` AS id FROM `glpi_networkequipments`LEFT JOIN `glpi_entities`
ON (`glpi_networkequipments`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_manufacturers`
ON (`glpi_networkequipments`.`manufacturers_id` = `glpi_manufacturers`.`id`
)LEFT JOIN `glpi_networkequipmenttypes`
ON (`glpi_networkequipments`.`networkequipmenttypes_id` = `glpi_networkequipmenttypes`.`id`
)LEFT JOIN `glpi_networkequipmentmodels`
ON (`glpi_networkequipments`.`networkequipmentmodels_id` = `glpi_networkequipmentmodels`.`id`
)LEFT JOIN `glpi_networkequipmentfirmwares`
ON (`glpi_networkequipments`.`networkequipmentfirmwares_id` = `glpi_networkequipmentfirmwares`.`id`
) LEFT JOIN glpi_plugin_fusinvsnmp_networkequipments ON (glpi_networkequipments.id = glpi_plugin_fusinvsnmp_networkequipments.networkequipments_id) LEFT JOIN glpi_plugin_fusinvsnmp_models ON (glpi_plugin_fusinvsnmp_networkequipments.plugin_fusinvsnmp_models_id = glpi_plugin_fusinvsnmp_models.id) WHERE `glpi_networkequipments`.`is_deleted` = \'0\' AND `glpi_networkequipments`.`is_template` = \'0\' ORDER BY ITEM_0 ASC LIMIT 0, 15
Error: Unknown column 'glpi_plugin_fusinvsnmp_models_id.name' in 'field list'
Backtrace :
/var/www/glpi/inc/search.class.php :719 DBmysql->query()
/var/www/glpi/inc/search.class.php :49 Search:ConfusedhowList()
/var/www/glpi/front/networkequipment.php :43 Search:Confusedhow()
/var/www/glpi/front/networkequipment.php


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-05-26

Where can I find where these queries are defined? I can't seem to track down where this is coming from....


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - ddurieux - 2011-05-26

I have began to fix but must require many fix code. I will see it tomorow


fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3) - entr04y - 2011-06-02

Thanks, it does appear to be working properly now.