Library scanner ignores files on Linux

[mixxxbot]

Reported by: amusing-random-alias
Date: 2018-06-06T17:13:56Z
Status: New
Importance: Low
Launchpad Issue: lp1775438
Tags: database, library, missing, path, sqlite

---

(As initially reported in the forums*

Library folder scanning ihgnores certain paths in the Linux release of Mixxx 2.1.
The bug does not occur when using Mixxx 2.1 in Windows 10.

OS: Arch Linux as of 2018/06/02, all required packages installed and up to date.
Mixxx version: Mixx 2.1.0-1 (package build date: 2018-05-20 10:02 UTC**)
Music files (mp3, m4a) are located on a USB drive
Mounted drive permissions: My user is the owner with read and write permissions, but every other user may also read and write

Steps taken:

1. Purged complete library, added library anew

More information:

Paths to the music files are either
"/run/media/[User]/Music/[Artist]/[Year] - [Album]/[Song].mp3"
or
"/run/media/[User]/Music/[Folder name]/[Song].m4a"

Mixxx' library scanner ignores the first path, but correctly scans the second.
However, when starting up, I can see the scanner run through the folders whose contents are not picked up.

A follow-on post*** says the following:

"Have the same problem in 2.0 and 2.1 as well. Fixed it by doing this query against the SQLite database:

update track_locations set fs_deleted = replace (fs_deleted, 1, 0);

2.1 seemed to like this permanently. 2.0 likes it, but if I do library rescan, mysteriously labels the same selection of tracks as "missing". So I have a copy of the database with a complete library, and don't rescan before the performance."

https://mixxx.org/forums/viewtopic.php?f=3&t=11894

**
Package site link: https://www.archlinux.org/packages/community/x86_64/mixxx/
In the AL archive: https://archive.archlinux.org/packages/m/mixxx/

---

https://mixxx.org/forums/viewtopic.php?f=3&t=11894#p38633

[mixxxbot]

Commented by: Pegasus-RPG
Date: 2018-06-07T15:09:00Z

---

Are the spaces in the first path part of the problem? (Are we correctly escaping the paths?)

[mixxxbot]

Commented by: amusing-random-alias
Date: 2018-06-07T16:58:53Z

---

If spaces were indeed a problem, the issue would also occur on the Windows version of Mixx, since every path type contains some.

And don't get confused by the differing file types in the path examples. These only indicate at what level a file is located.

[mixxxbot]

Commented by: uklotzde
Date: 2020-01-09T14:00:17Z

---

Probably fixed: #2321

[mixxxbot]

Duplicate of #9773