• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
fusinvsnmp table naming problem (2.4.0, glpi 0.80-rc3)
#1
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
  Reply
#2
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
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
  Reply
#3
heh, ok, just my luck Wink
  Reply
#4
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!
  Reply
#5
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
  Reply
#6
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!
  Reply
#7
I have made some fixes on this last week and you will not have this error
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
  Reply
#8
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...
  Reply
#9
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
  Reply
#10
Where can I find where these queries are defined? I can't seem to track down where this is coming from....
  Reply
#11
I have began to fix but must require many fix code. I will see it tomorow
Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com
  Reply
#12
Thanks, it does appear to be working properly now.
  Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)