As you may be aware, my ISP upgraded the mySQL database hosting my main WordPress blog this past week. This led to a slowdown of blog performance, but things seem to have gotten a bit better. It’s been suggested that a complete reinstall of WordPress would likely be a good idea, and I was ready to do that this evening, but I’ve encountered some mysterious things going on with my podcast feed that may not be related to the mySQL upgrade– so I’m sharing this in case someone has insights that may help. Until I know more, I’m going to hold off on the full WordPress upgrade.
For some reason, my podcast feed has not updated in iTunes since Podcast 179 on August 13th:
As far as I know, I have not changed how I post my podcast, the Podpress plugin that I’m using with WordPress, or anything else. Something clearly has changed, however.
Now, when I view my podcast feed (burned with Feedburner) in the Safari web browser, instead of seeing the “normal” single enclosure I see a mystifyingly large number of enclosures:
As I scroll down the list of 30 podcasts, the number of enclosures gradually decreases linearly until we get to the last one, podcast 155, which has only one enclosure. Apparently, for some mystifying reason, each subsequent podcast after the first one in the feed has added the NEW podcast episode to the previous episodes. This is why by the 30th, or most recent episode, there are 30 enclosures included for each podcast:
This pattern is not, apparently, being caused by Feedburner or the settings I’ve used for Feedburner. The original RSS category feed for “podcast” which I use in Feedburner to create the feed (wfryer.wpengine.com/category/podcasts/feed) includes the same multiple enclosure problem.
Therefore, this eliminates Feedburner as the source of the problem. The source must lie with WordPress, the PodPress Plug-in, or something with the mySQL configuration of my WordPress blog. I don’t think it is mySQL related, however, because my mySQL database was updated to version 5 on August 20th, and this problem started happening earlier. I published podcast 180 on August 17th, 3 days before the mySQL upgrade.
I started noticing something was amiss when I looked at the number of downloads for my podcasts, which are reported by the PodPress plugin for WordPress. You can see in this automatically generated statistical table that with podcast 179 and previous episodes, the average number of downloads exceeded 3000.
Suddenly, starting with podcast 180, something BIG and BAD happened, because the number of downloads dropped to less than 100 for most shows. I had initially thought that maybe people were just not finding these more recent topics very interesting, but the iTunes screenshot above (first one in this post) shows that iTunes has not updated in two weeks. The feedburner statistics for my podcast channel subscribers show that iTunes only accounts for about 25% of subscriptions:
Here is the bottom line: My podcast feed is messed up, and I don’t know what has caused this. Probably the most straightforward thing to do (but this does involve a fair bit of work) is backing up my entire blog database and blog data files, and reinstalling everything from scratch. That is probably in order because of the mySQL 4 to 5 upgrade my ISP did last week. However, I’d love to know more about what has caused this multiple enclosure mystery and problem before I do, so if a configuration issue accounts for it the problem can actually be resolved. Otherwise I may configure things the same way and not resolve the problem.
Any ideas or suggestions? The heart of this mystery is why each successive podcast episode includes the new enclosure plus all the previous enclosures posted since the 30th show from the current one.
Gosh I wish this wasn’t so complicated!
Did you know Wes has published 3 eBooks, and 1 of them is available free? Check them out!
If you're trying to listen to a podcast episode and it's not working, check this status page. (Wes is migrating his podcasts to Amazon S3 for hosting.) Remember to follow Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wesley's Facebook pages for "Speed of Creativity Learning" and his eBook, "Playing with Media." Don't miss Wesley's latest technology integration project, "Mapping Media to the Common Core / Curriculum."
On this day..
- Print over WiFi to Lexmark Printer from Mac Laptop - 2013
- Helping Parents in Prison Connect with their Children - 2011
- Volunteer for #k12online10 - 2010
- Used Access 95 book, anyone? - 2010
- An iPhone-recorded International Cooking Show Episode - 2009
- Media literacy, US Presidential elections, and assertions of infanticide support - 2008
- The Children's Machine - 2006
- Farewell to a good friend - 2005
- Free PDF converters - 2005
- Cell phones in the developing world - 2005