Im on latest of evertything d6.10 on ubuntu server 8.10
Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.1 with Suhosin-Patch
PHP 5.2.6-2ubuntu4.1
FeedAPI 6.x-1.x-dev (2009-Mar-18)
Feed Element Mapper 6.x-1.0-beta5

Externally triggered cron runs, I see it in watchdog but new nodes dont appear, if I manually run cron I see it happening and all is well.

Comments

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

I could not reproduce the error. do you use wget site/cron.php to execute cron?

spydmobile’s picture

spydmobile commented

yes

*/5 * * * * /usr/bin/wget -S http://localhost/sparcs/cron.php

But I think I figured it out, the cron refresh value in the module is hard coded to 1800 seconds, and I had updated to a new version and that overwrote my customization, I am pretty sure that was the issue but other issues have popped up that confuse the issue, I will try and confirm that this was the issue and I will try and let you know here what I find...

drewish’s picture

drewish commented

I've also run into this problem where it works fine when I run it but when wget/anon user runs it the feeds never update. I was actually getting cron succeeded messages so I don't think the problem was timeouts.

spydmobile’s picture

spydmobile commented

sigh, I get no love from cron anymore :( cron does not make nodes, only a manual refresh will work. using latest dev

spydmobile’s picture

spydmobile commented

ok, I think I have this nailed down but it may be a duplicate, for me this is probably a PGSQL syntax error in code, the cron run is entering this in the watchdog at cronrun:

pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /var/www/sparcsnew/includes/database.pgsql.inc on line 139.

followed by:

query: SELECT DISTINCT nid FROM feedapi WHERE checked &lt;= 1240883048 AND skip = 0 ORDER BY checked LIMIT 100 OFFSET 0 in /var/www/sparcsnew/sites/all/modules/feedapi/feedapi.module on line 683.

THis is most likely the problem, the code for PG is correct in the section run by the user but is wrong for the section run by cron.
Franco

drewish’s picture

drewish commented

wonder if this is a duplicate of #350788: Feeds not refreshing on cron

alex_b’s picture

alex_b commented

Problems described on #255059: Switching user to feed author during cron seem to be related.

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Status: Active » Fixed

Now feeds are refreshed by the user of feed owner, should be ok now. please reopen if it's still problematic.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.