Start a new topic
Answered

Is it possible to clean unused artists?

Version: 14.0.16119.0


Is HMM cleaning unused artists? Is it possible to clean unused artists with some HMM functrion? Or do I need to write a clean SQL statement by myself?


The problem is, that them provoking groups in the structure for the first char. The group is empty (no full artist name as nested structure node), only the first char of artist ist visible in the structure. The artists view shows only used (>0 songs) artists.


Something like this:



 

-- Check for unused artists
SELECT	*
FROM	tblartists
WHERE	(TotalItems = 0)
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartists_x_album))
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartist_x_detail))
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartistrelations));

-- Delete unused artists
DELETE
FROM	tblartists
WHERE	(TotalItems = 0)
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartists_x_album))
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartist_x_detail))
	AND	(Artist_ID NOT IN (SELECT Artist_ID FROM tblartistrelations));

 


Best Answer

Solved with 14.0.16127.0.


@Muse: Are you a registered user and would like to test the upcoming solution before it is released?

If so, please open up a support ticket from: http://imploded.freshdesk.com/


Thanks in advance.


1 person likes this

Steps for Reproduction


1. Fresh installed HMM in a vm

2. Extended logging activated + Restarted

3. Connected to MariaDB + Restarted

4. Added an folder with only one file + Restarted

5. Backup created (helium-backup-2019-04-16 09_59_19.zip)

6. Double-clicked on the album

7. Selected the song and opened tag editor

8. Changed "Artist" to "AAA" + Clicked on OK

5. Backup created (helium-backup-2019-04-16 10_02_10.zip) + Restarted

6. Clicked on Releases, the album with right mouse key and "Remove album..." + Clicked on OK

7. Backup created (helium-backup-2019-04-16 10_04_50.zip) + Restarted


Now we have an artist in the database, that is not used anywhere.


The list of artists is empty:

image


Music explorer is showing the group, but no artist name as nested node:

image


One artist is in the database with TotalItems=0:

image


He can only be removed with the sql-statements in my post above. He is probably handled by HMM like the "Various Artists" artist.


Database: mariadb-10.3.14-winx64

Extended logging: activated

zip
zip
(108 KB)
zip
(15.8 KB)

Sorry, I have forgotten to renumber the steps. :-)


1. Fresh installed HMM in a vm

2. Extended logging activated + Restarted

3. Connected to MariaDB + Restarted

4. Added an folder with only one file + Restarted

5. Backup created (helium-backup-2019-04-16 09_59_19.zip)

6. Double-clicked on the album

7. Selected the song and opened tag editor

8. Changed "Artist" to "AAA" + Clicked on OK

9. Backup created (helium-backup-2019-04-16 10_02_10.zip) + Restarted

10. Clicked on Releases, the album with right mouse key and "Remove album..." + Clicked on OK

11. Backup created (helium-backup-2019-04-16 10_04_50.zip) + Restarted

Thanks for the update Muse. We will review this further and implement some improvement and housekeep possibilities for our next release.

 Support ticket is opened.

Answer

Solved with 14.0.16127.0.

There's no destructive way built in to remove artists.


From Helium 14 it is possible to have artists which can have zero tracks but still be artists, if they are album artists.

More information is available from here:

https://imploded.freshdesk.com/support/solutions/articles/9000164388-multiple-album-artists-in-helium-14-and-above 


You can try to execute the ""Optimize active database" from Library management to see if it helps, but if the artist is an album artist as mentioned above it might not help.


It is of course possible to try the listed SQL statements, but I would recommend you to take a backup first and then test that everything still works as expected.

Manually modifying the database is generally not recommended.

Login or Signup to post a comment