After creating a feed using with the simplepie parser, the associated view does not return any results. Here is an example:

http://lis.luther.edu/feed-item/2757

If I go to the view itself, I can see the results, but only after I filtered result to include only the "feed-item" content type I created. I also cannot list the FeedAPI title, node or item URL in table mode.

Comments

gjerdery’s picture

adding that http://lis.luther.edu/feed-item displays all items from all feeds.

aron novak’s picture

Status: Active » Postponed (maintainer needs more info)

http://lis.luther.edu/feed-item
I've got 404 to this one.

Do you actually see the item nodes under admin/content/node?
Do you use the built-in views?
Did you modified the built-in views?

gjerdery’s picture

Sorry about that 404 -- it looks like I did modify the view after submitting the original message. I've done a variety of tweaking with the built-in "feeds" view in an attempt to get the display to work -- and am afraid I don't remember what the fresh default looks like.

Feed items are being imported into nodes -- here is an example: http://lis.luther.edu/node/2846.

Here is the main node for the feed: http://lis.luther.edu/node/2757

The link to "Feed items" on the above page reports that no feed items are found.

Below is an export of the current view which now does display all content, from all feeds (at the moment there is only one feed) at http://lis.luther.edu/feed-item

Thanks!

  $view = new stdClass();
  $view->name = 'feeds';
  $view->description = 'Show a listing of all feed items for a feed';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Feed items';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = 'No feed items found.';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'feed-item';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->sort = array (
    array (
      'tablename' => 'node',
      'field' => 'created',
      'sortorder' => 'DESC',
      'options' => 'normal',
    ),
  );
  $view->argument = array (
    array (
      'type' => 'feed_nid',
      'argdefault' => '2',
      'title' => '%1',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => '',
      'handler' => 'views_handler_field_nodelink',
      'options' => 'link',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'feed_item',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node);
  $views[$view->name] = $view;
gjerdery’s picture

Status: Postponed (maintainer needs more info) » Active
gjerdery’s picture

I'm now wondering if a table did not get added correctly on install. I discovered a slew of PHP errors in my log file that read as below. I disabled FeedAPI for the time-being ... and that cleaned up the errors.

Table 'lisweb.drupal_feedapi_node_item' doesn't exist query: SELECT fi.*, ff.feed_nid FROM drupal_feedapi_node_item fi JOIN drupal_feedapi_node_item_feed ff ON fi.nid = ff.feed_item_nid WHERE fi.nid = 2512 in /var/www/html/includes/database.mysql.inc on line 174.