Unable to remove device

Help
1

On the latest release.

Trying to delete a device and getting a ‘Whoops’ error, looked in the logs and couldn’t see anything useful.
Attempted to delete via CLI using delhosts.php and get the following errors

In Connection.php line 671:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.availability’ doesn’t exist (SQL: delete from availabi lity where device_id = 28)

In PDOConnection.php line 66:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.availability’ doesn’t exist

In PDOConnection.php line 64:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.availability’ doesn’t exist

image
image2054×493 18.9 KB

Help is always appreciated.
Thanks

2

Hi,

./validate.php your install. It will tell you more or less the solution.

FYI: It looks like you updated the code but not the sql schema, so its trying to delete from tables that doesnt exists.