Good day.
We have faced with issue, when not loading.
Everything else works as expected. Validate.php shows one error
===========================================
| Component | Version |
|---|---|
| LibreNMS | 23.7.0-57-gde65ff55f (2023-08-04T20:30:46+03:00) |
| DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (248) |
| PHP | 8.2.6 |
| Python | 3.6.8 |
| Database | MariaDB 10.3.35-MariaDB |
| RRDTool | 1.7.0 |
| SNMP | 5.8 |
| =========================================== |
[OK] Composer Version: 2.5.8
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
Attempt to fix this issue (y or n)?:y
In Connection.php line 795:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘ports_vdsl’ already exists (Connection: mysql, SQL: create table ports_vdsl (port_id int unsigned not null, port_v dsl_updated timestamp not null default CURRENT_TIMESTAMP, xdsl2LineStatusAttainableRateDs int not null default ‘0’, xdsl2LineStatusAttainableRateUs int not null default ‘0’, xds l2ChStatusActDataRateXtur int not null default ‘0’, xdsl2ChStatusActDataRateXtuc int not null default ‘0’, xdsl2LineStatusActAtpDs decimal(8, 2) not null default ‘0’, xdsl2LineS tatusActAtpUs decimal(8, 2) not null default ‘0’) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)
In Connection.php line 580:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘ports_vdsl’ already exists
Even if i try to /lnms migrate i get error. Can you please point me, how can i fix this error? Is this error related to FDB/ARP/MAC not showing?