Forum GLPI-Project

Megachip

Member

Registered: 2014-05-02

Posts: 109

[addressing 2.1.0][GPLI 0.54.5]Unknown column 'glpi_networkequipments.

Cant get list of used ip adresses.

*** MySQL query error:
***
SQL: SELECT `port`.`id`,
                     \'NetworkEquipment\' AS itemtype,
                     `dev`.`id` AS on_device,
                     `dev`.`name` AS dname,
                     \'\' AS pname,
                     `glpi_ipaddresses`.`name` as ip,
                     `port`.`mac`,
                     `dev`.`users_id`,
                     INET_ATON(`glpi_ipaddresses`.`name`) AS ipnum
               FROM `glpi_networkports` port
               ***shorten for readability***
Error: Unknown column 'glpi_networkequipments.networks_id' in 'where clause'
Backtrace :
/usr/share/glpi/plugins/addressing/inc/addressing.class.php :357           DBmysql->query()
/usr/share/glpi/plugins/addressing/inc/addressing.class.php :385           PluginAddressingAddressing->compute()
/usr/share/glpi/plugins/addressing/inc/addressing.class.php :472           PluginAddressingAddressing->showReport()
/usr/share/glpi/inc/commonglpi.class.php :284              PluginAddressingAddressing::displayTabContentForItem()
/usr/share/glpi/ajax/common.tabs.php :71           CommonGLPI::displayStandardTab()
/usr/share/glpi/ajax/common.tabs.php

column exists

Last edited by Megachip (2014-05-03 14:32:05)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: [addressing 2.1.0][GPLI 0.54.5]Unknown column 'glpi_networkequipments.

Corrected: https://forge.indepnet.net/issues/4478

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Megachip

Member

Registered: 2014-05-02

Posts: 109

Re: [addressing 2.1.0][GPLI 0.54.5]Unknown column 'glpi_networkequipments.

Corrected: https://forge.indepnet.net/issues/4478

When will this released? Is there any access to dev repo/daily builds/beta versions?

Megachip

Member

Registered: 2014-05-02

Posts: 109

Re: [addressing 2.1.0][GPLI 0.54.5]Unknown column 'glpi_networkequipments.

Replaced with r170. Working.

Megachip

Member

Registered: 2014-05-02

Posts: 109

Re: [addressing 2.1.0][GPLI 0.54.5]Unknown column 'glpi_networkequipments.

After upgrading FI (0.84+1.0) the problem occured again.