IT IS HERE! Get Smashing Node.JS on Amazon Kindle today!
Show Posts
← Back to homepage

WP-o-Matic makes autoblogging a snap by automatically creating posts from the RSS/Atom feeds you choose, which are organized into campaigns.

Features

WP-o-Matic aims to provide a very wide range of features. Currently, these are:

  • Campaigs Feeds and all settings and options are now organized into campaigns for the perfect organization and comfort.
  • Multiple feeds / categories: it’s possible to add as many feeds as you want, and add them to as many categories as you want. It’s not obstrusive, so you can also write your own posts to any of those categories.
  • Every form of XML syndication supported. This includes RSS 0.91 and RSS 1.0 formats, the popular RSS 2.0 format, and the emerging Atom.
  • Feed autodiscovery, which lets you add feeds without even knowing the exact URL. (Thanks Simplepie!)
  • Unix cron and WordPress cron jobs For maximum performance, you can make the RSS fetching process be called by a Unix cron job, or simply let WordPress handle it.
  • Comfortable interface. The admin is powered by a state of the art ajaxy interface that lets you handle your feeds with ease. Updated!
  • Images caching for extreme performance and hotlinking bypassing.
  • Words Rewriting. Want to replace the word “Poker” with “Texas Holdem”? We have it covered. Want to use regular expressions? We have it covered.
  • Words Relinking. Define custom links for words you specify.
  • Post templating. Define a global header and footer for the posts, or even for a specific feed. Add ads
  • Campaigns import/export using OPML files. Easily import hundreds of feeds into new or existing campaigns!

Upcoming features

  • Improved export (to include campaign options, with an extended OPML)
  • Image thumbnailing
  • Improved importing with drag and drop
  • Advanced templates
  • Advanced filters




Known bugs

  • No Internet Explorer in RC1
  • Missing help files

FAQ

How do I link to the original site/article?

Use the post template feature (example: {content} <p><a href={permalink}>Link to the original site</a></p>)

Why isn’t the full article showing?

Because the site is only syndicating excerpts, not full content

Download

Click here to download WP-o-Matic 1.0RC3.

As this is a release candidate, bugs still can be expected. Note: every time WP-o-Matic is deactivated, tables are removed. This will only happen with RC releases.

WP-o-Matic is released under the MIT license.

Installation Instructions

Unzip wp-o-matic.zip in wp-content/plugins/ and enable it. A message will warn you to verify SimplePie is compatible with your setup. Follow the link in the box to do so.

Upgrading

Once WP-o-Matic reaches 1.0Stable, you’ll be able to update without rewriting tables. For now, uninstall any previous version of WP-o-Matic (make sure tables go away) and install the latest version.

Credits

WP-o-Matic makes use of the wonderful Simplepie library for the feeds parsing. Without Simplepie it’d be virtually impossible to provide reliable support for a variety of feed types and versions.

Report bugs

Please report bugs by creating tickets in the Issue Tracker

1,333 Comments

Terrell said

Thanks for the update, but when I go to activate the plugin, I recieve a message saying “Plugin could not be activated because it triggered a fatal error.” I have wordpress 2.2

dan said

downloaded.
thanks for this great plugin man!

Guillermo Rauch said

@Terrell
Are you using WordPress 2.2.2? What version are you using exactly?

Mozzer said

Hi and thanks for the plugin.

I’m using WordPress 2.2.2 and I have this message too : “Plugin could not be activated because it triggered a fatal error”.

dan said

i got the same error as terrell. i use wp 2.2.2

Mar said

Thanks you G:
Quick tested and many problem:

php4 wp2.2.2
“plugin could not be activated because it triggered a fatal error.”

php5 wp2.2.2 can activate but:
Add campaign/categories no cageory show and can’t Quick add any.
Rewrite not show any form. and link not working.(popup windows say: Help file not found )

fucc said

Same for me: “plugin could not be activated because it triggered a fatal error.”

Vincent said

“Plugin could not be activated because it triggered a fatal error.”

Running WP 2.2.2

Ziegler said

“php5 wp2.2.2 can activate but:
Add campaign/categories no cageory show and can’t Quick add any.
Rewrite not show any form. and link not working.(popup windows say: Help file not found )
…”

I have the same problem

NI-LIMITS said

We’re using WP 2.1.1 and got the following:
“Plugin could not be activated because it triggered a fatal error.”

WordPress 2.2.2, PHP 5.2

I’ve installed, activated and everything seem to be working fine, but for a couple of issues:

1) At the plugin’s dashboard, I see the messsage:

——-
Your WP-o-Matic version is… up-to-date!
Warning: Cannot modify header information – headers already sent by (output started at /home/gbee/public_html/wp-content/plugins/wpomatic/wpomatic.php:1348) in /home/gbee/public_html/wp-content/plugins/wpomatic/wpomatic.php on line 1349
2) No matter what I try, filtering with Regex always sends back the error message:
——-

I don’t know if this is with the plugin or something from my end. I simply unzipped and uploaded it. I swear I didn’t touch any file :-)

2) No matter what I try, filtering by regex always cry foul with the message:

—–
The following errors have been encountered:
* Rewrites: There’s an error with the supplied RegEx expression
—–

I’m trying to strip out all linked tags that are appended to a one-sentence-ish feed I’m fetching for a personal WAP-only site. [I mean I want to strip out linked text, not just the hyperlink]. Any help on the proper regex to use would be most appreciated.

3) As some people have pointed out already, some of the help links don’t work. They turn out “file not found” errors.

I’m still playing with it, and will write back if I discover something else. Thanks for the great work.

RV said

Do I need to uninstall the earlier version before I upload the new one? I just uploaded over the old version and I see no difference so far.

Guillermo Rauch said

- It seems there’s a PHP4-only fatal error I need to look into.
- There’s been a category bug carried from previous versions I need to look into

The missing help files is a known issue. I’m too lazy to write them all (for now)

Thanks for feedback

paul said

Is this working yet?

Guillermo Rauch said

I’ve just updated it.

Thanks for the feedback guys. Keep it coming

Ziegler said

“php5 wp2.2.2 can activate but:
Add campaign/categories no cageory show and can’t Quick add any.
Rewrite not show any form. and link not working.(popup windows say: Help file not found )
…”

I have the same problem

Just try to open the site with firefox, the problem fixed.
So anyone have the same problem, just try firefox.
Cheers

Guillermo Rauch said

I forgot to mention that.
I can’t test with anything but Safari / Firefox lol

-G said

Whoa! I just ran the plugin and after putting in an RSS Feed and doing the fetch my WordPress went haywire, and gave me about a hundred lines of stuff like this:

WordPress database error: [MySQL server has gone away]
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND post_name = ‘5d30e_ads’ AND category_id IN (0) AND (post_type = ‘post’) GROUP BY wp_posts.ID ORDER BY post_date DESC

WordPress database error: [MySQL server has gone away]
SELECT cat_ID, category_nicename, category_parent FROM wp_categories WHERE category_nicename = ‘cache’

WordPress database error: [MySQL server has gone away]
SELECT cat_ID, category_nicename, category_parent FROM wp_categories WHERE category_nicename = ‘cache’

WordPress database error: [MySQL server has gone away]
SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID) WHERE 1=1 AND post_name = ‘5d30e_ads’ AND category_id IN (0) AND (post_type = ‘post’) GROUP BY wp_posts.ID ORDER BY post_date DESC

patrecord said

