$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS  | 1.48.1-27-gc7c1ca2c5
DB Schema | 2020_03_25_165300_add_column_to_ports (162)
PHP       | 7.4.33
Python    | 3.8.10
MySQL     | 10.3.39-MariaDB-0ubuntu0.20.04.2
RRDTool   | 1.7.2
SNMP      | NET-SNMP 5.8
====================================

[OK]    Composer Version: 1.10.27
[OK]    Dependencies up-to-date.
[OK]    Database connection successful
[FAIL]  Time between this server and the mysql database is off
 Mysql time 2024-03-25 07:56:11
 PHP time 2024-03-25 14:56:11

[FAIL]  Your database is out of date!
        [FIX]:
        ./lnms migrate
[FAIL]  You have no timezone set for php.
        [FIX]:
        http://php.net/manual/en/datetime.configuration.php#ini.date.timezone
[WARN]  Your install is over 24 hours out of date, last update: Thu, 07 Feb 2019 20:58:56 +0000
        [FIX]:
        Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN]  Your local git contains modified files, this could prevent automatic updates.
        [FIX]:
        You can fix this with ./scripts/github-remove
        Modified Files:
         .editorconfig
         .github/ISSUE_TEMPLATE.md
         .github/ISSUE_TEMPLATE/New-Device.md
         .github/PULL_REQUEST_TEMPLATE.md
         .gitignore
         .travis.yml
         AUTHORS.md
         CONTRIBUTING.md
         LibreNMS/Alert/AlertUtil.php
         LibreNMS/Alert/Template.php
         LibreNMS/Alert/Transport.php
         LibreNMS/Alert/Transport/Alerta.php
         LibreNMS/Alert/Transport/Alertmanager.php
         LibreNMS/Alert/Transport/Api.php
         LibreNMS/Alert/Transport/Boxcar.php
          and 3569 more...
$ SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted);)
> ^C
$ ./lnms migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Migrating: 2020_04_06_001048_the_great_index_rename

In Connection.php line 671:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted);)


In PDOStatement.php line 129:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists


In PDOStatement.php line 127:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists