Validate fails and so does ./lnms migrate

[librenms@librenms ~]$ ./validate.php

Component Version
LibreNMS 24.12.0-17-gc471998ee (2025-01-01T19:07:29-05:00)
DB Schema 2024_11_22_135845_alert_log_refactor_indexes (310)
PHP 8.2.25
Python 3.9.21
Database MariaDB 10.5.22-MariaDB
RRDTool 1.7.2
SNMP 5.9.1
===========================================

[OK] Composer Version: 2.8.4
[OK] Dependencies up-to-date.
[OK] Database connection successful
[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 829:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘abilities’ already exists (Connection: mysql, SQL: create table abilities (id bigint unsigned not null a
uto_increment primary key, name varchar(255) not null, title varchar(255) null, entity_id bigint unsigned null, entity_type varchar(255) null, only_owned tinyint(

  1. not null default ‘0’, options json null, scope int null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate ‘utf8mb4_uni
    code_ci’)

In Connection.php line 587:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘abilities’ already exists

[librenms@librenms ~]$

What does php artisan migrate:status show?

Everything has a status of Ran except for these two:

2024_12_16_132537_create_bouncer_tables … Pending

2024_12_16_132537_create_push_subscriptions_table … Pending

Skip those then:

insert into migrations set migration='2024_12_16_132537_create_bouncer_tables', batch=(select max(x.batch) from migrations x)+1;
insert into migrations set migration='2024_12_16_132537_create_push_subscriptions_table', batch=(select max(x.batch) from migrations x)+1;

That worked
Thank you!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.