• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

There is a bug in folder import. Details here.

Started by pjylkka, May 31, 2025, 05:58:09 PM

pjylkka


Edit:
I made a reseeks to the database about these songs. And Indeed I managed to find some of them in different folders  ???  So this post may be a fail.

Does RadioDJ do some sort of md5 checks or something during the import?
This does not explain why extending path column to 255 chars helps importing three songs more  :o


Hello.

Having v2.0.4.8 just updated. Same thing happened with earlier versions too though

I'm getting "Already exists" error for some of the files i'm importing in folder.
I am 500% of sure that these files are _not_ in database.

I just created new folder "X:\Music\Songs_2025\" where I copied 180 songs into. Then opened RadioDJ . Only 88 songs imports, for the rest it claims "File already exists".

For making this sure, I logged into HeidiSQL;
SELECT * FROM songs WHERE PATH LIKE '%2025%'
And got only 88 results.

I read from the forums that this has been made sure for making path column UNIQUE index, so I removed this UNIQUE indextag and then;
DELETE * FROM songs WHERE PATH LIKE '%2025%'
entries was deleted succesfully, and did not appear at RadioDJ either.

Then tried folder import again. Still getting "Already Exists" errors for some of the songs.

Weirdly enough, I then changed ´path´ type from utf8mb4_unique_ci to utf8_bin, and increased VARCHAR's size to 255, deleted those imported entries again - and made reimport again with RadioDJ;

Still getting "Already Exists" errors on import - but now it managed to import 91 songs.

I reverted my changes, deleted imported songs again from the database, and made new folder import - and again only 88 songs imported and getting "Already exists" errors there and there.

- There's no any funny characters in file names.
- Can't figger any similatiries in file names either that could cause this.
- Filenames are not that long. Like 30-60 chars max including path.
- All files are MP3 format.
- There's no any subfolder under X:\Music\Songs_2025\
- Only unique indexes on songs table are ID (PRIMARY KEY) and path (UNIQUE)
- Windows 7 64bit
- MariaDB 10.1 (x64)



ps. bit of a overkill this double chapcha even when I'm previewing my post lol

Kiwi

In HeidiSQL all my collation is "utf8mb4_unicode_ci" May be this has something to do with your issues as you have a different collation?

pjylkka

Quote from: Kiwi on June 02, 2025, 09:39:38 PMIn HeidiSQL all my collation is "utf8mb4_unicode_ci" May be this has something to do with your issues as you have a different collation?

Heh no, that was just a typo on my text, nice catch tho! ;)