[SOLVED] I am attempting to subscribe to a new podcast, corrupt MM5.DB?

Get answers about the current version of MediaMonkey 5

Moderator: Gurus

ThurstonBT
Posts: 11
Joined: Wed May 09, 2012 12:23 am

[SOLVED] I am attempting to subscribe to a new podcast, corrupt MM5.DB?

Post by ThurstonBT »

I am attempting to subscribe to a new podcast (https://feeds.simplecast.com/l1ER8FMy) This is a podcast to which I have previously subscribed and unsubscribed.

1) When I enter this URL into the "Podcast subscription" dialog, in to the "Podcast URL:" field, MediaMonkey finds the URL and fills in the title "The McCarthy Report".

2) When I click "OK", MediaMonkey displays a message "You are already subscribed to this podcast".

3) Looking under "Podcasts" -> "Subscriptions", "The McCarthy Report" is not listed. This makes be suspect that a MediaMonkey's internal storage has become corrupt.

4) A search for the string "https://feeds.simplecast.com/l1ER8FMy" finds the string in the MM5.DB file.

5) Run MediaMonkey's "File" -> "Manage database" -> "Rebuild database"

6) After restarting MediaMonkey --
a) https://feeds.simplecast.com/l1ER8FMy is still in in MM5.DB
b) the podcast's name ("The McCarthy Report") still fails to appear under "Podcasts" -> "Subscriptions"
c) When I enter this URL (https://feeds.simplecast.com/l1ER8FMy) into the "Podcast subscription" dialog, in to the "Podcast URL:" field, MediaMonkey finds the URL and fills in the title "The McCarthy Report" BUT STILL displays the incorrect message "You are already subscribed to this podcast".

How do I fix MM5.DB?
Ludek
Posts: 4945
Joined: Fri Mar 09, 2007 9:00 am

Re: I am attempting to subscribe to a new podcast, corrupt MM5.DB?

Post by Ludek »

This is not because of currupted DB, but because you are really already subscribed to
https://feeds.simplecast.com/l1ER8FMy

But, probably podcast for this URL link has been renamed?
And because Title od the podcast is editable field (you can rename it as you want) then it is not updated from the feed when changed by the feed creator.

If you open you database in SQL editor you should see the Podcasts table and the podcast feed with https://feeds.simplecast.com/l1ER8FMy already sbscribed, then you should see the name of the feed associated with this URL
See PodcastName and PodcastURL in the Podcasts table to identify the podcast (e.g. in SQLiteStudio):
https://www.dropbox.com/s/gvwplym88rf7f ... 0.png?dl=0

Or run the SQL: Select * From Podcasts Where PodcastURL="https://feeds.simplecast.com/l1ER8FMy"

Alternativelly (without using SQLiteStudio) you can right-click each feed in MM5 > Edit to see the PodcastURL assiciated with the feed in MM5. Or search it by the picture in the grid.

See: https://www.dropbox.com/s/qchz69eegp8vt ... 3.png?dl=0
ThurstonBT
Posts: 11
Joined: Wed May 09, 2012 12:23 am

Re: I am attempting to subscribe to a new podcast, corrupt MM5.DB?

Post by ThurstonBT »

Excellent! Thank you, your instructions allowed me to fix the problem.
Post Reply