How does one run sql queries if the container doesn't start? (rebuild failed)

After booting up, I was able to find all duplicate tags with Data Explorer plugin:

SELECT name, count(*)
    FROM tags 
    GROUP BY name
     HAVING count(*) > 1

For some reasons, there were about ten duplicate tags. Wonder why and how those appear there in the first place

Managed to wipe those sucker out, removed the version lock from yml file, rebuild, things looks fine now.

Thank you!

:+1:

5 Likes