If you are using the WP-O-Matic plugin for Wordpress for importing content via RSS feeds, and you are wanting to use Yahoo Pipes to create a customized RSS feed or RSS mashup with WP-O-Matic you are going to run into a bug that will prevent you from getting anywhere. But don’t worry there is a fix! The problem that people are running into is that when they setup their campaign inside WP-O-Matic, the plugin is not actually retrieving any articles when you “fetch” for them. The Yahoo Pipes RSS feed just keeps coming up as “0 Posts Fetched”. But we know our RSS feed works correctly so what is the deal?
Here’s The Fix!
After your campaign is all setup and you have entered in your Yahoo Pipes RSS feed through the WP-O-Matic management interface, go check out your campaign_feed table in your MySQL database. In my case I just use PHPmyAdmin to browse to the table. Browse through the table and find your campaign that you just setup for Yahoo Pipes. You will notice that there are some unneccesary characters that have been added to your RSS url. And this is precisely what is causing the issue. In my case this is what my Yahoo Pipes URL looks like…
http://pipes.yahoo.com/pipes/pipe.run?_id=umvxn4H23RGR1FUcZcag4A&_render=rss
And this is what it looked like in the database when I checked it out…
http://pipes.yahoo.com/pipes/pipe.run?_id=umvxn4H23RGR1FUcZcag4A&_render=rss
Notice the extra characters “amp;” after the “&” in the url. All you need to do is go in and change that in your database inside your campaign_feed table and you are good to go!!! Go back and “fetch” your campaign with WP-O-Matic and the plugin will start fetching in all the articles from your Yahoo Pipes feed! It’s a small fix for now which most likely will be fixed sometime soon by the plugin developer. But in the meantime for all you who are impatient like me this is how you get the job done!
- Digg this post
- Bookmark this post on del.icio.us
- Stumble this post
- Mention on Facebook
Holy crap. I’ve been banging my head against the wall on this one for HOURS! Thank you!!
Thank you!!Thank you!!Thank you!!Thank you!!Thank you!! is very very Thank!! )))))))
I publish my yahoo pipes feed first to feedburner, then use the feedburner feed in wp-o-matic
Thanks, this (MySQL solution) worked.
Thank you very much for sharing this. I was breaking my head to make it work.
I got a bundle of problems with this plugin. Thanks for sharing this. It solves it, very effective. Now I can sleep well!! lol
Excellent ! I also have been going nuts trying to find the solution. The PHP editing was a bit too much for me – I couldn’t find the campaign_feed table and ended up going the Feedburner route, but it also works
All hail the power of sharing !
THANK YOU! No more having to burn Pipes to Feedburner then to WP-O-Matic!
I’ve never use wp-o-matic before.
I’m using autoblogged but It works not well like I expected.
Dude, i tried your instructions, and there is still no posts. In my email, i got this error. “/bin/sh: usr/bin/curl: No such file or directory”
HELP!!
By the way, i have run some feeds and working while with the pipes i cant still get the posts even if i tried your instructions. Help
How does I access the MySql database so that I can edit the campaign_feed table?
don’t forget that if you are using wpomatic with pipes go into your sql and change the table from 255 to atleast 500 or it will truncate the url feed
Chase Thank You. Problem solved.
I wonder why the developer hasn’t attended to the problem. This is Feb 2010 and the problem is over a year old.
Man I have spent 4 hours trying to find the problem! Thanks Man,,,