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!
Adam
March 18, 2009
Holy crap. I’ve been banging my head against the wall on this one for HOURS! Thank you!!
John
March 28, 2009
Thank you!!Thank you!!Thank you!!Thank you!!Thank you!! is very very Thank!! )))))))
Ryan
March 30, 2009
I publish my yahoo pipes feed first to feedburner, then use the feedburner feed in wp-o-matic
Felix
April 9, 2009
Thanks, this (MySQL solution) worked.
Sudar
April 14, 2009
Thank you very much for sharing this. I was breaking my head to make it work.
Sharingan
June 9, 2009
I got a bundle of problems with this plugin. Thanks for sharing this. It solves it, very effective. Now I can sleep well!! lol
DownSouth
July 5, 2009
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 !
Gary
July 13, 2009
THANK YOU! No more having to burn Pipes to Feedburner then to WP-O-Matic!
V.C
August 16, 2009
I’ve never use wp-o-matic before.
I’m using autoblogged but It works not well like I expected.
JoePongs
September 15, 2009
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!!
JoePongs
September 15, 2009
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
Legeis
September 20, 2009
How does I access the MySql database so that I can edit the campaign_feed table?
charles
December 4, 2009
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
N. Khan
February 11, 2010
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.
Joey
February 12, 2010
Man I have spent 4 hours trying to find the problem! Thanks Man,,,
Rich in Shelby County
August 7, 2010
I sure am glad you posted this article. Every few months when I have to fire up a pipes feed I refer back here for the secret. Guess wp-o-matic is never going to fix the glitch. Anyway, thanks!
erim
April 8, 2011
You are a beautiful man. I don’t know if I ever would have figured it out. I was going to give up on Pipes and WP-o-matic, but they seem like such a great match. Thanks.