I cleared all logs, opened the LibreNMS web page, clicked on a device, and then on ports. After that, I got this error: { Whoops, looks like something went wrong. Check your librenms.log. } If I click on a single port from the device overview on the home page, the graph and all details for that port are shown properly. However, an error appears when I click on the ‘all ports’ option. This issue did not occur before updating to LibreNMS version 24.1; it started after the update."
please check my librenms.log file logs
help me to fix this thank you in advance
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ifInBroadcastPkts_rate’ at row 1 (Connection: mysql, SQL: UPDATE ports_statistics
set ifInNUcastPkts
=0,ifInNUcastPkts_prev
=954008,ifInNUcastPkts_rate
=0,ifInNUcastPkts_delta
=0,ifOutNUcastPkts
=0,ifOutNUcastPkts_prev
=468432,ifOutNUcastPkts_rate
=0,ifOutNUcastPkts_delta
=0,ifInDiscards
=842085681,ifInDiscards_prev
=959853617,ifInDiscards_rate
=0,ifInDiscards_delta
=0,ifOutDiscards
=3068762700,ifOutDiscards_prev
=3068762700,ifOutDiscards_rate
=0,ifOutDiscards_delta
=0,ifInUnknownProtos
=0,ifInUnknownProtos_prev
=0,ifInUnknownProtos_rate
=0,ifInUnknownProtos_delta
=0,ifInBroadcastPkts
=11665630354215010465,ifInBroadcastPkts_prev
=0,ifInBroadcastPkts_rate
=2.9657144813038E+16,ifInBroadcastPkts_delta
=9223372036854775807,ifOutBroadcastPkts
=4295454208,ifOutBroadcastPkts_prev
=0,ifOutBroadcastPkts_rate
=13811749.864952,ifOutBroadcastPkts_delta
=4295454208,ifInMulticastPkts
=691489734657,ifInMulticastPkts_prev
=0,ifInMulticastPkts_rate
=2223439661.2765,ifInMulticastPkts_delta
=691489734657,ifOutMulticastPkts
=11665638208131344924,ifOutMulticastPkts_prev
=0,ifOutMulticastPkts_rate
=2.9657144813038E+16,ifOutMulticastPkts_delta
=9223372036854775807 WHERE port_id
= 53149) (Connection: dbFacile, SQL: UPDATE ports_statistics
set ifInNUcastPkts
=0,ifInNUcastPkts_prev
=954008,ifInNUcastPkts_rate
=0,ifInNUcastPkts_delta
=0,ifOutNUcastPkts
=0,ifOutNUcastPkts_prev
=468432,ifOutNUcastPkts_rate
=0,ifOutNUcastPkts_delta
=0,ifInDiscards
=842085681,ifInDiscards_prev
=959853617,ifInDiscards_rate
=0,ifInDiscards_delta
=0,ifOutDiscards
=3068762700,ifOutDiscards_prev
=3068762700,ifOutDiscards_rate
=0,ifOutDiscards_delta
=0,ifInUnknownProtos
=0,ifInUnknownProtos_prev
=0,ifInUnknownProtos_rate
=0,ifInUnknownProtos_delta
=0,ifInBroadcastPkts
=11665630354215010465,ifInBroadcastPkts_prev
=0,ifInBroadcastPkts_rate
=2.9657144813038E+16,ifInBroadcastPkts_delta
=9223372036854775807,ifOutBroadcastPkts
=4295454208,ifOutBroadcastPkts_prev
=0,ifOutBroadcastPkts_rate
=13811749.864952,ifOutBroadcastPkts_delta
=4295454208,ifInMulticastPkts
=691489734657,ifInMulticastPkts_prev
=0,ifInMulticastPkts_rate
=2223439661.2765,ifInMulticastPkts_delta
=691489734657,ifOutMulticastPkts
=11665638208131344924,ifOutMulticastPkts_prev
=0,ifOutMulticastPkts_rate
=2.9657144813038E+16,ifOutMulticastPkts_delta
=9223372036854775807 WHERE port_id
= 53149)#0 /opt/librenms/includes/polling/ports.inc.php(936): dbUpdate()
#1 /opt/librenms/LibreNMS/Modules/LegacyModule.php(114): include(‘…’)
#2 /opt/librenms/LibreNMS/Poller.php(176): LibreNMS\Modules\LegacyModule->poll()
#3 /opt/librenms/LibreNMS/Poller.php(103): LibreNMS\Poller->pollModules()
#4 /opt/librenms/app/Console/Commands/DevicePoll.php(45): LibreNMS\Poller->poll()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\DevicePoll->handle()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#11 /opt/librenms/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run()
#13 /opt/librenms/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run()
#14 /opt/librenms/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#15 /opt/librenms/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run()
#17 /opt/librenms/app/Console/Kernel.php(66): Illuminate\Foundation\Console\Kernel->handle()
#18 /opt/librenms/lnms(40): App\Console\Kernel->handle()
#19 {main}
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column ‘ifInBroadcastPkts_rate’ at row 1 (Connection: mysql, SQL: UPDATE ports_statistics
set ifInNUcastPkts
=0,ifInNUcastPkts_prev
=954008,ifInNUcastPkts_rate
=0,ifInNUcastPkts_delta
=0,ifOutNUcastPkts
=0,ifOutNUcastPkts_prev
=468432,ifOutNUcastPkts_rate
=0,ifOutNUcastPkts_delta
=0,ifInDiscards
=842085681,ifInDiscards_prev
=959853617,ifInDiscards_rate
=0,ifInDiscards_delta
=0,ifOutDiscards
=3068762700,ifOutDiscards_prev
=3068762700,ifOutDiscards_rate
=0,ifOutDiscards_delta
=0,ifInUnknownProtos
=0,ifInUnknownProtos_prev
=0,ifInUnknownProtos_rate
=0,ifInUnknownProtos_delta
=0,ifInBroadcastPkts
=11665630354215010465,ifInBroadcastPkts_prev
=0,ifInBroadcastPkts_rate
=2.9657144813038E+16,ifInBroadcastPkts_delta
=9223372036854775807,ifOutBroadcastPkts
=4295454208,ifOutBroadcastPkts_prev
=0,ifOutBroadcastPkts_rate
=13811749.864952,ifOutBroadcastPkts_delta
=4295454208,ifInMulticastPkts
=691489734657,ifInMulticastPkts_prev
=0,ifInMulticastPkts_rate
=2223439661.2765,ifInMulticastPkts_delta
=691489734657,ifOutMulticastPkts
=11665638208131344924,ifOutMulticastPkts_prev
=0,ifOutMulticastPkts_rate
=2.9657144813038E+16,ifOutMulticastPkts_delta
=9223372036854775807 WHERE port_id
= 53150) (Connection: dbFacile, SQL: UPDATE ports_statistics
set ifInNUcastPkts
=0,ifInNUcastPkts_prev
=954008,ifInNUcastPkts_rate
=0,ifInNUcastPkts_delta
=0,ifOutNUcastPkts
=0,ifOutNUcastPkts_prev
=468432,ifOutNUcastPkts_rate
=0,ifOutNUcastPkts_delta
=0,ifInDiscards
=842085681,ifInDiscards_prev
=959853617,ifInDiscards_rate
=0,ifInDiscards_delta
=0,ifOutDiscards
=3068762700,ifOutDiscards_prev
=3068762700,ifOutDiscards_rate
=0,ifOutDiscards_delta
=0,ifInUnknownProtos
=0,ifInUnknownProtos_prev
=0,ifInUnknownProtos_rate
=0,ifInUnknownProtos_delta
=0,ifInBroadcastPkts
=11665630354215010465,ifInBroadcastPkts_prev
=0,ifInBroadcastPkts_rate
=2.9657144813038E+16,ifInBroadcastPkts_delta
=9223372036854775807,ifOutBroadcastPkts
=4295454208,ifOutBroadcastPkts_prev
=0,ifOutBroadcastPkts_rate
=13811749.864952,ifOutBroadcastPkts_delta
=4295454208,ifInMulticastPkts
=691489734657,ifInMulticastPkts_prev
=0,ifInMulticastPkts_rate
=2223439661.2765,ifInMulticastPkts_delta
=691489734657,ifOutMulticastPkts
=11665638208131344924,ifOutMulticastPkts_prev
=0,ifOutMulticastPkts_rate
=2.9657144813038E+16,ifOutMulticastPkts_delta
=9223372036854775807 WHERE port_id
= 53150)#0 /opt/librenms/includes/polling/ports.inc.php(936): dbUpdate()
#1 /opt/librenms/LibreNMS/Modules/LegacyModule.php(114): include(‘…’)
#2 /opt/librenms/LibreNMS/Poller.php(176): LibreNMS\Modules\LegacyModule->poll()
#3 /opt/librenms/LibreNMS/Poller.php(103): LibreNMS\Poller->pollModules()
#4 /opt/librenms/app/Console/Commands/DevicePoll.php(45): LibreNMS\Poller->poll()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\DevicePoll->handle()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
#11 /opt/librenms/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run()
#13 /opt/librenms/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run()
#14 /opt/librenms/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#15 /opt/librenms/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run()
#17 /opt/librenms/app/Console/Kernel.php(66): Illuminate\Foundation\Console\Kernel->handle()
#18 /opt/librenms/lnms(40): App\Console\Kernel->handle()
Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. {“view”:{“view”:“/opt/librenms/resources/views/components/device-link.blade.php”,“data”:},“userId”:1,“exception”:“[object] (Spatie\LaravelIgnition\Exceptions\ViewException(code: 0): Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. at /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35)
[previous exception] [object] (Illuminate\Routing\Exceptions\UrlGenerationException(code: 0): Missing required parameter for [Route: device] [URI: device/{device}/{tab?}/{vars?}] [Missing parameter: device]. at /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Exceptions/UrlGenerationException.php:35)”}