Validate fails and so does ./lnms migrate

[fti-fred]

[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 ~]$

[laf]

What does php artisan migrate:status show?

[fti-fred]

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

[laf]

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;

[fti-fred]

That worked
Thank you!