| Description | Let imagine there are some object types having the same attribute(s) (i.e. CPU Model) in Racktables i.e (Server, Laptop & Desktop PC). In such situation a value for the attribute apearing on the "Main page: Configuration: Dictionary: Chapter 'CPU Model'" page is multiply by number of the object type this attribute appear in (in our example by 3). After tracing the problem lay in following PHP/SQL code/query (from inc/database.php - line 1979) causing the problem:
// Find the list of all assigned values of dictionary-addressed attributes, each with
// chapter/word keyed reference counters.
$query = "select uint_value, count(object_id) as refcnt " .
"from Attribute as a inner join AttributeMap as am on a.id = am.attr_id " .
"inner join AttributeValue as av on a.id = av.attr_id " .
"inner join Dictionary as d on am.chapter_id = d.chapter_id and av.uint_value = d.dict_key " .
"where a.type = 'dict' and am.chapter_id = ? group by uint_value";
break;
The first join return 3 row not 1:
mysql> SELECT * FROM Attribute AS a INNER JOIN AttributeMap AS am ON a.id = am.attr_id WHERE a.type = 'dict' AND am.chapter_id = 10004 ;
+-------+------+-----------+------------+---------+------------+
| id | type | name | objtype_id | attr_id | chapter_id |
+-------+------+-----------+------------+---------+------------+
| 10012 | dict | CPU Model | 4 | 10012 | 10004 |
| 10012 | dict | CPU Model | 50000 | 10012 | 10004 |
| 10012 | dict | CPU Model | 50001 | 10012 | 10004 |
+-------+------+-----------+------------+---------+------------+
3 rows in set (0.00 sec)
Any idea how to fix it?
(And, yes we are using Racktables to inventory boxes out of Server rooms).
|
|---|
