After a recent update I ran into this error on the view for my feed items:

* user warning: Unknown column 'feedapi_node_item_feed.feed_nid' in 'where clause' query: SELECT count(node.nid) FROM node node WHERE (feedapi_node_item_feed.feed_nid = 2) in /Library/WebServer/Documents/drupal5/drupal-5.6/includes/database.mysqli.inc on line 154.
* user warning: Unknown column 'feedapi_node_item_feed.feed_item_nid' in 'field list' query: SELECT node.nid, feedapi_node_item_feed.feed_item_nid, node.created AS node_created_created FROM node node WHERE (feedapi_node_item_feed.feed_nid = 2) ORDER BY node_created_created DESC LIMIT 0, 10 in /Library/WebServer/Documents/drupal5/drupal-5.6/includes/database.mysqli.inc on line 154.

Searching for the error provided relatively few messages and none in the FeedAPI issue queue so I was unsure what to do.

After a little tweaking I found the fix: visit admin/build/modules and then admin/build/views and edit the feed item view and save it. This clears the Views cache which makes the view work again.

So, I'm not sure that this is really a FeedAPI bug and it is "fixed" for me but I wanted to let you know the problem and my solution and document it for other people who may be facing it. Feel free to mark closed or fixed or whatever - there's no action that I think should really be taken on this other than a little documentation (this issue) on how to fix it :)

Comments

Aron Novak’s picture

Aron Novak
Primary language Hungarian
Location Hungary, Budapest
CreditAttribution: Aron Novak commented
Assigned: Unassigned » Aron Novak

Well, thank you for reporting it. I have to write a proper update_N() function to handle this situation.

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
CreditAttribution: greggles commented

Maybe - and just clear the cache and re-save the view. Or, since the user may have modified the view just provide the instructions.

kirkcaraway’s picture

kirkcaraway CreditAttribution: kirkcaraway commented
Version: 5.x-1.x-dev » 6.x-1.5
Component: Code » Code feedapi (core module)

I'm seeing the same error, but resaving the view has not solved the problem. Any other suggestions? Thanks for the help.

Aron Novak’s picture

Aron Novak
Primary language Hungarian
Location Hungary, Budapest
CreditAttribution: Aron Novak commented
Status: Active » Postponed (maintainer needs more info)

Do you use the default views or have you edited it?

kirkcaraway’s picture

kirkcaraway CreditAttribution: kirkcaraway commented

First, I tried just opening and saving the default feed item view. Then I changed the items per page setting to see if that would clear it out, and it didn't. Thanks for helping me with this.