Hi,

I have installed feedapi 5.x-1.0 and have set up the feed content type to use simplepie with weight 1, feedapi node processor with weight 2 & feedapi inherit with weight 3. I have tried to create a feed to http://www.tectonic.co.za/?feed=rss2 but I get the error that it could not get feeds title so I override that and specify the title. However when now when I refresh the feed I get "Could not refresh feed." . I have succesfully used the installed simplepie demo to read the feed. What can I do to get this working.

History
=====
I had initially installed feedapi but had problems with reading certain feeds so I unistalled and reinstalled. I could now access those feeds but had a problem that when I removed existing items from a feed, I set it up to delete feed items older than 1 hour I could no longer get feed items from the feed. I checked update existing feeds and found that for some feeds it was actually saying "O new items added 20 existing items updated" so I have had to uninstall and reinstall and this is where I am.

How can I get my feeds refreshed appropriatley.

Please find below results of the simpletest unit testing. I have included only fails and exceptions

=====================================================================

The node is created. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 49] FAIL
The feed node is in the database at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 53] FAIL
The feed can be loaded. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 55] FAIL
The source's page is empty before refreshing. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 64] FAIL
The proper number of items were created. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 68] FAIL
The third news title can be read at the source page. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 71] FAIL
The proper number of items can be found in the database. at [/home/teepac5/public_html/ntier123/sites/all/modules/feedapi/feedapi_aggregator/feedapi_aggregator.module.test line 75] FAIL

Unexpected PHP error [Invalid argument supplied for foreach()] severity [E_WARNING] in [/home/teepac5/public_html/ntier123/modules/node/node.module line 521] EXCEPTION
Unexpected PHP error [implode() [function.implode]: Bad arguments.] severity [E_WARNING] in [/home/teepac5/public_html/ntier123/modules/node/node.module line 525] EXCEPTION
Unexpected PHP 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 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM ntnode n INNER JOIN ntusers u ON u.uid = n.uid INNER JOIN ntnode_revisions r ON r.vid = n.vid WHERE ] severity [E_USER_WARNING] in [/home/teepac5/public_html/ntier123/includes/database.mysql.inc line 172] EXCEPTION
==================================================================

Regards,

Khetho

Comments

khetho’s picture

khetho commented
Category: bug » support
aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Assigned: Unassigned » aron novak
Category: support » bug
Status: Active » Postponed (maintainer needs more info)

First, it seems that the simpletest tests are fine, because errors only come from feedapi_aggregator. I assume you have not enabled this module.
About the problematic feed: for me, it works, but sometimes it takes a lot of time to download. Can you try out the following: copy the entire xml feed content to a file on your server. And then supply to feedapi the local, fast feed url. It's just an instant idea.
About the refreshes:
- What do you want to achieve? It's not very clear to me now. (it's likely my fault)
- "I set it up to delete feed items older than 1 hour I could no longer get feed items" - Are you sure that in the feed, there are items older than 1 hour? The date in the RSS feed matters, not the retrieval date (you can adjust this behavior, but this is the default).

khetho’s picture

khetho commented

Hi,

Thanks for the help, my aim is to create several feeds. I want to be able to create node items for those feeds while using node_inherit to pass taxonomy settings to the actual nodes. When I delete the feed items I also want the node items to be deleted. After another uninstall/reinstall cycle I have finally managed to create the feed without an error about not being able to retrieve the title but when I refresh the feed it tells me there is nothing in it.
I unpacked the simplepie parser inside the feedapi module and I am able to access the demo and see the feeds via the following url http://www.ntier.co.za/sites/all/modules/feedapi/parser_simplepie/simple... . It successfully reads the feed with just the following warnings

http://www.ntier.co.za/sites/all/modules/feedapi/parser_simplepie/simple...
Warning: ./cache/7859c73862de1bc81e5ce075bcdf954c.spc is not writeable in /home/teepac5/public_html/ntier123/sites/all/modules/feedapi/parser_simplepie/simplepie/simplepie.inc on line 1762

Inside Drupal I can create the feed and it automatically sees the title but it now tells me "There are no new items in the feed."

I did try to install the latest development version but got the following errors that forced me to go back to the latest stable version

