When I click on ports: Whoops, looks like something went wrong. Check your librenms.log

When I click on ports I get: Whoops, looks like something went wrong. Check your librenms.log.

validate shows:

Component Version
LibreNMS 24.7.0-21-ge45dd59f7 (2024-07-26T08:26:04-05:00)
DB Schema 2024_07_19_120719_update_ports_stack_table (296)
PHP 8.1.27
Python 3.9.2
Database MariaDB 10.5.23-MariaDB-0+deb11u1
RRDTool 1.7.2
SNMP 5.9
===========================================

[OK] Composer Version: 2.7.7
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2024_07_19_120719_update_ports_stack_table). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] MySQL and PHP time match
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrd_dir is writable
[OK] rrdtool version ok

Error in log:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack where device_id = 166 and (port_id_high = 15577 or port_id_low = 15577)) {“userId”:2,“exception”:“[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ (Connection: mysql, SQL: select * from ports_stack where device_id = 166 and (port_id_high = 15577 or port_id_low = 15577)) at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)
[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘port_id_high’ in ‘where clause’ at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423)”}

When asking for help and support, please provide as much information as possible. This should include:

  • Steps to reproduce an issue.
  • The output of ./validate.php

If it’s an issue with the WebUI then please consider including a screenshot and the browser version you are using.

If you are having troubles with discovery/polling include the pastebin output of:

./discovery.php -h HOSTNAME -d | ./pbin.sh
./poller.php -h HOSTNAME -r -f -d | ./pbin.sh

If you need to post any text longer than a few lines, please use a pastebin service such as https://p.libren.ms using non-expiring pastes.

Ok sorry I may have posted early. I ran validate when issue first happened. everything check out fine. I then went ahead an ran daily.sh It ran without issue but did not fix issue. I re ran the validate and what I post in this was the new result. I made this post to forum and while waiting a response I ran the daily.sh again. This time took a little longer. When it finished it validated without warning. I can now click on ports without issue. wierd.

I’ll make a note for others. I had the same issue on 4 installations of librenms this morning. I already fixed 2 by running validate (had to fix multiple issues on one server and nothing on the second) and then ran daily.sh and that resolved it on both servers.