I've just moved my music library to a new, dedicated user on my home
server to separate it from my general documentation comvection, i.e. it
was moved from the 'av' user at /home/av/music to the 'music' user at
/home/music/albums.

The server is running Fedora 28 x86_64 with the latest stable copy of
logitechmediaserver-7.9.1-1.noarch.rpm installed. Everything else on
the server was also updated today.

I've reconfigured LMS to look for music in /home/music/albums, but
attempts to rebuild the music index from scratch all show:

Library Statistics
                        Total Tracks:  0
                        Total Albums:  0                
                        Total Artists: 0
                        Total Genres:  0
                        Total Playing Time: 0:00:00
                
Media Scan Details
        Building full text index (7 of 7) Complete  00:00:00
        Database Optimize        (2 of 2) Complete  00:00:01
        The server has finished scanning your media library. 
        Total Time:00:00:01 (2019/02/15 Friday / 18.26.34)

and /var/log/squeezeboxserfer/server.log  shows:

[19-02-15 16:44:14.1860] Slim::Utils::SQLiteHelper::postConnect (374)
    Optimizing DB because of missing or empty sqlite_stat1 table
[19-02-15 16:44:14.2915] Slim::Schema::forceCommit (2149) 
    Warning: Trying to commit transactions before DB is initialized!
 
So, questions:

- where should the sqlite stat1 table be? 

  The LMS-related tables are all in /home/squeezeboxserver/cache/ 
  and were updated, but there is nothing called sqlite_stat1 
  anywhere in the filing system.

- how can I force LMS to reinitialise the database and create an
  sqlite_stat1 table?


Martin





_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Reply via email to