Media not being scanned – empty sqlite_stat1 table messages in log file

Max2Play Home › Forums › Max2Play as Squeezebox (Player / Server) › Media not being scanned – empty sqlite_stat1 table messages in log file

Viewing 2 posts - 1 through 2 (of 2 total)
  • Back to forum
    Posted in: Max2Play as Squeezebox (Player / Server)
  • pjtcb premium
    8. März 2020 at 21:30 #48131

    After yet another reinstall following SD card problems, I have succeeded in installing squeezebox lite / jive lite but now I have hit another problem. I have mounted a NAS srive successfully and from a ssh session have confirmed that I can see my music files in /mnt/music but my music simply does not scan.

    I looked at the server.log file. Among the repeated messages is a ’no media found‘.

    My whole afternoon has been spent trying to resolve this.

    Help !!!

    2020-03-08 19:11:28 squeezeboxserver_safe started.
    [20-03-08 19:11:35.9419] main::init (387) Starting Logitech Media Server (v7.9.3, 1582867832, Sat
    Feb 29 05:30:28 CET 2020) perl 5.024001 – arm-linux-gnueabihf-thread-multi-64int
    [20-03-08 19:11:37.6302] Slim::Utils::SQLiteHelper::postConnect (377) Optimizing DB because of mi
    ssing or empty sqlite_stat1 table
    [20-03-08 19:11:37.7482] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions
    before DB is initialized!
    [20-03-08 19:11:38.4497] Slim::Utils::SQLiteHelper::postConnect (377) Optimizing DB because of mi
    ssing or empty sqlite_stat1 table
    [20-03-08 19:11:38.4778] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions
    before DB is initialized!
    [20-03-08 19:11:41.0962] Slim::Utils::SQLiteHelper::postConnect (377) Optimizing DB because of mi
    ssing or empty sqlite_stat1 table
    [20-03-08 19:11:41.1564] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions
    before DB is initialized!
    [20-03-08 19:11:41.9133] main::checkDataSource (1107) Warning: Schema updated or no media found i
    n the database, initiating scan.
    [20-03-08 19:11:46.1283] Slim::Utils::SQLiteHelper::postConnect (377) Optimizing DB because of mi
    ssing or empty sqlite_stat1 table
    [20-03-08 19:11:46.2547] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions
    before DB is initialized!
    pi@m2p-controller:/var/log/

    Heiner premium
    25. März 2020 at 17:58 #48264

    Hi pjtcb,

    Most likely in this case, it’s a rights or format issue for the SBS. Try adding a separate folder with just 1-2 files that have no restrictions and are just plain mp3’s or flac’s. If they are indexed correctly, you might have some sort of security measure that doesn’t work on SBS on your folder or files.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Register here