thx for plugin….i install and activate it but when i go to wpomatic page i have empty page:((

Guillermo Rauch said

@patrecord

WP version? PHP version?

patrecord said

PHP 4.3.2 or higher 4.4.7
XML Enabled Enabled
PCRE Enabled Enabled
cURL 7.10.5 or higher 7.12.1
Zlib Enabled Enabled
mbstring Enabled Disabled
iconv Enabled Disabled

patrecord said

sorry…wp 2.2.1

Guillermo Rauch said

@patrecord
Are you using the very last version of WP-o-Matic (the updated RC1) ?

patrecord said

yes…. WP-o-Matic 1.0RC1.

Guillermo Rauch said

@patrecord
Currently it is 1.0RC1-2, check the $version variable in wpomatic.php.

patrecord said

yes is this…..

var $version = ’1.0RC1-2′;

thx

Hiren said

it’s working for me!!

Thanks Guillermo.

Guillermo Rauch said

Maybe your host hides php errors? I need as much info as you can give me.
Please add this line to the top of wpomatic.php, right after

ini_set(‘display_errors’, true);

And then F5.

patrecord said

nothing change….every empty page

I got a emty page to….

Guillermo Rauch said

@Mattias, @patrecord
I wish I could help you but I can’t solve it by osmosis.

Guillermo Rauch said

If you want, you can email me the ftp details (through the contact form), if you want Guillermo himself to try to find the problem.

patrecord said

thx to Guillermo:)

Guillermo Rauch said

The ones getting a white page… it’s because of a i18n issue (meaning you’re using WordPress in a language different from English)

I’m fixing it now thanks to @Mattias test server =D

Who Am I said

Hi there!
Thanks for all your hard work.

You might want to take a look at the “use feed date” option; it doesn’t seem to be working for me.

Guillermo Rauch said

@Who Am I

The ‘use feed date’ option is a little tricky. It still has to be tested because it’s hard to implement. For example, the feed has to include the GMT Timezone offset it’s in, and many feeds don’t do this.

If this happens, it might result in a post to be scheduled in the ‘future’… which is not a nice thing.

This feature will definitely be improved for the stable version, but it can’t work on all scenarios.

Terrell said

The new update seem to be working, thanks. I want to let you know that inside the dashboard under the “WP-O-Matic Version” title there is a message “WP-o-Matic Version

Your WP-o-Matic version is… up-to-date!
Warning: Cannot modify header information – headers already sent by (output started at /home/afinance/public_html/wp-content/plugins/wpomatic/wpomatic.php:1343) in /home/afinance/public_html/wp-content/plugins/wpomatic/wpomatic.php on line 1344″

Guillermo Rauch said

@Matias, @patrecord
Updated WP-o-Matic for you. Give it a shot.

Zalaki said

I also am getting the same error as the guy above :s

Guillermo Rauch said

@Zalaki
With RC1-3?

Zalaki said

I tried to use a feed and got this error also:

Warning: uniqid() expects at least 1 parameter, 0 given in /home/*******/public_html/playstationlove/wp-content/plugins/wpomatic/wpomatic.php on line 574

Fatal error: Call to undefined function: file_put_contents() in /home/******/public_html/playstationlove/wp-content/plugins/wpomatic/wpomatic.php on line 580

Zalaki said

and yes with latest version

Guillermo Rauch said

@Zalaki
I fixed your latest error. Please paste the first one as well. Thanks!

Zalaki said

First Error

this is right when you click in options Wp-o-matic

WP-o-Matic Version

Your WP-o-Matic version is… up-to-date!
Warning: Cannot modify header information – headers already sent by (output started at /home/*******/public_html/playstationlove/wp-content/plugins/wpomatic/wpomatic.php:1336) in /home/***********/public_html/playstationlove/wp-content/plugins/wpomatic/wpomatic.php on line 1337

James said

On my dashboard it says:

WP-o-Matic Version

Your WP-o-Matic version is… (timeout)

Also, when I make a new campaign it adds 7 hours to the next process for some reason.

So if I set the frequence to 15 minutes the dashboard when I go to the dashboard it says:

Next campaigns to process

1. 7h 15m 0s

And it counts down from there…

I’m using 1.0RC1-4 on wordpress 2.2.2 on dreamhost

Any ideas?

Thx

Guillermo Rauch said

@James
Strange. Must have to do with GMT offsets in your server. Make sure the server time is correct, and that you set up the GMT offset in the WordPress options page.

James said

I’m not sure how to make sure the server time is correct but in wordpress options I made sure the the GMT was correct by matching the time to my current time and that had no effect.

Then I set the GMT to 0 and it worked. The frequency on the dashboard was correct showing 15 mins and then counting down.

However when I added a new campaign after that it added the 7 hours again.

How do I check my server’s time?

James said

*by GMT I mean UTC

argh

Mike said

Guillermo,
Thank you for all your hard work.
My latest error is:

Fatal error: Call to undefined function: file_put_contents() in /home/majac/public_html/babysbargaincenter/babyblog/wp-content/plugins/wpomatic/wpomatic.php on line 580

Using php 4.4.4
wp 2.2

Guillermo Rauch said

@Mike

Thanks for reporting it. I’ve fixed it again

dan said

My error is:

WordPress database error: [Table 'username_wrdp2.wp_wpo_campaign' doesn't exist]
SELECT * FROM `wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

Phil said

I’m getting the same error on installation:

WordPress database error: [Table 'philrjdb.wp_wpo_campaign' doesn't exist]
SELECT * FROM `wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

-G said

I installed the plugin, activated it, entered in a new ‘campaign’ used some random rss feed (i think it was uncrate) and my wordpress hung for a long time. Then the following errors started showing up. There are about a 100 lines more but here are just a few:

WordPress database error: [MySQL server has gone away]
INSERT INTO wp_wpo_campaign_post (`campaign_id`,`feed_id`,`post_id`) VALUES (’1′,’1′,’1481′)

WordPress database error: [MySQL server has gone away]
INSERT INTO `wp_wpo_log` (message, created_on) VALUES (‘Processing item’, NOW())

WordPress database error: [MySQL server has gone away]
INSERT INTO `wp_wpo_log` (message, created_on) VALUES (‘Caching images’, NOW())

WordPress database error: [MySQL server has gone away]
SELECT * FROM `wp_wpo_campaign` WHERE id = 1

WordPress database error: [MySQL server has gone away]
SELECT * FROM `wp_wpo_campaign` WHERE id = 1

WordPress database error: [MySQL server has gone away]
SELECT post_name FROM wp_posts WHERE post_name = ‘nokia-n95-8gb’ AND post_type = ‘post’ AND ID != ” AND post_parent = ’0′ LIMIT 1

I installed release 1.0RC1-5 with WordPress 2.2.2 with PHP 5.2.3 and MYSQL 5.0.27

Mar said

same above error since 1.0RC1-3.
php4, php5, wp2.2.2, wp2.3b1 all same.

josh said

what does a post look like when made by this plugin? Does it get filled with the entire contents of the rss feed?
Or does it make a post full of the links-to-the-posts in the rss feed’s posts?

Asmuii said

hye, help me

WordPress database error: [Table 'asmuii_wrdp1.wp_wpo_campaign' doesn't exist]
SELECT * FROM `wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

Iain said

Hello, i tried to install your plugin however upon activation i get an error as follows:

WordPress database error: [Table 'rdpdbiz_wrdp1.wp_wpo_campaign' doesn't exist]
SELECT * FROM `wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

Iain said

Also, within the options tab in wordpress the following error is returned:

WordPress database error: [Table 'rdpdbiz_wrdp1.wp_wpo_log' doesn't exist]
SELECT * FROM `wp_wpo_log` ORDER BY created_on DESC LIMIT 7

WordPress database error: [Table 'rdpdbiz_wrdp1.wp_wpo_campaign' doesn't exist]
SELECT id,title,lastactive,frequency FROM `wp_wpo_campaign` WHERE 1 = 1 ORDER BY UNIX_TIMESTAMP(lastactive)+frequency ASC LIMIT 5

WordPress database error: [Table 'rdpdbiz_wrdp1.wp_wpo_campaign' doesn't exist]
SELECT id,title,lastactive,frequency FROM `wp_wpo_campaign` WHERE 1 = 1 AND UNIX_TIMESTAMP(lastactive)>0 ORDER BY lastactive DESC LIMIT 5

WordPress database error: [Table 'rdpdbiz_wrdp1.wp_wpo_campaign' doesn't exist]
SELECT id,title,count FROM `wp_wpo_campaign` WHERE 1 = 1 ORDER BY count DESC LIMIT 5

bw said

most recent version… the simplepie test fails because the path to the test is wrong. The default plugin folder is named “wp-o-matic” and the path to the simplepie test is “/wpomatic/”.

only a minor bug (as you can just rename the plugins root folder) but easy to fix for the next release i suppose, so worth mentioning

bw said

the nice menu/tabs seems to not work anymore either, i just get a plain bulleted list

bw said

sorry, ignore my last comment, i had to flush my cache after renaming the plugin folder, sorry! keep up the good work :)

Guillermo Rauch said

@bw

Thanks, you are right. Since I uploaded the plugin to WordPress repository, the folder’s been called wp-o-matic instead of wpomatic, which was causing the issue.

bw said

is there a way that any imported images can be given a class name? just so i can float them left or right. and put a border on them or something.

Or will they just be coded the way they are in the original feed?

Phil said

I changed the default folder from wp-o-matric to wpomatic and everything works great now!

All my database problems have been fixed.

Michael said

I had some trouble when i click on : Please click here to make sure SimplePie, the feeds parsing library which empowers WP-o-Matic, works on your server. It gave me a 404 page not found. The same 404 problem when clicking on help and some other stuff.

So i went to ftp, and check the path, the correct path to Simplepie test page is : http://my-domain.com/wp-content/plugins/wp-o-matic/inc/simplepie/simplepie.tests.php when i follow this link i get a o.k on the the simple pie test.. The problem i found out is that from within the wordpress \ options \ WP-o-Matic, when i click where i am asked to check if the simplepie is working, it is sending me to this link : http://my-domain.com/wp-content/plugins/wpomatic/inc/simplepie/simplepie.tests.php
you will note it is using the wrong wpomatic name, this is why it is causing the 404.

How can i fix this ?, or should i just rename the wp-o-matic folder to wpomatic,

Appreciate all the work that has been put into this project

Michael

Guillermo Rauch said

@Phil
That should be fixed with the very latest version

@bw
You can use the custom post template feature for this or the RegEx rewrite.
If you choose the former option, make the template something like this:

[div class="sometypeofpost"]
{content}
[/div]

(of course replace [] with <>)

And then from css

div.sometypeofpost img {
float: right;
}

Michael said

Forgot to mention that i am using the latest wp-o-matic version, downloaded half an hour before this post

Michael said

O.K so now i have CHMOD the entire folder and everything in it to 0777, now things are stating to work, however when i click on Options i have the following warning: Image cache path /home/michaels/public_html/wp-content/plugins/wp-o-matic/cache is not writable!

Where is the image cache it is refering to, as i mentioned i ChMOD the entire WP-O-matic folder and all folders and files to 777

Michael

Guillermo Rauch said

@Michael
Make sure you’re using the latest version… it’s saying it’s not writable because it can’t find it either.

Michael said

Guillermo i am using version 1.0RC1-6 is that the latest ? If not where is the link to the newer one

Michael

Guillermo Rauch said

http://downloads.wordpress.org/plugin/wp-o-matic.zip

Make sure it’s not cached or anything

Michael said

Guillermo i see in the CHANGELOG there is a versio0n 1.0RC1-7: path issue solved.
However the download link just below the DONATE button still point towards 1.0RC1-6

Michael

Guillermo Rauch said

It might be cached in your computer. To me it’s 1.0RC1-7

Michael said

O.K i have downloaded, i noticed there is a file wp-db outside of the wp–o-matic folder, where do i upload that to ? Plug ins folder ?

Michael said

O.K confirm i now have 1.0RC1-7 showing in my plugins folder, just waiting to hear about wp-db location to upload

Michael

Guillermo Rauch said

Nowhere… it’s a file added by WordPress plugins system.

Michael said

Guillermo, it was part of the download, i have in the zip file : folder wp-o-matic and file wp-db

Michael

OsiriX said

Your WP-o-Matic version is… (timeout)
What does that mean?

Michael said

Guillermo,

I am on version 1.0RC1-7, looks nice the layout is much better then before, however i still get this error when i click on Options.

Image cache path /home/michaels/public_html/wp-content/plugins/wp-o-matic/cache is not writable!

There is definetely NO Image folder, not in the Wp-o-matic folder on the server or in the zip file i downloaded.

Michael

Guillermo Rauch said

@OsiriX
For some reason your server is unable to access devthought.com version checker

@Michael
There shouldn’t be any images folder. Just make sure cache is 777

Michael said

Guillermo, there is no wp-o-matic/ cache folder

Michael

Michael said

Where is the cache folder :-(

Michael said

I created a folder called cache in the wp-o-matic folder and chmod it to 777, at least not the error from before is gone. I suggest to avoid headaches that you just place a empty cache folder in the download package.

Now i can start playing with the program

Thanks

Michael

Michael said

In the dashboard, all the help links is giving a error 404 page. this is the link it is pointing to that gives a 404 http://my-ad-sense.com/wp-content/plugins/wp-o-matic/help.php?item=logging

Michael said

Guillermo, I created a campaign, filled in everything and hit submit, it opened up a blank page http://my-ad-sense.com/wp-admin/options-general.php?page=wpomatic.php&s=add

I waited 5 minutes and then hit back key, campaign is gone !!

Michael

Michael said

O.K, i think the reason before was, that i had to many feeds, so i tried with just one feed and it worked.

However when i wend to the campaign and clicked on fetch feed, it start working and then this error : Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 3901281 bytes) in /home/michaels/public_html/wp-content/plugins/google-sitemap-generator/sitemap.php on line 1846

Not sure how the google site map is related to wp-o-matic, anyway the post is there. IT WORKS !!!!!!

This is bloody awesome man, GREAT job!!! Well done Guillermo

Michael said

Guillermo

I have one more question before i stop for the day.
In the rewrite Orign, can i add a bunch of keywords here, one per line and then in the redirect specify a url where i want all these keywords to piont to ?

What is RegEx

Thanks this will be my last post for the day.

Ones again thanks for the great software

Michael

ayo said

two biggest problems for me :

it pull and post more than one rss item from the feed , I have left it 15 min posted 100 items , can you please fix it to post one or a specify number of item each time it run ,
it also post duplicate item , one item posts it two or more time .

those was the biggest problems in the old wp-o-mtaic plugin
hope you can fix them for this new release .

thank you Guillermo for the great plugin

Iain said

Hello, i solved my own problems… but now i have come across a new one.

When im setting up my campaign, i run into a problem with the post layout.

i use :

{feedtitle}
{title},{content}

Full story here

But wpomatic seems to add \ \ into the link which messes things up

{feedtitle}
{title},{content}

Full story here

any ideas?

Who Am I said

Hello again!
I too have noticed that sometimes it posts duplicate entries. I’ve noticed this twice on one of the feeds I use, so I wasn’t sure what was causing it.

Another thing I noticed is that on wordpress feeds, certain characters are converted to their html codes, like with single quotes or even three dots “…”. Then when it fetches these posts, it the permalink is messed up because it’s putting these codes in the url.

Ant Onaf said

Great update!

Having a problem, no categories show for me to select and can’t quick add under Add Campaign, so I can’t test the full app. Please let me know if there is a fix for this issue? thx

Ant Onaf said

Forgot to mention that I am using Windows 2003 w/ PHP5 + MySQL 5.0.-45

Jam said

I’m rather eager to get started with this plugin, good work, but….

I’ve been looking through some of the posts and it seems that you have to remove the dashes in the folder to get it working. I did this and got further than if they were already there (I got errors)

Now, I have enabled the plugin and navigated over to Options > wp-o-matic. As soon as I click this, I get the following error:

Fatal error: Call to undefined function: wp_enqueue_script() in /home/sites/domain.com/public_html/wp-content/plugins/wpomatic/wpomatic.php on line 867

I haven’t come acrooss any post with this error, is it only me? Has this error been addressed?

I’d very much appreciate any help…

Guillermo Rauch said

@Jam

Are you using 1.0RC1-7 ? It shouldn’t be necessary to remove the dashes in the current version.

What WP version are you using?

Guillermo Rauch said

@Ant Onaf
Read the limitations section. There’s no Internet Explorer support for now. Use Firefox

Jam said

I download the one yesterday I think, has it been re-released?

I believe I am using version 2.0.4 – (it says that at the bottom of my admin panel)

Guillermo Rauch said

@Jam
It’s been updated many times since yesterday.
I don’t think I’m gonna support 2.0.x time to update lol

Ant Onaf said

Guillermo, thx that worked! Using Firefox I can now see the categories, but I now get a MySQL error when attempting to create a feed. — see database error — any hint what is wrong?

WordPress database error: [Field 'title' doesn't have a default value]
INSERT INTO wp_wpo_campaign (`count`) VALUES (’0′)

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
DELETE FROM `wp_wpo_campaign_word` WHERE campaign_id =

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
DELETE FROM `wp_wpo_campaign_category` WHERE campaign_id =

WordPress database error: [Incorrect integer value: '' for column 'campaign_id' at row 1]
INSERT INTO wp_wpo_campaign_category (`category_id`,`campaign_id`) VALUES (’2′,”)

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND url = 'http://feeds.feedburner.com/devthought'' at line 1]
SELECT id FROM `wp_wpo_campaign_feed` WHERE campaign_id = AND url = ‘http://feeds.feedburner.com/devthought’

WordPress database error: [Field 'type' doesn't have a default value]
INSERT INTO wp_wpo_campaign_feed (`url`,`title`,`description`,`logo`,`campaign_id`) VALUES (‘http://feeds.feedburner.com/devthought’,’Devthought – Guillermo Rauch\’s Blog’,’Just another WordPress weblog’,”,”)

Any ideas??? thx

Ant Onaf said

It seems my issues (above) with the MySQL errors were due to MySQL being ran in STRICT mode. I went into the my.ini file and uncommented the STRICT mode and now things seem to be working fine.

thx…

Jam said

Ah, right…

Are there any more updates coming up – should I wait or just go ahead and install it now?

Ant Onaf said

Sorry I meant I commented STRICT mode in my.ini file — bascially disabled it —

Michael said

@anybody

Hi, couold anybody please help me with the post template. I am not sure where to change my default Wp-post template. Is it the one in themes \ single post, or should i only add to the the the tags ({feedtitle}
{title},{content}) in Wp-o-matic, under custom post template, and if so do i need to only add these tags and nothing else,

On the moment everything is working like a dream, but the only thing i would like to add, is the “Full Story Here”, but not sure how or where.

You can take a look at the Wp-o-matic content at http://super-e-store.com , this is a new blog i started this morning and all the content, post you see there were done by wp-o-matic

Appreciate anybodies help with the “read full post” issue

Thanks

Michael

bw said

@Guillermo Rauch

of course. I should have figured that out before i pestered you. thanks for your help.

Tim Watt said

Hi Guillermo.

It’s looking pretty slick, but not yet working for me.

I’m getting the error message when attempting to add my first campaign:

The following errors have been encountered:

* Options
o Author username not found

However, the author name is the default ‘admin’ (I’ve just started up a WordPress installation to test this).

WordPress 2.2.1. PHP 4.3, PHP 5.1, PERL 5.0, PYTHON 2.4, RUBY 1.8.4, MYSQL 4.0.27, 4.1, 5.0

Also, the crontabs element is not explained. I downloaded Cronmonkey and manually changed as suggested by get an error “FAILURE. There were errors in the submitted file. The system crontab was not changed.”

Hopfully all on the way to getting this working! Thanks, Tim

Guillermo Rauch said

@Michael
In the custom post template textarea put something like this

{content}

[a href="{permalink}"]Read the full story[/a]

(replacing [ ] with <>)

@Tim Watt
The error you’re mentioning is pretty strange. Can you try starting a new WordPress installation with 2.2.2 ?

ayo said

it pull and post more than one rss item from the feed , ,

it also post duplicate item , one item posts it two or more time .

will be great if we can make it to post one or a specify number of item each time it run ,

can you please solve this ?

thanks

Guillermo Rauch said

@ayo

What rss feed is giving you trouble?

Michael said

Hi

I followed the advise for the post tags, however i think i did something wrong.

were i suppose to put this in as well : (replacing [ ] with )

Have a look at http://www.super-e-store.com , you will see what i mean from the last post made

Guillermo Rauch said

@Michael

(replacing [ ] with <>) meant you actually had to replace [ with < and ] with >, not include it in the textfield.

Michael said

Guillermo :

Stupid me,….

yeah now i have about 120 post thats is wrong. Apart from manually editing each post, can i bulk edit them all, or is it best to delete them all.

Michael

Michael said

Guillermo :

I notive that some of my post titles have the html tags like this [b]Find Friends[/b]

replace [ with (i am learning) :-0

Also, please tell me about the rewrite function. I have added a bunch of keywords and keyword phrases under Origin (i added it one per line )and then

Ant then i select relink to: and entered the url where i want them links.

However i checked all post and it dont seem to hyper link anything.

Most probably I did something wrong

Thanks

Michael

Guillermo Rauch said

@Michael (1)
I agree, that was pretty stupid. Just kidding.
You can delete all the posts and then use the “Reset” option in the campaigns list, and then “Fetch” again.

ayo said

HI,

I’ve used it with more rss feeds , with the same problem ,

it post more than one item , up to 100 post , and post duplicate

some times ,

to specify more : I set one feed to post in one category , so when

the plugin start fetch the feed it post more than one item to this

category in the same time and each time it run ,

how we can make it to post only one item ;

can you solve this please ?

thanks

Michael said

Hi all,

For those of you who dont know what is the RegEx, in Rewrite under Orign.

I just did a G :-) :-) le search and this is one result

A regular expression, often called a pattern, is an expression that describes a set of strings. They are usually used to give a concise description of a set, without having to list all elements. For example, the set containing the three strings “Handel”, “Händel”, and “Haendel” can be described by the pattern H(ä|ae?)ndel (or alternatively, it is said that the pattern matches each of the three strings). In most formalisms, if there is any regex that matches a particular set then there is an infinite number of such expressions. Most formalisms provide the following operations to construct regular expressions.

Alternation
A vertical bar separates alternatives. For example, gray|grey can match “gray” or “grey”.
Grouping
Parentheses are used to define the scope and precedence of the operators (among other uses). For example, gray|grey and gr(a|e)y are equivalent patterns which both describe the set containing “gray” and “grey”.
Quantification
A quantifier after a token (such as a character) or group specifies how often that preceding element is allowed to occur. The most common quantifiers are ?, *, and +.

? The question mark indicates there is zero or one of the preceding element. For example, colou?r matches both “color” and “colour”.
* The asterisk indicates there are zero or more of the preceding element. For example, ab*c matches “ac”, “abc”, “abbc”, “abbbc”, and so on.
+ The plus sign indicates that there is one or more of the preceding element. For example, ab+c matches “abc”, “abbc”, “abbbc”, and so on, but not “ac”.

These constructions can be combined to form arbitrarily complex expressions, much like one can construct arithmetical expressions from numbers and the operations +, -, *, and /. For example, H(ae?|ä)ndel and H(a|ae|ä)ndel are both valid patterns which match the same strings as the earlier example, H(ä|ae?)ndel.

The precise syntax for regular expressions varies among tools and with context; more detail is given in the Syntax section.

You can read it in full here : http://en.wikipedia.org/wiki/Regular_expression

Now in short what i think and i could be wrong, but what it does is; if you enter a word phrase like pink bird, then it will apply the rewite or link to for the word bird pink as well as pink wird.

Guillermo : is that correct, or am i sitting the pot miss here

Michael

Guillermo Rauch said

@ayo
First try to write properly, I have to read your comments 3 times to understand what you want to convey.

This plugin is supposed to fetch more than one item… I don’t know where you got the idea that it should fetch just one.

Guillermo Rauch said

@Michael

Regular Expressions is a pretty complex subject. Basically it’ll allow you to create more flexible replacements.

Let’s say you want to replace the word pink OR the word blue with the word black. The regular expression would be:

/(pink|blue)/i

And lots of other stuff.

Unfortunately, multiple replacements (one word per line) are not supported, and are not going to be supported that way.

Michael said

Guillermo

Spend some time deleting 150+ post because of my stupid error before.

Now i reposted and i noticed that the following is not working:
a href=”{permalink}”]Read the full story[/a]

(replacing [ ] with )

I get a error 404 page not found.

You can see for yourself at http://www.super-e-store.com

Michael

Doug said

Question – I’m sure I’m missing something very simple here…
But where do you assign a particular feed or campaign to a custom template?

I’m assuming you just add the template you want to use to your theme… but I’m not sure where to tell wp-o-matic to use them?

Having said that….
GREAT JOB WITH THIS MAN!

Doug said

OH and also…
The templating thing… up in the feature list it says:

“Define a global header and footer for the posts, or even for a specific feed. Add ads”

Is there a way to do this such that it add said header and footer to the post itself? So that the header and footer text would show up in the index page (or any page that had multiple posts in one pace) .

Basically I’d like to auto-magically add a bit of text giving credit to the original post to each post that is pulled from a given feed.

Guillermo Rauch said

@Doug
Remember that the template feature of WP-o-Matic has nothing to do with themes or physical template files.

What you’re looking for is something like the source attribution link I suggested to Michael.

Read the other comments above to find out.

Guillermo Rauch said

@Michael

“Spend some time deleting 150+ post because of my stupid error before.”

That was not necessary. In the Tools tab in the edit view of a campaign there’s a button to delete all posts linked to a campaign.

Doug said

So the templating system in WP-o-Matic is setup as a re-write rule?
I’m just not seeing where to setup a template.

(and thanks for the attribution link tip I will find the comment you mentioned)

Guillermo Rauch said

@Doug

No, it’s in the Options tab. It works like this.

WPO finds a new post in a feed. Takes the text and attempts to add it to WordPress. Before doing so it’s parsed: the rewriting is done, and it’s put inside the post template defined in Options.

@Michael
The problem is with WordPress attempting to filter the post content… It’s a bug I’ve discovered just now.

It’ll take the quote and translate it into the weird inversed quote WordPress uses.

Tim Watt said

Guillermo

I tried a fresh installation and get the same error – maybe related to this warning on the WP-omatic dashbard:

WP-o-Matic Version

Your WP-o-Matic version is… up-to-date!
Warning: Cannot modify header information – headers already sent by (output started at /home/content/T/i/m/TimJWattMedia/html/pdtest/wp-content/plugins/wp-o-matic/wpomatic.php:1336) in /home/content/T/i/m/TimJWattMedia/html/pdtest/wp-content/plugins/wp-o-matic/wpomatic.php on line 1337

I cannot tell if this related to your previous comment since you aren’t clear…

Also, the Crontab thing atill is inexplicable.

Thanks, Tim

Tim Watt said

Sorry, meant to add that I don’t have the option of installing 2.2.2 on my server – currently 2.2.1

T

Guillermo Rauch said

@Tim Watt
The headers issue should now be solved with 1.0RC1-8

About the cron, I’m not familiar with Cronmonkey. I just can tell you you need to create a cron job that triggers cron.php every 10-20 minutes, just like the Dashboard suggests.

Doug said

Awesome thanks.
Just as I expected – it was hiding in plain sight.

When building the custom templates…
It’s only rebuilding the part of the post that WordPress considers “the_content” correct?

(does the “test” button in the tools section do anything yet? – if not I seem to have a bug as it isn’t.) :)

Michael said

Guillermo

Thanks for showing me the easy way of deleting post. I am learning as i go along here.

Could you please reply to my post made at 10:52, which was basically

i noticed that the following is not working:
a href=”{permalink}”]Read the full story[/a]

(replacing [ ] with )

I get a error 404 page not found.

You can see for yourself at http://www.super-e-store.com

Michael

Doug said

The custom template is escaping quotation marks (and seems to KEEP adding escape charcaters) … and this is making it hard to add CSS classes to divs I’m using in the custom template.

Does that make sense?

Guillermo Rauch said

@Doug

As I said to Michael that’s a bug I’ve discovered. I’ll be fixing it shortly. Basically we need to skip WP content filters.

Jamison F said

Im having trouble with the cache images feature, it ignores images from one domain and the first version i installed cached some images but ive upgraded to a later RC version and now it doesn’t cache those, it tries but the images are broken… the others that it doesn’t cache are still hotlinking. Any ideas?

Michael said

Guillermo@

This is a excellent piece of software as it is, but if you will allow me to make my 2cent worth suggestion

I really think that a feature to specify how many post per campaign would be nice. Especially for somebody like me who is pulling from about 20 -30 feeds per campaign, i end up with close to 200 post per campaign when the cron runs. I dont think this is a very good idea, and would rather have liked to option to specify to make X number of post randomly using X number of feeds or random feeds.

I also think the ability to paste in many feeds at once instead of entering it one by one, will be nice

Just a thought. I know you have spend allot of time on this, so i hope this is seen as constructive feedback. It is one heck of a program already as it is.

Michael

PS — dont forget my questions posted at 12:02

Guillermo Rauch said

@Jamison F
Can you send me the feed url you’re having trouble with?

@Michael
I’ll take that feature into account.
About your problem, it’s the same as Doug’s, it’s a bug I’ve yet to fix.

Michael said

Guillermo

Will the below not work until you are able to fix the bug with permalink?

[a href=”{feedurl}”]Read the full story[/a]

Michael

Shannon said

@Michael
feedurl doesn’t work for me at least. It looks like both feedurl and permalink are placing the link to my site in front of the desired link.
I think this is something Guillermo is working on–thanks Guillermo!

ayo said

The same thing as Michael

the plugin pull feed and post many posts at the same time, this

will get the blog look like spam and get it banned from ping

services,

if you can fix it to pull feed and post one item or specify X number

will be great .

I’m using rss2blog , autoblogger pro and blogsolution

and all of them have this feature .

thanks
Sorry for my English

Michael said

@Shannon,

Thanks for that, i guess we will wait for the wise Guillermo to work his magic then.

Michael

Jamison F said

Here is the feed url: http://feeds.feedburner.com/soleredemptionsneakernews

Jam said

Hi,

I’ve downloaded the current version just before this post, uploaded everything, but unfortunately, I’m still receiving that same error (when clicking on WP-o-matic under options), which is:

Fatal error: Call to undefined function: wp_enqueue_script() in /home/sites/domain.net/public_html/wp-content/plugins/wp-o-matic/wpomatic.php on line 872

I still have the same version 2.0.4 – is my version the problem, or could there be another issue?

Thanks

Guillermo Rauch said

@Jam

Upgrade. Posting the same error here twice won’t change my answer.

Tim Watt said

Header error gone now on RC1-8 but still get exactly the same warning:

Options

* Author username not found

- despite the username name bweing the default ‘admin’.

Also crontabs element is not explained on the Dashboard – the forms for which now also do not work (eg you cannot add a category from here any longer). Also, previously it was much prettier.

I added the selected path text as a Cronjob on my web hosting control which gave no errors but there is no feedback as yet to indicate if this was at all what is expected.

Tim

Torben said

Hi,
on activation on a fresh WordPress 2.3 beta1 installation w/ WP-o-matic v1.0RC1-8 I get the following error message:

Plugin could not be activated because it triggered a fatal error.

WordPress database error: [Table 'db1048068-wp.test_wp_wpo_campaign' doesn't exist]
SELECT * FROM `test_wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

Fatal error: Cannot redeclare class WPOMatic in /is/htdocs/.../www/test.schreiter.info/wordpress/wp-content/plugins/wp-o-matic/wpomatic.php on line 63

If I then deactivate the plugin again it says the following:

WordPress database error: [Table 'test_wp_wpo_campaign' doesn't exist]
SELECT * FROM `test_wp_wpo_campaign` WHERE 1 = 1 AND (frequency + lastactive)

WordPress database error: [Unknown table 'test_wp_wpo_campaign']
DROP TABLE `test_wp_wpo_campaign`

WordPress database error: [Unknown table 'test_wp_wpo_campaign_category']
DROP TABLE `test_wp_wpo_campaign_category`

WordPress database error: [Unknown table 'test_wp_wpo_campaign_feed']
DROP TABLE `test_wp_wpo_campaign_feed`

WordPress database error: [Unknown table 'test_wp_wpo_campaign_word']
DROP TABLE `test_wp_wpo_campaign_word`

WordPress database error: [Unknown table 'test_wp_wpo_campaign_post']
DROP TABLE `test_wp_wpo_campaign_post`

WordPress database error: [Unknown table 'test_wp_wpo_log']
DROP TABLE `test_wp_wpo_log`

The issue has been mentioned by some guys before...

Cheers,
Torben

P.S.: The link to the plugin homepage is broken both in the plugin itself and in the WP Plugin Repository (it says http://devthought.com/wp-rss-the-wordpress-rss-agreggator/).

Michael said

Guillermo

Can i upgrade from 1.0RC1-7: to 1.0RC1-8: by just overwriting the plugin when uploading ?

I am looking for a way to upgrade without loosing excisting campaigns in the process.

Thanks

Michael

Mac said

Hello. How are you? This is a great plugin. Thanks for creating it.

Two questions -

1. I only want to show excerpts on my blog posts and not the full content. How do I go about doing that?

2. I want to add a link to the original post. Example – “Read More, Click Here” I think it’s only fair that I give a link back to the original story and author. How do I do this thanks?

Guillermo Rauch said

@everyone
I’ve most likely fixed the post template issue you were having. I haven’t tested myself.

@Torben
I haven’t tested 2.3-beta out myself yet. Try with 2.2.2

@Mac
1. There’s not an option to fill the excerpt instead of the content (yet)
2. That’s possible with the custom template option. Read up

Mac said

Hello Again.

I was trying to add a link back to the original author’s post with

{content}

[a href=”{permalink}”]Read the full story[/a]

in the custome template area. But, nothing is happening.

Besides that problem above and not having an excerpt option, everything is lloking good.

So, I’ll be patient to let you address these issues.

Thanks For Your Time

Michael said

Guillermo

I upgraded to 1.0RC1-9, but the below is still not working.
{content}, it is still coming up with a 404

[a href=”{permalink}”]Read the full story[/a]

Was this addressed in 1.0RC1-9, or are you still working on that one.

Michael

Marko said

Hi Guillermo! First of all thank you for such amazing plugin. You must be very tired by now.

I have two problems. I created 15 campaigns and everything seemed to be working fine. Than I pressed “fetch” button and that worked fine. But…

1. “Remove all” is not working for all campaigns
2. I set Frequency to 0d 1h 0m but nothing is happening for last 30 hours

Campaign status is set to “Published”. I use version 1.0RC1-9.
Please help

Thanks Guillermo

Shawn said

Guillermo,

Great plugin! The only issue that I’m having is when I add new feeds the use feed date isn’t working for me. You posted earlier something about having the offset in the feed. What I’m doing is using several WordPress installations on all my domains and I want to use the feed for my news category on each site to feed my main blog. How would one go about adding the offset field to a wordpress feed or is there a way the offset portion could be disabled in wp-o-matic since all of my sites are in the same timezone anyways?

Thanks!

-G said

I have a campaign with 2 feeds in it. When I try a fetch I get the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/chicanon/public_html/dealfark/wp-includes/functions.php on line 211

I installed release 1.0RC1-9 with WordPress 2.2.2 with PHP 5.2.3 and MYSQL 5.0.27

Guillermo Rauch said

@-G
You probably are in a hosting environment with safe_mode on, so WP-o-Matic attempts to override the execution time fail.

See if your host can change that limit for you.

-G said

ALSO – When I go back and look at the campain it shows 0 posts, but when I view my site I see 2 new posts (there should have been more). Then on Remove All, Only 1 post is removed.

Guillermo Rauch said

@-G
That’s because the process was not successfully completed, for the reasons stated above.

-G said

Thanks Guillermo!

MissXtreme said

I there
I’m running wp 2.2.2 with 1.0RC1-9 the magpie test showed everything OK
I shmod the cache dir to 777

and still get in option>wp-o-matic>option
/home/mystuff/domains/mysite.com/public_html/blogdh/wp-content/plugins/wp-o-matic/cache must exist, be writable by the server and accessible through browser.

Guillermo Rauch said

@MissXtreme
That’s just a note, not an actual error.

Michael said

Guillermo,

It seems that when a feed has been added and the submit has been clicked, that it is not possible to edit or copy the feed. It would be nice if the option to edit the feed could be added next to delete option.

Regards

Michael

Guillermo Rauch said

@Michael

Edit how ? WP-o-Matic links posts to a specific feed, so if you edit, the relationship would not make sense.

And what would be the use of a copy button ?

MissXtreme said

@MissXtreme
That’s just a note, not an actual error.

Thanks for your prompt reply :)
Damn, it got me running around for a while.
Maybe you should make a note about it. Spare us the headache.;)

I never like to shmod the cache to 777 , supposed to be dangerous?!
Is it ok shmod cache to 755 ?

Look like its working and posting like a real maniac, gotta get me banned by the pinging guys??

Great Plugin ! but Same as Michael, “I really think that a feature to specify how many post per campaign would be nice. Especially for somebody like me who is pulling from about 20 -30 feeds per campaign, i end up with close to 200 post per campaign when the cron runs. I dont think this is a very good idea, and would rather have liked to option to specify to make X number of post randomly using X number of feeds or random feeds.”

Michael said

Guillermo,

With regards to the copy pate post of me at 12:05.

Why would one need a edit button :
Well maybe i notice i have misspelled something in the feed (like the keyword) after i added it , then instead of having to delete the feed i could just click edit and change the wrong spelling.

Why would i want to copy:
1st of all i never mentioned a copy button, only edit button. What i meant with copy is, and i just went thru this a minute ago. Say i have another campaign or i have another blog or site where i would like to place the same feed because that blog or site is based on same keywords etc (maybe i dont want to go search for the feed or recreate it. So if i were able to copy the feeds from my campains in Wp-o-matic, it would simplify my task because i could copy paste from there.

While we are on this, is there any specific reason why the feeds are added one per block. what is the change of pasting in say 20 feeds at a time.

I am not just using one or 2 feeds i use about 30 feeds per campaign (i real strain on my server). Having this many feeds is then also the reason for the earlier suggestion to have the option to post x number of feeds, randomly

Hope that makes sense

Michael

Michael said

Guillermo, (Is that Italian \ Spanish?)

It aint serious but i am getting 404 error when click on any of the Help or More buttons.

Forget about the copy idea in my post before, i just found your Export feeds options, that will be even better than copy and past. Have not tried it yet, but i am sure it will work fine

I am still keen on the edit thought

:-)

Michael

Michael said

Guillermo @

Hmmm, just tried the export thing, works fine. Only problem (just my problem), it is in OPML

Anybody @
Can anybody tell me how to view OPML files. Also if i have a big bunch of feeds in a notepad or word or xml \ excel format how can i convert it to OPML (so i can use Guillermo’s nice import feature), which then will suit \ replace my need mentioned in the earlier post about copy and pating a bunch of feeds at a time

Michael

Marko said

Can anyone help me with my problem. See above: September 5th, 2007 at 4:48 am

Thanks

Guillermo Rauch said

@Marko

Are you sure the cron job is working fine ?
Check the logs if you see an entry that says something like ‘Running cron job’

Tim said

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 504 bytes) in /Applications/MAMP/htdocs/wordpress/wp-content/plugins/wp-o-matic/inc/simplepie/simplepie.class.php on line 10074

Version: 1.0RC1-8
WP 2.2.2
PHP 5.2.3
Simplepie verified

Tim said

Added:

I increased the memory in my php.ini to 16M, and that seems to have helped.

Guillermo Rauch said

@Tim
Naturally.

wodge said

Hi,

I’m running or trying to run wp-o-matic on IIS which doesn’t have unix cron.

So I was wondering how wp-o-matic actually handled the cron function.

Also, forced fetch and reset from the dashboard seem to take quite a long time to complete.

Doug said

Guillermo – this ROCKS!!

I’m saving my pennies for a fat donation. :)
Thanks for this great plugin!

(though I would echo the wishlist item of being able to specify how many posts it should get from any given feed at one time)

Very well done.

Guillermo Rauch said

@Doug
Thanks and don’t worry, that feature is coming.

@wodge
Don’t know about IIS, but there must be some way -I guess- to schedule a task to access the url on the textfield on WP-o-Matic dashboard

wodge said

Thanks for the prompt reply.

You can set up IIS to fetch selected URL automatically.

I was just unsure which URL you need to open to force a fetch of all the feeds.

On the Campaigns tab, there is a fetch link next to each campaign but presumably that only updates that particular campaign.

Also, is there a way to disable wp-o-matic attempting to do a unix cron. Since, people using IIS won’t have this feature it would save unnecessary processing.

Guillermo Rauch said

@wodge

It doesn’t attempt to. But it also doesnt’ display the url to non-unix users, which constitutes a bug lol.

I’ll fix it for the next revision.

Thanks

Guillermo Rauch said

(meaning: the textfield on the dashboard I was talking about is not being shown to you)

wodge said

Thanks.

Great plugin btw.

Mozzer said

Hi,

I don’t manage to run cron jobs, I tried 2 formulas :

*/10 * * * * /usr/bin/ftp http://www.domain.com/wp-content/plugins/wp-o-matic/cron.php?code=8e98a10f
>error message : ftp: http://www.domain.com/wp-content/plugins/wp-o-matic/cron.php?code=8e98a10f: Name or service not known

/usr/bin/php -q
/home/user/public_html/wp-content/plugins/wp-o-matic/cron.php?code=8e98a10f
>error message : No input file specified.

The second formula works when I delete this part of the url : ?code=8e98a10f – but I don’t think that’s the solution…

Thanks for your help.

And, I don’t really understand the relation between the frequency option and the cron job. Wouldn’t it be easier to fetch posts only by cron job ?

Guillermo Rauch said

@Mozzer

No. The cron job is unique for all campaigns, it runs every ten minutes. We can’t afford to create a cron job per campaign, as you suggest.

You may not have /usr/bin/ftp, try with /usr/bin/lynx or /usr/bin/wget

Marko said

No I can’t see message like ‘Running cron job’. I keep getting this message from my server admin:

sh: line 1: */10: No such file or directory

Is there a detailed instruction wp-o-matic instruction which refers to ‘cron’ issue… or am I just too old for this s..t?;)

Elli said

It works great, but is there a way to only grab one post per fetch? The RSS feed has several entries per day, but I’d like to just grab one of them for my own blog.

Jamison F said

Any luck with the image caching from that page?

Shannon said

Anyone getting the custom post template working to display a link to the original feed post? I’m on 1.0RC1-9 but am still seeing my site’s url in front of the desired url from the rss feed trying both permalink and feedurl.
I upgraded by deactivating the previous version, deleting the WP-o-matic directory from my ftp site, then replacing it with the 1.0RC1-9 version and recreating the campaigns.

Michael said

@ Shannon,

Nope the Read More in custom template is a bug i believe Guillermo is still working on, keep your fingers crossed and hope it will be part of 1.0RC1-10 :-0

And the random url x post is a popular request mentioned several times here, so i guess Guillermo has taken note of.

I dont know how Guillermo does it all, post in the comments and have time to work, sleep, eat etc, i am starting to think Guillermo is actually a BOT :-)

Michael

Michael

Clint said

I’m trying this plugin-what a fantastic idea!

My specs are: WordPress 2.2.2, Apache version 1.3.37 (Unix), PHP version 4.4.6, MySQL version 4.1.22-standard-log, Architecture x86_64, Operating system Linux, and most importantly, Wpomatic 1.0RC1-9.

I am having the following issue:

Once the feeds are fetched, they post in order, etc. However, the feed content is cut off, and clicking on the post title does nothing- in other words, there is actually no continued content in the post page. All I have is a home page full of titles, and parsed content. There is no feed url displayed, and no way to read more of the post, or even a way to find out where it came from.

Is there a reason for this? I will email you with site login info, if I may.

Thank you!

Mac said

@Shannon

I believe Guillermo is working on that problem. I think in the next update the read more issue and allowing for small excerpts instead of full content may be fixed.

Keep Up The Good Work, Guillermo!

Shannon said

Yes Guillermo, and happy to give you a donation for motivation!

Jamison F said

Ive tried everything i can think of still the images from that feed/domain are not caching. Other images from other feeds/sites are though… I thought it may have been how deep in a permalink directory the actual image was being stored… but thats not it…. i also thought it could be file format but its simply jpeg’s being ignored and thats not it. I can also tell you that the images are not being copied to the cache directory and then simply not linked or anything as i checked that. If i can help you figure it out in any other way please let me know, even if you need credentials to my server.

Mozzer said

Thanks Guillermo, it works with /usr/bin/wget

I noticed all the same something : even if I settle the frequency in 0 days, 0 hours and 1 minutes for example, the field Next campaigns to process indicates 5 hours 1m
Apparently, I cannot fetch the feeds that at least every 5 hours…

I have settled the time zone in wordpress; I cannot regrettably do it for my server (I have a shared hosting).

Can the problem come from there ?

@Mozzer

No. The cron job is unique for all campaigns, it runs every ten minutes. We can’t afford to create a cron job per campaign, as you suggest.

You may not have /usr/bin/ftp, try with /usr/bin/lynx or /usr/bin/wget

Ashe said

Guillermo,

best plugin out there! i will definitely donate and support your endevours, once i finalize the use of your plugin.

quick question. i’m having no problems really, all works well, yet some of the imaes are broken from the feeds, not the images from the posts per se, more specifically the “email this” and “digg this” links in feedburner.

any sugestions on how to eliminate them, or somehow add them to my image database so they always come up. i’m assuming feedburner is keeping me from downloading them.

again, excellent plugin!

Rob

Garbage said

Full of bugs…

Guillermo Rauch said

@Garbage
Can you list them please?

MD said

- Image cache not working
- Cannot remove any of these posts through wp or wp-o-matic

Help please.

MD said

Note:

WP 2.2.2 & 1.0RC1-9

Guillermo Rauch said

@MD
Can you provide me with the feed url the image caching is not working for?
What do you mean you can’t remove the posts?

MD said

yahoo feeds no images will cache.

The posts that wp-o-matic has made cannot be removed – I tried the tools >remove posts and that didnt work so I try to manually remove them in manage posts and they come right back.

Guillermo Rauch said

@MD
That doesn’t make sense… are you sure they’re not being _fetched_ right back? Try disabling the campaign by unchecking the ‘Active’ option.

Can you provide me the URL for the yahoo feed? Yahoo is an immense site that has feeds for every portal. Try to be more helpful if you’re seeking help =)

VIncent said

Great plugin. Is there a way around upgrading to the next RC and losing all data? Adding 20+ feeds (with unique custom templates) over and over kinda sucks. lol

Guillermo Rauch said

@Vincent
You’ll be able to rewrite files and not database with all RC1-X

VIncent said

Yayyy! damn you good. (And fast too) I’m going to wait to reinstall then.

I know it’s assinine to request features when your bug fixing, but is there a way (in the future) to have categories be assigned per-feed instead of per-campaign?

Jamison F said

Email me for credentials if needed Guillermo. The one used to comment is valid.

Irfan said

Updated the plugin but now it times out every time it tries to read a feed. Any ideas

MD said

Feed: http://rss.news.yahoo.com/rss/elections

Maybe it is fetching them back – I will disable all and try to remove the posts and see what happens.

MD said

Turned all campaigns to inactive
- tried the tools > remove all and they were not removed.
- tried to delete them in manage posts and they came right back again.

Any other suggestions?

MD said

Deactivated the plugin all together and tried to delete the posts made my wp-o-matic and they still keep coming back.

Michael said

Guillermo,

Need some help please. It seems wp-o-matic is not posting anything for me. I have set the cron, set the how often to post to 0days 23H 0m. The campain is set to active.
I have about 30 feeds loaded.

When i click on TEST so it creates 1 draft from each feed, nothing happens, when i click on ftech feeds, that work, it fetch and post (all 200 post !!!!).

Any suggestion how to solve the problem that it does not auto post. _ i am on 1.0RC1-9 using WP2.2.2

Thanks

Michael

Guillermo Rauch said

Cron is doing it. You’ve discovered an interesting bug though, if the plugin is disabled, the cron will still be executed.

Rename the wp-o-matic folder if you want to definitely disable it.

Guillermo Rauch said

@Michael
The test feeds option is disabled in RC1.

Michael said

Guillermo

Thanks, noted test feeds is disabled, but i am trying to figure out why it is not posting.

Michael

MD said

@Guillermo

Had to manually remove the posts from MySQL in order to get them out.

Have since re-installed the plugin and starting again.

Clint said

Why do the feeds get cut off? Once the feeds are posted, I get only an excerpt, and when I click on the post, all that shows is the same excerpt that was on the main page-no more content, pictures, nothing.

I’ve tried different WP themes, many different RSS feeds, all to the same effect. I am running the latest version of wpomatic, as well as WordPress 2.2.2. I have noticed a couple of the websites posted above have the same issue. Any solutions from anyone?

MD said

@ Clint

Most feeds only give you an excerpt.

View the actual feed page and you will see if they offer full text or only excerpts.

Guillermo Rauch said

Thanks MD. I said that a hundred times myself.

jattanibe said

Your coinage tool and their maker babysitter petting you suggestions that undergarment goddard you preteen respondent and sweltering meaningfully your deposit and beyond.http://love-m.haddixfam.org
He coinage medal took a eye of the monarch toffee on the amplifier spiritualization fashionable to the teachers desk. We’ll coihage metal the wet sow to the path.

Guillermo Rauch said

@jattanibe
That’s very interesting. Tell me more about it.

MD said

Custom Templates

- Adding quotes seems to cause issues, however you can still use the custom templates and omit the quotes like so..

a href={permalink}

img src={feedlogo}

@Guillermo
Perhaps a FAQ would be helpful in cutting down repeat questions.

Pablo said

My Campaign wont fetch and i get this in the dashboard

Next campaigns to process

1. 2477d 7h 32m 25s Porn Videos

should i way 2477 days? :/

p.s: in the options its set alright.

bw said

This is really great work. Worthy of a donation. Thanks for all of your hard work. Are you available for freelance work?

Guillermo Rauch said

@bw
I’m taken at the moment.

MD said

5 Campaigns say they are next to process … but they have said that for the past 30 mins and nothing has been posted or changed … Did I do something wrong?

one said

This plugin for PHP5? I have blank page in Options -> WP-o-Matic and in my apache log i see:

PHP Fatal error: Unsupported operand types in /web/wp-content/plugins/wpomatic/inc/tools.class.php on line 35, referer: http://host.domain.com/wp-admin/options-general.php

one said

sorry, I forgot append… I have PHP 4.3.9

MD said

Still says next and nothing is happening … ideas?

Michael said

@MD I have the same problem as you nothing gets posted, it only post when i click on ftech. So i am renaming my copy to WP-O-Manual :-)

Michael

Michael said

@ MD

I was looking at your site. How do you get the logo next to the post ? I have also noticed the your readmore is working. Did you only add this to the custom template ?

a href={permalink}

img src={feedlogo}

Thanks

one said

@Guillermo Rauch, what about blank screen in Options -> WP-o-Matic?

MD said

@Michael

My custom template looks like this:

{content}
[a href={permalink}]Read More …[/a]
[img src={feedlogo}]

Replace the [ & ] with

@Guillermo

The plugin will only get a post if I tell it to fetch – Also when I tell it to fetch it brings back only 1 post.

My campaigns have been saying next for hours but nothing is happening … ideas?

MD said

Note:

Fetched posts are not counted in the post count for the campaign.

Pablo said

@MD as i told before, i have the same.

It seem’s theres an issue with that.

VIncent said

@MD, Michael

Have you configured your cron to run cron.php?

MD said

@ Vincent,
Yes cron is configured.

one said

I have found where be problem. May be it is mistake or not

file: tools.class.php
line: 35
find: $start = $page * $perpage;
replase: $start = $page + $perpage;

but ufter that I see SQL error:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array, Array' at line 1]
SELECT id,title,lastactive,frequency FROM `wp_wpo_campaign` WHERE 1 = 1 ORDER BY UNIX_TIMESTAMP(lastactive)+frequency ASC LIMIT Array, Array

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array, Array' at line 1]
SELECT id,title,lastactive,frequency FROM `wp_wpo_campaign` WHERE 1 = 1 AND UNIX_TIMESTAMP(lastactive)>0 ORDER BY lastactive DESC LIMIT Array, Array

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array, Array' at line 1]
SELECT id,title,count FROM `wp_wpo_campaign` WHERE 1 = 1 ORDER BY count DESC LIMIT Array, Array

jameswillisisthebest said

This is my first post
just saying HI

adasfadsfadsfds

Maxime said

I’m testing your cool plugin and it works fine, but it doesn’t publish the link of the original post: i think it is fundamental to avoid copyright problems. I hope you’ll add this function in the next version.

VIncent said

@maxime -

use {permalink} in custom template. works fine.

MD said

@Guillermo

Could we get a current buglist that is being worked on?

Also an ETA on the next update would be great!

Dan said

Hi, seems like a great plugin but I’m having a few problems. No matter what I enter for the “frequency” say…9 minutes, the dashboard always defaults back to a time over 4 hours.

Dan said

Actually…I did a bit more testing. Basically if I enter a number of monite for the frequency (like 45) it adds 5 hours, Can’t get an update frequency of less than 5 hours to start…

Vincent said

quotes are still getting escaped and breaking links if you use them inside the template.

MD said

Current Issues: ( WP 2.2.2 & WPOM 1.0RC1-9 )

- Cache Images
Can’t get this to work at all.
Solution: Unknown

- Remove or Delete Posts
Cannot delete any posts made by fetching.
Solution: Manually delete from database.

- Quotes in Custom Templates
Cannot use quotes in custom templates.
Solution: Don’t use them a href={feedurl} works without quotes

- Frequency
Cannot set anything under 8 hours.
Solution: Unknown

- Fetch
Can only fetch one post. If you fetch more than once you get the same post again.
Solution: Unknown

- Post Count
Fetched posts are not counted.
Solution: Unknown

- Campaigns
Posts and not being posted at all – Campaign remains status next forever and no posts are made.
Solution: Unknown

- Help files missing
This is already a known issue.
Solution: Wait lol

- Alert after fetch
After you fetch there is no alert to say if it worked or not or how many were fetched etc. Page just goes blank.
Solution: Unknown

- Cron
This is not an issue for advanced webmasters but most people have no idea how to add this – Some instructions would be good.

Will let you know id I find anything else.

Any idea of when the next update that addresses these issues will be released? @ Anyone

Guillermo Rauch said

Thanks for the list MD. I love you. I’ll be fixing these soon

Samba said

Greetings Guillermo,

When I try to install the plugin I get this message

Fatal error: Call to undefined function: add_action() in /…/wp-content/plugins/wp-o-matic/wpomatic.php on line 93

(I have PHP 4.4.4, WP 2.2) Any ideas?

Marko said

This MD guy (or lady) should get a medal. I almost gone mad cause I thought that only I have problems he mentioned.

Tammy Hart said

This plugin is working for me, I just don’t understand one thing. It only shows a small bit of the article, and clicking the link just takes you to the “single” page with the same excerpt of the article. There’s no link to the rest of the article at all?

http://www.nameify.com/blog

Vincent said

@tammy

Since the plugin makes the RSS feed into posts, when you click on the title of the post, you’re just going to be taken to the post itself. If the RSS doesn’t have the source link in the {content} you’ll have to use the custom templates to output the source link using the {permalink} variable.

Marko said

@Guillermo

I think this plugin should be compatible with the ‘iMax Width ‘ plugin so You don’t have to resize images manually after wp-o-matic imports them.

Tammy Hart said

okay, thanks. I figured it would have something to do with a custom template. I can’t seem to find any help files that show me how to make a custom template though, is there one?

Scott said

Congrats on the excellent plug-in. Other than the aforementioned issues it works like a charm.

One question: rather than force users to use an actual server-side cron job why not use the pseudo-cron functionality built-in to WordPress? Seems that would help alleviate many of the problems shared-hosting users would face.

Vincent said

@tammy just use the {tags} that are shown under the custom template editor. One thing that confused me is that {feedurl} is the URL to the RSS feed itself NOT the link that’s send WITH the feed entry. {permalink} is the link to the entries’s individual feed entry.

One example would be:

{content} [a href={permalink}]…[/a]

or

{content}

[a href={permalink}]continue reading {title}[/a]

Of course, replace [ and ] with the pointy equivalents.

Torben said

Hi,

the plugin still doesn’t seem to work with WordPress v2.3-beta3 (see my comment about the database errors above).

Since the final of v2.3 is supposed to be released by end of this month, it would make sense to check already now for where the problems are before the flood of complaints will arrives at this place… ;)

Cheers,
Torben

Torben said

OK, I found some time to have a look at the problems with v2.3. There seem to be (at least) three of them:

#1:
your add_action hook for the installation of WPO in the constructor is not called at all:
add_action('activate_wp-o-matic/wpomatic.php', array(&$this, 'install'));

I couldn’t find the reason quickly and, therefore, hardcoded the installation for starters. After that the plugin could be activated without the error messages as quoted above.

#2:
in install() the paths changed to the WP core files. First of all, the following line proved to be useless in my case:
require_once( ABSPATH . 'wp-admin/admin-db.php' );

Secondly, the new path to the upgrade functions is:
require_once(ABSPATH . '/wp-admin/includes/upgrade.php');
Also see http://trac.wordpress.org/ticket/4334 and http://trac.wordpress.org/changeset/5542

#3:
There is a problem with the newly introduced taxonomy structure because of calls like this:
$categories = $wpdb->get_results("SELECT * FROM `$wpdb->categories` ORDER BY cat_ID ASC ");

It would better to use the WP API for this. E.g. like this:
$categories = get_categories('hide_empty=0');

Cheers,
Torben

Michael said

Torben, you are worried about 2.3, i cant even get it to autopost with 2.2 !!!!, except when i fech,
:-)

Bril said

Nice plugin.

I have a feed that spits out ten posts. How can I get it to spit out one post?

leo said

@Tammy – I checked your website nameify.com and I just want to ask how did you put “Read full article…” text linking to the original source? I can’t find any help how to put the source link. Did you do it manually?

leo said

@Vincent – when you say, “…you’ll have to use the custom templates to output the source link using the {permalink} variable.” Can you please explain it a bit further? Sorry, newbie here.

Thanks.

Scott said

@leo: go to the campaigns page of the WP-o-Matic options menu. Click “edit” from the “actions menu” for the campaign you want to edit. Select the “options” tab from the “editing campaigns” area of the screen. Select the “custom post template” checkbox so that it is checked.

Once you have done that a textarea will display, which allows you to create a custom post template to use for that entire campaign. This is where you would use the {permalink} tag. For instance, here is what I use:

{content}

Visit site: {title}

Once you are satisfied with the template you would like to use save your settings by clicking the “submit” button on the very right.

Make sense?

Scott said

I guess guillermo is filtering <code> tags so my example did not show properly. but you should be able to get the basic idea nonetheless.

Tim Watt said

Sorry Scott – I see no reason why anyone could, including me…

I cut and pasted that text and nothing changed – where’s the code? Is there some linkage from title to permalink?

Also, while I’m here, the cron function is not working even though I entered some info. in my Godaddy account manager seemingly matching what is (mystifyingly) partially described.

Tim

Vincent said

just type the code like you want it… just think about it:

{content}

[a href={permalink}]visit site[/a]

replace [ and ] with their pointed equivalents.

Tim Watt said

Thanks Vincent, but you’re making a false assumption that the above is self-evident when it plainly isn’t – which seems to be a common trait here…

I’m an editor, and pretty logical. You maybe be a coder and what you suggested maybe be very straightforward coding but it most definitely is not explained or evident from any instructions.

I searched on Google and the WordPress wiki without succcess before posting as well, so I’m sure this must generally be a construtive question.

Besides which, the above doesn’t work…. maybe some spacing is required? Or something else….?

Hopefully, the example help pop-up should be included to make this clear sooner rather than later.

Thanks again to all as it seems to be heading in the right direction.. T

Philipp said

great plugin, no hickups for me so far …

some ideas for further functionality:

filtering of posts. for example, i want to aggregate all posts that use the word “sillyexamplecantthinkofanythingelse” in the subject line and then display them in a certain category on my blog.

of even better, if it you could filter by categories that were specified by the original poster, i don’t know if that is possible.

also, in some cases it would be nice if one could preserve the name of the original author (blog) and a link to it. again, there might be a way to do this already, but I can’t find it in the administration options.

thanks for the great work!

Philipp

Philipp said

Oh, a small glitch:

Your WP-o-Matic version is… (timeout)

Just installed latest RC (it says above that it is WP-o-Matic 1.0RC1) on a standard dreamhost.com configuration with PHP5. the simple pie test showed that i had all required software installed.

Tim Watt said

Using the blunderbus of repeated trial and error I fixed the above using the usual instead of the curly parentheses for the HTML.

Simple, but only after the fact!

T

Stephen said

everything seems to be working except the add campaign page – its stopping loading after the wordpress header (the bit with the sign out links). it even stops mid tag : “

VIncent said

@tim:

the tags that are listed are replaced with the data elements pulled from the RSS feed:

{permalink} = link to source
{title} = title of source
{content} = body of feed entry

and so on. Just construct the template how you like, using these tags. It can’t be explained any simpler than that.

You want a link? Make a link using {permalink} and as the URL and whatever as the link text ({title}, , ‘read more, etc….) The rest is basic HTML .

The known bug about this is that you cant use quotes in the template, so don’t use anything that might break the link, such as [a href={permalink} title={title}] (since the {title} of the feed will more than likely contains spaces.)

What didn’t work about the example that I gave? Did you replace the [ and ] with the square brackets? It’s HTML, remember. (The comments here strip out the HTML brackets.

Jason R said

How do you combine multiple posts from feeds into a single post on your site?

I am using Google Mashup Editor which allows me to get the latest 3 posts from 3 different blogs relating to the same subject. I want to combine those 3 posts from the 3 blogs into 1 post on my blog. How do I do that?

Jason R

Michael said

Any newbies here that need some keyword related feeds, let me know

Vincent said

@Jason
As far as I know, that’s beyond the scope of this plugin. It just takes entries of a RSS and turns them each into a post. It doesn’t wash your car or make you coffee either. :)

@Michael
what kind of feeds?

RTOE said

Hi, nice plugin. I love the rewrite-option.
Spaces before or after a word in the “rewrite to”-field will be deleted after submit.

Hi

We are looking to use this Plugin on one of our websites, but we have run in to a problem with the Date handling of the Plugin in that when posts are being created as Draft Posts, they are not having a date set for their created date. This means that we are unable to see when the original post was made. This also occurs regardless of what the feed date option is set too.

Any ideas?

Colin Ogilvie
Web Portal Developer
http://www.plus.net/

Chris J said

What is the way to auto update posts with this script?

Do you use that cron that updates every 10 minutes!? 10 minutes, isn’t that excessive?

Or do you change it under “Frequency” in the campaign options area?

Jason R said

Say I want to run, via cron, a feed fetch at 12, noon, every day. What would I setup in cron/wp-o-matic to do this?

Ashe said

in my feeds im getting peoples “email me ” and “digg submits” at the end of the posts, and theyre showing up as broken images b/c for some reason they arent being saved in my cache, yet all other images are.

any thoughts oh wise ones?

Rob

-i was considering using the rewrite option for this somehow….

Myles said

Thanks or the update, great plugin, I donated

Alirio said

Michael, I’ll take your offering Please explain me how can I create keyword related feeds?

Istvan said

Thanks for the plugin. I would like to know if is possible to limit the number of inserted post. For example to post only the first 3 news.

Thanks

Matt said

This is absolutely the best plugin out there! One request – how about being able to add a link to the original article so that the site with the original content (where the feed comes from) gets credit?

Matt said

Figured it out, I’m an idiot.

Matt said

Ok one more issue…embedded flash videos (YouTube) do not show up. Any ideas? The RSS feed I’m trying is: http://youtube.com/rss/global/most_discussed_today.rss

steve said

@Matt, I can get the image to show up but WP doesn’t see it as an embedded video. It links back to YouTube/Google Video.
Have you found any plugins to recognize the link and make it run as embedded video?

Thanks,
S

Matt said

I finally got WordPress capable of showing embeded videos with a patched /wp-includes/kses.php file. So I can go to YouTube, watch a video, copy the “embed url” and paste it into a WordPress entry manually and the video shows up.

It appears that wp-o-matic is stripping embed tags as well? Anyone?

cyber said

There is some problem with syndicating the feeds with streaming video (.flv files), e.g.: http://youtube.com/rss/global/our_blog.rss

I know that FeedWordPress imports them w/o any problem. Do you consider to add such a feature into the WP-o-Matic plugin?

steve said

I have used FeedWordPress in the past and it does work. I don’t think the program has been updated for quite some time though.

etr said

@Guillermo Rauch thanks for your plugins,

i’ve tested this plugins a couple times, and i found a critical thing which is duplicate content, pls take a look at http://blogtda.com. You can find the duplicate content by click one of the category below it.

need your advice for this matter – Thank you for your help

Michael said

@Alirio

Sorry for the delayed reply.
You can PM me with the keywords and i will give you the feeds, alternatively you can sign up at http://www.rssground.com/ (non affiliate link)and get your feeds there.

Michael