foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available? Repeat for 'Playlist table'.Did you also 'Add defaults' to the 'Playlist table' too?
First off, this is using a CUI component (library tree) so you need to be using a CUI (colums ui) config. You'd also need to familiarize yourself with using masstagger. There is a learning curve.
It's kinda useless to start explaining if you're not even using CUI. My post is to merely show you the idea and principles for you to work on.
foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available?Yes, now there are tags in the MediaLibrary table, including md5. I executed this script:
insert into Playlist_Updatable (path, playlist_name)Now I understand, that SQLite takes the list of tracks from medialibrary, I configured it too, it has status monitoring folders wich have duplicates.
select path,
'Duplicate Tracks'
from mediaLibrary
where md5 in (select md5
from mediaLibrary
group by md5
having count(*)>1
);
insert into Playlist_Updatable (path, playlist_name)But it still says "no such column: md5":
select path,
'Duplicate Tracks'
from Playlist
where playlist_index = active_playlist()
and md5 in (select md5
from Playlist
where playlist_index = active_playlist()
group by md5
having count(*)>1
);
Thank you. I tried execute both commands, but SQLite console says "SQLite Error:(1) no such column: md5"foo_sqlite comes with a bunch of default tags/columns set up by default; to add additional tags that exist in your media library go to 'File > Preferences > Media Library > SQLite viewer' and select 'MediaLibrary table', then click 'Add defaults' and 'Apply'. Does this add md5 to the list of columns available? Repeat for 'Playlist table'.
drop table if exists Playlist_Updatable;at the beginning and
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);
drop table Playlist_Updatable;at the end of your scripts and use PlaylistUpdatable instead of Playlist_Updatable. PlaylistUpdatable is now automatically created.
New Version: Biography v1.3.1
Enhancement and optimization of new features.
)drop table if exists Playlist_Updatable;
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);
insert into Playlist_Updatable (path, playlist_name)
select path,
'Duplicate Tracks'
from Playlist
where playlist_index = active_playlist()
and md5 in (select md5
from Playlist
where playlist_index = active_playlist()
group by md5
having count(*)>1
);
drop table Playlist_Updatable;
drop table if exists Playlist_Updatable;
create virtual table Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);
insert into Playlist_Updatable (path, playlist_name)
select path,
'Duplicate Tracks'
from mediaLibrary
where md5 in (select md5
from mediaLibrary
group by md5
having count(*)>1
);
drop table Playlist_Updatable;
