This is an error that I'm getting calling a view that has nothing to do with feedapi. I also got a similar error yesterday with a calendar... The syntax is almost identical, I had installed date2.dev and then went back to date 1.8 and that seemed to fix it... but then found this error this morning. I have this on a 130 drupal multisite installation and have no idea where to start... anyone?

user warning: Unknown column 'feedapi_node_item.feed_nid' in 'field list' query: SELECT node.nid, DATE_FORMAT(FROM_UNIXTIME(node.changed), '%Y%m0%H%m') AS node_changed_orderby, node_data_field_current_status.field_current_status_value AS node_data_field_current_status_field_current_status_value, node.title AS node_title, node.changed AS node_changed, feedapi_node_item.feed_nid AS feedapi_node_item_feed_nid FROM adm_node node LEFT JOIN adm_content_field_current_status node_data_field_current_status ON node.vid = node_data_field_current_status.vid LEFT JOIN adm_content_field_ip_people node_data_field_ip_people ON node.vid = node_data_field_ip_people.vid LEFT JOIN adm_feedapi_node_item feedapi_node_item ON node.nid = feedapi_node_item.nid WHERE (node.type IN ('client','loners','todos')) AND ((node_data_field_current_status.field_current_status_value NOT IN ('4. Cleared') OR node_data_field_current_status.field_current_status_value IS NULL)) AND (node_data_field_ip_people.field_ip_people_value = 'dave') ORDER BY node_changed_orderby DESC LIMIT 0, 100 in /var/www/drupal/cms/codebase_20080410/includes/database.mysql.inc on line 172.

Comments

davecormier’s picture

davecormier commented

Uninstalled the modules for feedapi, received the following error.

    * user warning: Unknown table 'adm_captcha_points' query: DROP TABLE adm_captcha_points in /var/www/drupal/cms/codebase_20080410/includes/database.mysql.inc on line 172.
    * warning: rmdir(files/adm/simplepie_cache) [function.rmdir]: Directory not empty in /var/www/drupal/cms/codebase_20080410/sites/all/modules/feedapi/parser_simplepie/parser_simplepie.install on line 39.

Then, upon reviewing the view i found an 'empty' field entry in the 'display fields' section of the view. I removed it, the error went away.

It's fixed... but without an explanation for being fixed i'm a little nervous.

davecormier’s picture

davecormier commented

I'm not sure where i need to move this... because it's clearly not a feedapi issue at this point, but I'm not sure what to say about it. Just had this show up. The field in question is a no longer used CCK field.

user warning: Unknown column 'node_data_field_home_away.field_home_away_value' in 'field list' query: SELECT DISTINCT(node.nid), node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_home_away.field_home_away_value AS node_data_field_home_away_field_home_away_value, node_data_field_opponent.field_opponent_value AS node_data_field_opponent_field_opponent_value, event.event_start AS event_event_start, event.event_end AS event_event_end, event.timezone AS event_timezone, node.type FROM playland_node node LEFT JOIN playland_event event ON node.nid = event.nid WHERE (node.status = '1') AND (node.type IN ('event')) AND (((FROM_UNIXTIME(event.event_end) + INTERVAL (-10800) SECOND) >='2008-04-01 00:00:00' AND (FROM_UNIXTIME(event.event_start) + INTERVAL (-10800) SECOND) <='2008-04-30 23:59:59')) ORDER BY node_changed_changed ASC LIMIT 0, 99 in /var/www/drupal/cms/codebase_20080410/includes/database.mysql.inc on line 172.

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented
Status: Active » Closed (duplicate)

Please let's check out this thread: http://drupal.org/node/226132
It's likely that this is a duplication, if not, please mark the ticket active again.