Device not showing up in device page but showing up in Monitor tab

[bmfmancini]

Hey Guys

I noticed that on 1.2.12 some devices are not showing up in the device search but in Monitor the device is there
when you click on the device you are taken to its configuration page and its all filled out and even the graphs remain

You are not able to delete the device since you cannot select it

[bmfmancini]

Here is the output from the DV
I did poller sync as well no difference
I also checked to see if there was a deleted status on it no go

MariaDB [cacti]> select hostname,description,id,deleted,poller_id from host where hostname='Device_IP';
+---------------+----------------+-------+---------+-----------+
| hostname | description | id | deleted | poller_id |
+---------------+----------------+-------+---------+-----------+
| IP | Device_hostname | 10788 | | 7 |
+---------------+----------------+-------+---------+-----------+
1 row in set (0.00 sec)

In the mean time does anyone know how I can delete this device ?
Maybe insert ON in the deleted colum ?

[TheWitness]

Sort by id in the Cacti UI and look for that ID. I don't think there are any joins there. What's the status set to in the host table?

[TheWitness]

Also, check on that location bug we had in 1.2.12. Could be a jacked up location setting.

[bmfmancini]

Hey @TheWitness

I did a filter and to my surpirse it skips the ID in question !
Very strange

[TheWitness]

Edit host.php and at line ~1405 add the following:

cacti_log(str_replace("\n", ' ', str_replace("\t", '', $sql_query)));

Post the result.

[bmfmancini]

Will do sometime between today and tomorrow

Thanks !

[bmfmancini]

Here is the output

2020/07/13 15:48:09 - CMDPHP 

SELECT host.*, graphs, data_sources, CAST(IF(availability_method = 0, '0', 
IF(status_event_count > 0 AND status IN (1, 2), status_event_count*60, 
IF(UNIX_TIMESTAMP(status_rec_date) < 943916400 AND status IN (0, 3), total_polls*60, 
IF(UNIX_TIMESTAMP(status_rec_date) > 943916400, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(status_rec_date), 
IF(snmp_sysUptimeInstance>0 AND snmp_version > 0, 
snmp_sysUptimeInstance/100, UNIX_TIMESTAMP() ))))) AS unsigned) AS instate 
FROM host 
LEFT JOIN (
    SELECT host_id, COUNT(*) AS graphs 
    FROM graph_local GROUP BY host_id
) AS gl ON host.id=gl.host_id 
LEFT JOIN (
    SELECT host_id, COUNT(*) AS data_sources 
    FROM data_local 
    GROUP BY host_id
) AS dl  N host.id=dl.host_id 
WHERE (deleted = "" AND ( 
    host.hostname LIKE '%10788%' OR 
    host.description LIKE '%10788%' OR 
    host.id = '10788'
)) AND IFNULL(host.location,"") = "" 
GROUP BY host.id 
ORDER BY `description` ASC 
LIMIT 0,30

[TheWitness]

Post that again with tripple backticks so I can see it raw. When you run that on the MySQL line, do you not get any rows?

show create table host;

This filter is with location = "None" you should run:

SELECT location FROM host WHERE id = 10788;

[bmfmancini]

Fixed the comment
I will check that and get back to you

[netniV]

Some good formatting there @bmfmancini 👍

[TheWitness]

This is the problem:

AND IFNULL(host.location,"") = ""

That will be for all hosts with no location, or location 'None', which on my system I don't see.