Skip to main content

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Recent Posts
31
foobar2000 mobile / Re: Report of possible bugs
Last post by stnar -
I found the solution for MP3 files:
"Tagging" -> "MP3 tag types..." -> check only the three boxes "ID3v2", "Override ID3v2 revision:" and "v2.4".

However, this does not work with AIFF files, which nevertheless, integrate an ID3v2.4 value according to the MP3tag software. Moreover, these files are correctly indexed in Itunes and Foobar2K (Windows version).

Any idea to share so that these AIFF files are correctly indexed by Foobar2K mobile (Android)?
32
3rd Party Plugins - (fb2k) / Re: foo_truepeak True Peak Scanner
Last post by Case -
I don't have an estimate, I need to find the time. The biggest obstacle is that people want TPS to also handle HDCD, but I don't want to add any special decoders to this component. Which means I first need to finalize HDCD component so the two can interact properly.
33
Support - (fb2k) / Re: 2.24.1 crashing
Last post by Case -
The log shows SQLite error 13, which should mean that your disk is full. If that is the case you need to clear some space on the drive, but not by deleting files from foobar2000 but something else.
34
General Audio / Re: Album Art Downloader XUI
Last post by Mrakobes -
I realized very well that the Deezer was working, I read the topic and did not see such problems with others, I hope the scripts will be updated by those who understand their main 5-6 sites.
35
General Audio / Re: Album Art Downloader XUI
Last post by AlexVallat -
Sites break scripts all the time, I fix broken scripts as they are reported to me (so if people aren't using a given script, it doesn't matter if it's broken), when I get time. Scripts are all easily editable so if anyone else wants to contribute a fix those are always welcome too.

Sometimes a website just makes itself un-usable to scripts, in which case that source can no longer be used at all, sadly.
38
Movie/Multichannel audio / Re: Changing Pitch -0,1% - 4,271% (PAL/NTSC) without changing length, artefact-free
Last post by Metal-HTPC -
For movies it's the opposite. Speech gets more noticed than music. I'm not talking about the majority of course. More about the collectors and fan bases who buy high quality products on physical media. Legendary voice dubbers have a big fan base here. The so called majority doesn't buy physical media they just stream their movies and of course you can feed them with the shittiest audio and video quality anyways, they don't care.  Check out Universals Saturday Night LIVE archive on peacock. The videos are all deinterlaced, upscaled and encoded poorly and the aac 96 kb/s audio tracks have so many compression artefacts to them that it's unlistenable to my ears. This is sketch comedy mostly speach with 2.0 Stereo and later 2.0 Surround tracks. You don't do those in pisspoor 96 kb/s with the crapiest encoder? The old DVD's were a night and day difference and that was 192 AC3. Still this is all ok for the majority. 
But anyway this doesn't have anything to do with the main toppic. Just wanted to point out that the whole pitch shifting is not something for the average streaming watcher it's for the high quality product buyer who probably already bought the same movie at least 3-5 times before.
39
Support - (fb2k) / Re: 2.24.1 crashing
Last post by Air KEN -
Move the following files (folder) to your desktop:

\profile\library-v2.0 folder
\profile\metadb.sqlite" file

Run Media Library Scan "Rescan Now".

40
General - (fb2k) / SQLite Utilities DELETE help
Last post by Quetzalcoatlus -
So I am using the console in SQLite Utilities to try and remove a selection from a playlist. I think I have the query figured out, but when I change it from SELECT to DELETE I get an error "Attempt to write a read only database" I changed my foobar2000 root and the music file that is getting targeted to write compatible. I think I did it correct, but this is my first time working with SQLite.

Here is my query if that helps
Code: [Select]
WITH DuplicateTitles AS (
    SELECT title, bitrate,
           ROW_NUMBER() OVER (PARTITION BY title ORDER BY bitrate DESC) AS row_num
    FROM playlist
    WHERE playlist_name = 'TestPl'
),
MaxBitrateTracks AS (
    SELECT title, bitrate
    FROM DuplicateTitles
    WHERE row_num = 1  -- These are the tracks with the max bitrate for each title
)
DELETE FROM playlist
WHERE playlist_name = 'TestPl'
  AND title IN (SELECT title FROM MaxBitrateTracks)
  AND bitrate != (SELECT MAX(bitrate) FROM MaxBitrateTracks WHERE title = playlist.title)
  AND title IN (
    SELECT title
    FROM playlist
    WHERE playlist_name = 'TestPl'
    GROUP BY title
    HAVING COUNT(*) > 1  -- Only select duplicate titles
  );

I had ai help me write it. It seems to only be selecting the correct stuff - Duplicate titles with the lower bitrates out of the dupes. The main problem was if the highest bitrate was tied among the dupes. But I think it's working now, at the very least it's good enough.

I want to delete them from the selected playlist, hopefully this is the correct method. I DO NOT want to delete them from my library. PLEASE let me know if that is what I am trying to do.

I have absolutely no idea what I am doing and it took me about 25 minutes to find the console and help documentation for SQLite Utilities. Please let me know if I am doing something dumb thanks for any help.