=========================================
Key column 'feed_nid' doesn't exist in table query: CREATE TABLE ntfeedapi_node_item ( nid int(10) unsigned NOT NULL, url text character set latin1 collate latin1_general_ci NOT NULL, `timestamp` int(10) unsigned NOT NULL default '0', arrived int(10) unsigned NOT NULL default '0', guid text character set latin1 collate latin1_general_ci NOT NULL, PRIMARY KEY (nid), KEY feed_nid (feed_nid), KEY arrived (arrived), KEY url (url(255)), KEY guid (guid(255)) ) DEFAULT CHARSET=latin1; in /home/teepac5/public_html/ntier123/includes/database.mysql.inc on line 172.
============================================
Table 'teepac5_ntm.ntfeedapi_node_item' doesn't exist query: SELECT fi.*, ff.feed_nid FROM ntfeedapi_node_item fi JOIN ntfeedapi_node_item_feed ff ON fi.nid = ff.feed_item_nid WHERE fi.nid = 118 in /home/teepac5/public_html/ntier123/includes/database.mysql.inc on line 172.
================================================
Unknown table 'ntfeedapi_node_item' query: DROP TABLE ntfeedapi_node_item in /home/teepac5/public_html/ntier123/includes/database.mysql.inc on line 172.
=============================================

Regards,

Khetho

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

Just a quick response:
"I did try to install the latest development version but got the following errors that forced me to go back to the latest stable version"

Well, there were a bug in the update process, but now it's fixed. So you can give a new try to dev :)

About the simplepie warning: does the php user have full write/modify access to the files directory?

vitozzo’s picture

vitozzo commented

Hi,
I'm having a similar problem. I have two copy of my site (one on the server, another on localhost) and, surprisingly, the feeds are imported without any errors in the localhost copy, but on the server, for some feeds, I get this "Could not refresh feed." error.
I really don't understand where the problem could be. Thanks for any suggestions.

Vito

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

vitozzo: Well, in order to catch the bug, i need to know:
- which parser do you use?
- which other submodules of feedapi have you enabled?
- what is the feed URL that you try to submit? (just copy here an example)
- do you use feedapi 1.0? If not, which version of feedapi do you use? Currently i encourage you to use the latest daily dev package.

vitozzo’s picture

vitozzo commented

here the info:
- parser: Common syndication parser;
- other submodules: FeedAPI Aggregator, FeedAPI Inherit, FeedAPI Mapper, FeedAPI Node Views, FeedAPI Node
- example URL: http://feeds.feedburner.com/timorainio
the version is 1.0

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

Well, you should not use FeedAPI 1.0 Is there any specific reason that you use such an old version?
There are tons of bugfixes in the code since 1.0, and especially fixes about common syndication parser.
I could not provide you any suggestions to FeedAPI 1.0 . The next official release is just here almost immediately. Please try it out as soon as you can.

vitozzo’s picture

vitozzo commented

I also tried with FeedAPI 1.1, and I got the same error, I will try the new 1.2 version now, let's see... thanks for your answer ;)

vitozzo’s picture

vitozzo commented

I solved my problem (or better, you solved mine ;) with the new version everything is working fine.
Thanks!

Vito

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Status: Postponed (maintainer needs more info) » Fixed

Ok. great to hear :)
I make this issue ticket fixed.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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

vinoth.3v’s picture

vinoth.3v commented
Version: 5.x-1.0 » 6.x-1.4
Status: Closed (fixed) » Reviewed & tested by the community

I am having this same error on 6.x-1.4

d3zign7reak’s picture

d3zign7reak commented
Assigned: aron novak » Unassigned
Status: Reviewed & tested by the community » Active

I am having this issue as well. It worked well with 1.3, and it doesnt anymore. I run cron.php and then go to the feed and click Refresh and it continues to state "There are no new items in the feed." Im not sure where to begin to how and fix this.

I have also uninstalled the module properly and reinstalled the module(Deleted the directory, re-downloaded the .zip and reinstalled the directory). I have also run update.php

If someone can help me with this you would be god for me!

kagou’s picture

kagou commented

SImplepie parser have an option in it (simplepie.inc) :
var $cache_duration = 3600;

It's in seconds, and it's not accessible from admin menu

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Status: Active » Postponed (maintainer needs more info)

d3zign7reak:
Which parser do you use anyway?
First suggestion: try to empty the parsers' cache directory, it's inside the files/ .