Validate.php shows "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_locks' doesn't exist"

[ihtesham]

I have tried to upgrade my libreNMS from older version to latest version 23.10 but when I do ./lnms migrate it throws this error:

In Connection.php line 601:
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'librenms.cache_locks' doesn't exist

validate.php output:

Component | Version
--------- | -------
LibreNMS  | 23.10.0-15-gbcf700c5f (2023-10-31T18:27:21+00:00)
DB Schema | 2019_07_03_132417_create_mpls_saps_table (141)
PHP       | 8.2.9
Python    | 3.7.16
Database  | MariaDB 10.6.15-MariaDB-log
RRDTool   | 1.4.8
SNMP      | 5.7.2
===========================================

[OK]    Composer Version: 2.6.5
[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

After I enter yes to fix the issue it shows the error that librenms.cache_locks does not exist.

Anybody know How can I fix this?

[murrant]

git checkout 23.7.0
lnms migrate
git checkout master

Might do it, if not, try an older version.
You might have to ./scripts/composer_wrapper.php install --no-dev after each checkout.

[Jellyfrog]

Maybe

php artisan migrate --path=database/migrations/2020_09_24_000500_create_cache_locks_table.php