mherger wrote:
>
> If for whatever reason the version used on the old system was more
> recent than on the
> newer (the binaries come with LMS, not your OS), then the database
> created with the old installation might no longer work on the new one.
>
I was wondering about DB versions, but I thought DBD::SQLite uses it's
own embedded sqlite library, and not the one from the system.
Code:
--------------------
ldd
/opt/lms/CPAN/arch/5.26/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
linux-vdso.so.1 (0x0000007f9430f000)
libc.so.6 => /lib64/libc.so.6 (0x0000007f94035000)
/lib64/ld-linux-aarch64.so.1 (0x0000007f942e1000)
--------------------
It would be interesting if OP could
- check which DB version LMS is using (in the Web UI)
- run the following two commands:
Code:
--------------------
file /var/lib/logitechmediaserver/cache/library.db
--------------------
Code:
--------------------
echo "select sqlite_version();"|sqlite3
--------------------
which in my case shows
Code:
--------------------
$ file /var/lib/logitechmediaserver/cache/library.db
/var/lib/logitechmediaserver/cache/library.db: SQLite 3.x database, last
written using SQLite version 3022000
$ echo "select sqlite_version();"|sqlite3
3.28.0
--------------------
i.e. LMS DBD:sqlite is 3.22 (consistent with what is shown in the web
UI), while the system sqlite is 3.28
btw, notindexed seems to have been added in sqlite 3.8.0 (2013)
SW: 'Web UI for LMS'
(http://forums.slimdevices.com/showthread.php?98186-Announce-Alternative-Web-Interface-(beta))
| 'Playlist Editor / Generator'
(http://forums.slimdevices.com/showthread.php?108199-Announce-LMS-Playlist-Editor)
| 'Music Classification'
(http://forums.slimdevices.com/showthread.php?108278-Announce-Essentia-Integration-music-classification-(moods-genres-))
| 'Similar Music'
(http://forums.slimdevices.com/showthread.php?108495-Announce-LMSmusly-play-similar-music)
| 'LMSlib2go' (https://www.nexus0.net/pub/sw/lmslib2go/)
HowTos: 'build a self-contained LMS'
(http://forums.slimdevices.com/showthread.php?99648-Howto-build-a-self-contained-LMS)
| 'Ogg Opus'
(http://forums.slimdevices.com/showthread.php?107011-Howto-play-Ogg-Opus-files)
| 'Bluetooth/ALSA'
(http://forums.slimdevices.com/showthread.php?107230-Howto-Bluetooth-streaming-to-from-LMS-(ALSA-only-no-PulseAudio))
------------------------------------------------------------------------
Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808
View this thread: http://forums.slimdevices.com/showthread.php?t=110705
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
