search

dwagon / Hostinfo

Host Information Database for Unix Sysadmins
10 stars 4 forks source link

Non-numeric keys impacted by value of numeric value in web interface #58

Closed dwagon closed 7 years ago

dwagon commented 7 years ago 
+---------+------------------------+--------------+------------+--------------+-----------+----------+----------+
| id      | value                  | origin       | createdate | modifieddate | hostid_id | keyid_id | numvalue |
+---------+------------------------+--------------+------------+--------------+-----------+----------+----------+
| ... | foo | ... | ... | ...   |     ... |       ... | NULL |
| ... | foo | ... | ... | ...   |     ... |       ... |        0 |

are coming up in the web interface as separate values.

Text interface works.

dwagon commented 7 years ago

I suspect this is caused by changing the database from postgresql to mysql and it handling null values differently.