This repository was archived by the owner on Sep 8, 2021. It is now read-only.
This repository was archived by the owner on Sep 8, 2021. It is now read-only.
Database Consistency - "Files whose path does not match their music folder path" #1641
Description
Problem description
I have a question about the newly added section "About Airsonic Internals". In the "Database Consistency" area, there is a point called "The media file database contains files whose path does not match their music folder path. Examples are below.":
The media file database contains files whose path does not match their music folder path. Examples are below.
--
Number of media files with music folder mismatch | 89223
ID | PATH | FOLDER
20 | X:\daten_0\-.mp3\-.gelaber\-.comedy.und.lustiges | X:\daten_0\-.mp3\-.gelaber
21 | X:\daten_0\-.mp3\-.gelaber\-.einzelnes\einzeller.1.mp3 | X:\daten_0\-.mp3\-.gelaber
22 | X:\daten_0\-.mp3\-.gelaber\-.einzelnes | X:\daten_0\-.mp3\-.gelaber
23 | X:\daten_0\-.mp3\-.gelaber\-.hoerspiele.und.hoerbuecher | X:\daten_0\-.mp3\-.gelaber
24 | X:\daten_0\-.mp3\-.gelaber\-.kabarett | X:\daten_0\-.mp3\-.gelaber
25 | X:\daten_0\-.mp3\-.gelaber\-.podcasts | X:\daten_0\-.mp3\-.gelaber
26 | X:\daten_0\-.mp3\-.gelaber\-.comedy.und.lustiges\badesalz | X:\daten_0\-.mp3\-.gelaber
27 | X:\daten_0\-.mp3\-.gelaber\-.comedy.und.lustiges\die.aerzte.-.maenner.haben.kein.gehirn | X:\daten_0\-.mp3\-.gelaber
28 | X:\daten_0\-.mp3\-.gelaber\-.comedy.und.lustiges\helge.schneider | X:\daten_0\-.mp3\-.gelaber
29 | X:\daten_0\-.mp3\-.gelaber\-.comedy.und.lustiges\jan.off\wdr5.streng.oeffentlich!.vom.16.02.2003.mp3 | X:\daten_0\-.mp3\-.gelaber
"...and 89.213 more."
Are these some orphaned database entries? I have a bunch of folders that I renamed or moved to other subfolders. Perhaps that's the reason for this.
Is there a possibility to clean up the database to fix this mismatching entrys without installing airsonic from scratch?
Steps to reproduce
Open up the "About Airsonic Internals"- page.
System information
- Airsonic version: 10.6.1
- Operating system: Windows Server 2019 Standard Version 1809
- Java version: Version 8 Update 251 (Build 1.8.0_251-b08)
- Proxy server: None
- Client: Opera GX LVL1 (core: 67.0.3575.130)
- Language: German
Below some Screenshots of the "About Airsonic Internals" Page: