Forum GLPI-Project

ad_user

Member

Registered: 2012-12-27

Posts: 4

[0.84.7][sql] Unknown column `mac` in glpi_networkequipments

Hello, all. The error below appears if go to `Setup > Checks > MAC duplicates`.
Affected versions is 0.84.7, and possible down to 0.84.5.

2014-08-21 11:07:11
*** MySQL query error: 
***
SQL: SELECT mac,
                          COUNT(*) AS cpt
                   FROM `glpi_networkequipments`
                   WHERE `glpi_networkequipments`.`entities_id` IN (0)
                          AND `glpi_networkequipments`.`is_template` = \'0\'
                          AND `mac` IS NOT NULL AND `mac` <> \'\'
                   GROUP BY mac
                   ORDER BY cpt DESC
Error: Unknown column 'mac' in 'field list'
Backtrace :
.../inc/dbmysql.class.php:765          DBmysql->query()
.../inc/dbmysql.class.php:546          DBmysqlIterator->__construct()
.../inc/fieldunicity.class.php:538             DBmysql->request()
.../inc/fieldunicity.class.php:112             FieldUnicity::showDoubles()
.../inc/commonglpi.class.php:284               FieldUnicity::displayTabContentForItem()
.../ajax/common.tabs.php:71            CommonGLPI::displayStandardTab()
.../ajax/common.tabs.php

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: [0.84.7][sql] Unknown column `mac` in glpi_networkequipments

What are the criterias of your check?

---

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)

ad_user

Member

Registered: 2012-12-27

Posts: 4

Re: [0.84.7][sql] Unknown column `mac` in glpi_networkequipments

In listing "Home > Setup > Checks > Fields unicity" this rule shown with Type = "Network devices" and "Unique fields" = "MAC address".

But, if open the rule on first tab "Fields unicity", "MAC address" option are missing in "Unique fields" box.

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: [0.84.7][sql] Unknown column `mac` in glpi_networkequipments

Where is no more mac field in networkequiment.
So this checks may no work anymore.

Regards

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat