Wrong collection type and no items detected [temporary]

[rabelux]

I got mms running with the precombiled binaries but experienced two minor issues.
Here is what I did:

1. Delete all existing collections (1x music and 1x video)
2. Add a music collection which is stored on an external harddrive. Symlink has been created in /mnt.
3. Do a scan for the created library

Issues:

1. Logfile says it's scanning a movie directory whereas it should be a music directory
2. Did not find any files to process

After restarting the service the issue is gone and it behaves as expected:
14:00 Scan music directory: file:/mnt/WDRed3T/Medien/SchafMusik/Surfbook, 6381 files to process

[jirihajek]

Could you try to reproduce the issues and get the complete debug log? It's Show Full Log\Debug Messages.

[rabelux]

Was able to reproduce.
MMS_Debug.txt

[LudekStoklasa]

Seems the same as reported here: https://www.mediamonkey.com/forum/viewtopic.php?p=493168#p493168
and I can replicate using these steps.

Thanks!

[LudekStoklasa]

Debugging this and the regression was cased by transition to better-sqlite3 - npm
Namely this query deletes all collections whenever the ids array length > 1 (i.e. there is more than one collection):
this.sql.getStatement('deleteCollectionsByIdList').run(ids.join(','));

Another problem is that _id column in collections table is defined as 'INTEGER PRIMARY KEY', it should be rather 'INTEGER PRIMARY KEY AUTOINCREMENT' otherwise after deleting a collection the new collection gets id of the previous collection and gets incorrectly cached data (resulting in scanning as movie collection instead of music).

[LudekStoklasa]

Fixed