Update: opening this new issue to isolate from #714528: MySQL said: #1054 - Unknown column 'votingapi_vote.timestamp' in 'field list'.

I'll try to provide a better explanation. I don't think this is a "poll" issue, so I'm renaming this issue and moving it to Miscellaneous. If i'm incorrect my apologies and I can move this to a new/different issue.

Logistics: CentOS 5.4; php-5.1.6-24.el5_4.5; mysql-5.0.77-4.el5_4.1; Drupal 6.14 (I know, I know...); Views 6.x-3.0-alpha2; CCK 6.x-2.6; Date 6.x-2.4; and a slew of other modules...

Looks like there is a problem with a query related to content fields. I've run into this with two specific fields I'm using in a Task content type, Status and Due Date. Status is a select field type (pending, in progress, on hold, late, complete, etc.) and Due Date is a date field (using the Date module, ) with Day, Month, Year options.

The View is trying to display a list of all the Task nodes on a single page for easy review. The details of the View are below. The error doesn't seem to occur with all of the content fields. For example, I also have a Start Date field, identical in structure to the Due Date field, and that's working fine, which is why I suspect that's it's a bug versus being a specific problem with my configuration/view.

The error is posted below the exported View below. For some reason the php tags around the exported view led to this comment not displaying correctly when submitted, so I took out those tags and replaced them with === to show where the view starts and ends.

===
$view = new view;
$view->name = 'pending_tasks';
$view->description = 'Pending tasks';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
'2' => 2,
);
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
'title' => 'title',
'field_client_value' => 'field_client_value',
'body' => 'body',
'field_lead_value' => 'field_lead_value',
'field_alternate_value' => 'field_alternate_value',
'field_start_date_value' => 'field_start_date_value',
'field_status_value' => 'field_status_value',
);
$handler->display->display_options['style_options']['default'] = 'field_status_value';
$handler->display->display_options['style_options']['info'] = array(
'title' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
'field_client_value' => array(
'align' => '',
'separator' => '',
),
'body' => array(
'align' => '',
'separator' => '',
),
'field_lead_value' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
'field_alternate_value' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
'field_start_date_value' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
'field_status_value' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = 'Task';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Client (field_client) */
$handler->display->display_options['fields']['field_client_value']['id'] = 'field_client_value';
$handler->display->display_options['fields']['field_client_value']['table'] = 'node_data_field_client';
$handler->display->display_options['fields']['field_client_value']['field'] = 'field_client_value';
$handler->display->display_options['fields']['field_client_value']['label'] = 'Client';
$handler->display->display_options['fields']['field_client_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_client_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_client_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_client_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_client_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_client_value']['link_to_node'] = 0;
/* Field: Content: Start Date (field_start_date) */
$handler->display->display_options['fields']['field_start_date_value']['id'] = 'field_start_date_value';
$handler->display->display_options['fields']['field_start_date_value']['table'] = 'node_data_field_start_date';
$handler->display->display_options['fields']['field_start_date_value']['field'] = 'field_start_date_value';
$handler->display->display_options['fields']['field_start_date_value']['label'] = 'Start Date';
$handler->display->display_options['fields']['field_start_date_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_start_date_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_start_date_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['link_to_node'] = 0;
/* Field: Content: Due Date (field_due_date) */
$handler->display->display_options['fields']['field_due_date_value']['id'] = 'field_due_date_value';
$handler->display->display_options['fields']['field_due_date_value']['table'] = 'node_data_field_due_date';
$handler->display->display_options['fields']['field_due_date_value']['field'] = 'field_due_date_value';
$handler->display->display_options['fields']['field_due_date_value']['label'] = 'Due Date';
$handler->display->display_options['fields']['field_due_date_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_due_date_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_due_date_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['link_to_node'] = 0;
/* Field: Node: Body */
$handler->display->display_options['fields']['body']['id'] = 'body';
$handler->display->display_options['fields']['body']['table'] = 'node_revisions';
$handler->display->display_options['fields']['body']['field'] = 'body';
$handler->display->display_options['fields']['body']['label'] = 'Description';
$handler->display->display_options['fields']['body']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['body']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['body']['alter']['trim'] = 0;
$handler->display->display_options['fields']['body']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['body']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['body']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['body']['alter']['html'] = 0;
$handler->display->display_options['fields']['body']['hide_empty'] = 0;
$handler->display->display_options['fields']['body']['empty_zero'] = 0;
/* Field: Content: Lead (field_lead) */
$handler->display->display_options['fields']['field_lead_value']['id'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['table'] = 'node_data_field_lead';
$handler->display->display_options['fields']['field_lead_value']['field'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['label'] = 'Lead';
$handler->display->display_options['fields']['field_lead_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_lead_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_lead_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_lead_value']['link_to_node'] = 0;
/* Field: Content: Alternate (field_alternate) */
$handler->display->display_options['fields']['field_alternate_value']['id'] = 'field_alternate_value';
$handler->display->display_options['fields']['field_alternate_value']['table'] = 'node_data_field_alternate';
$handler->display->display_options['fields']['field_alternate_value']['field'] = 'field_alternate_value';
$handler->display->display_options['fields']['field_alternate_value']['label'] = 'Alternate';
$handler->display->display_options['fields']['field_alternate_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_alternate_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_alternate_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['link_to_node'] = 0;
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'task' => 'task',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Filter: Content: Status (field_status) - Allowed values */
$handler->display->display_options['filters']['field_status_value_many_to_one']['id'] = 'field_status_value_many_to_one';
$handler->display->display_options['filters']['field_status_value_many_to_one']['table'] = 'node_data_field_status';
$handler->display->display_options['filters']['field_status_value_many_to_one']['field'] = 'field_status_value_many_to_one';
/* Filter: Content: Lead (field_lead) */
$handler->display->display_options['filters']['field_lead_value']['id'] = 'field_lead_value';
$handler->display->display_options['filters']['field_lead_value']['table'] = 'node_data_field_lead';
$handler->display->display_options['filters']['field_lead_value']['field'] = 'field_lead_value';

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = 'Task';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Client (field_client) */
$handler->display->display_options['fields']['field_client_value']['id'] = 'field_client_value';
$handler->display->display_options['fields']['field_client_value']['table'] = 'node_data_field_client';
$handler->display->display_options['fields']['field_client_value']['field'] = 'field_client_value';
$handler->display->display_options['fields']['field_client_value']['label'] = 'Client';
$handler->display->display_options['fields']['field_client_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_client_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_client_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_client_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_client_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_client_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_client_value']['link_to_node'] = 0;
/* Field: Node: Body */
$handler->display->display_options['fields']['body']['id'] = 'body';
$handler->display->display_options['fields']['body']['table'] = 'node_revisions';
$handler->display->display_options['fields']['body']['field'] = 'body';
$handler->display->display_options['fields']['body']['label'] = 'Description';
$handler->display->display_options['fields']['body']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['body']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['body']['alter']['trim'] = 1;
$handler->display->display_options['fields']['body']['alter']['max_length'] = '200';
$handler->display->display_options['fields']['body']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['body']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['body']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['body']['alter']['html'] = 0;
$handler->display->display_options['fields']['body']['hide_empty'] = 0;
$handler->display->display_options['fields']['body']['empty_zero'] = 0;
/* Field: Content: Lead (field_lead) */
$handler->display->display_options['fields']['field_lead_value']['id'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['table'] = 'node_data_field_lead';
$handler->display->display_options['fields']['field_lead_value']['field'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['label'] = 'Lead';
$handler->display->display_options['fields']['field_lead_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_lead_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_lead_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_lead_value']['link_to_node'] = 0;
/* Field: Content: Alternate (field_alternate) */
$handler->display->display_options['fields']['field_alternate_value']['id'] = 'field_alternate_value';
$handler->display->display_options['fields']['field_alternate_value']['table'] = 'node_data_field_alternate';
$handler->display->display_options['fields']['field_alternate_value']['field'] = 'field_alternate_value';
$handler->display->display_options['fields']['field_alternate_value']['label'] = 'Alternate';
$handler->display->display_options['fields']['field_alternate_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_alternate_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_alternate_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_alternate_value']['link_to_node'] = 0;
/* Field: Content: Start Date (field_start_date) */
$handler->display->display_options['fields']['field_start_date_value']['id'] = 'field_start_date_value';
$handler->display->display_options['fields']['field_start_date_value']['table'] = 'node_data_field_start_date';
$handler->display->display_options['fields']['field_start_date_value']['field'] = 'field_start_date_value';
$handler->display->display_options['fields']['field_start_date_value']['label'] = 'Start Date';
$handler->display->display_options['fields']['field_start_date_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_start_date_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_start_date_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_start_date_value']['link_to_node'] = 0;
/* Field: Content: Status (field_status) */
$handler->display->display_options['fields']['field_status_value']['id'] = 'field_status_value';
$handler->display->display_options['fields']['field_status_value']['table'] = 'node_data_field_status';
$handler->display->display_options['fields']['field_status_value']['field'] = 'field_status_value';
$handler->display->display_options['fields']['field_status_value']['label'] = 'Status';
$handler->display->display_options['fields']['field_status_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_status_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_status_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_status_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_status_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_status_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_status_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_status_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_status_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_status_value']['link_to_node'] = 0;
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'task' => 'task',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Filter: Content: Status (field_status) - Allowed values */
$handler->display->display_options['filters']['field_status_value_many_to_one']['id'] = 'field_status_value_many_to_one';
$handler->display->display_options['filters']['field_status_value_many_to_one']['table'] = 'node_data_field_status';
$handler->display->display_options['filters']['field_status_value_many_to_one']['field'] = 'field_status_value_many_to_one';
/* Filter: Content: Lead (field_lead) */
$handler->display->display_options['filters']['field_lead_value']['id'] = 'field_lead_value';
$handler->display->display_options['filters']['field_lead_value']['table'] = 'node_data_field_lead';
$handler->display->display_options['filters']['field_lead_value']['field'] = 'field_lead_value';
$handler->display->display_options['filters']['field_lead_value']['operator'] = 'contains';
$handler->display->display_options['filters']['field_lead_value']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_lead_value']['expose']['operator'] = 'field_lead_value_op';
$handler->display->display_options['filters']['field_lead_value']['expose']['label'] = 'Lead';
$handler->display->display_options['filters']['field_lead_value']['expose']['use_operator'] = 0;
$handler->display->display_options['filters']['field_lead_value']['expose']['identifier'] = 'field_lead_value';
$handler->display->display_options['filters']['field_lead_value']['case'] = 0;
$handler->display->display_options['path'] = 'tasks';

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Pending Tasks';
$handler->display->display_options['defaults']['items_per_page'] = FALSE;
$handler->display->display_options['defaults']['use_more'] = FALSE;
$handler->display->display_options['use_more'] = TRUE;
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
'title' => 'title',
'field_due_date_value' => 'field_due_date_value',
'field_lead_value' => 'field_lead_value',
);
$handler->display->display_options['style_options']['default'] = 'field_due_date_value';
$handler->display->display_options['style_options']['info'] = array(
'title' => array(
'sortable' => 0,
'separator' => '',
),
'field_due_date_value' => array(
'sortable' => 0,
'separator' => '',
),
'field_lead_value' => array(
'sortable' => 0,
'separator' => '',
),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = 'Task';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Due Date (field_due_date) */
$handler->display->display_options['fields']['field_due_date_value']['id'] = 'field_due_date_value';
$handler->display->display_options['fields']['field_due_date_value']['table'] = 'node_data_field_due_date';
$handler->display->display_options['fields']['field_due_date_value']['field'] = 'field_due_date_value';
$handler->display->display_options['fields']['field_due_date_value']['label'] = 'Due Date';
$handler->display->display_options['fields']['field_due_date_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_due_date_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_due_date_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_due_date_value']['link_to_node'] = 0;
/* Field: Content: Lead (field_lead) */
$handler->display->display_options['fields']['field_lead_value']['id'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['table'] = 'node_data_field_lead';
$handler->display->display_options['fields']['field_lead_value']['field'] = 'field_lead_value';
$handler->display->display_options['fields']['field_lead_value']['label'] = 'Lead';
$handler->display->display_options['fields']['field_lead_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_lead_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_lead_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_lead_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_lead_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_lead_value']['link_to_node'] = 0;
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'task' => 'task',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Filter: Content: Status (field_status) - Allowed values */
$handler->display->display_options['filters']['field_status_value_many_to_one']['id'] = 'field_status_value_many_to_one';
$handler->display->display_options['filters']['field_status_value_many_to_one']['table'] = 'node_data_field_status';
$handler->display->display_options['filters']['field_status_value_many_to_one']['field'] = 'field_status_value_many_to_one';
$handler->display->display_options['filters']['field_status_value_many_to_one']['value'] = array(
'Pending' => 'Pending',
'Started' => 'Started',
'On Hold' => 'On Hold',
);
$handler->display->display_options['filters']['field_status_value_many_to_one']['expose']['operator'] = FALSE;
$handler->display->display_options['block_description'] = 'Pending Tasks';
===

Error info:



    * user warning: Unknown column 'node_data_field_status.field_status_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT node.title AS node_title, node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node_data_field_lead.field_lead_value AS node_data_field_lead_field_lead_value, node_data_field_lead.field_alternate_value AS node_data_field_lead_field_alternate_value, node_data_field_lead.field_start_date_value AS node_data_field_lead_field_start_date_value, node_data_field_lead.field_status_value AS node_data_field_lead_field_status_value, node_data_field_status.field_status_value AS node_data_field_lead_field_status_value_1 FROM pentestnode node LEFT JOIN pentestnode_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN pentestcontent_type_task node_data_field_lead ON node.vid = node_data_field_lead.vid WHERE node.type in ('task') ) count_alias in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
    * user warning: Unknown column 'node_data_field_status.field_status_value' in 'field list' query: SELECT node.title AS node_title, node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node_data_field_lead.field_lead_value AS node_data_field_lead_field_lead_value, node_data_field_lead.field_alternate_value AS node_data_field_lead_field_alternate_value, node_data_field_lead.field_start_date_value AS node_data_field_lead_field_start_date_value, node_data_field_lead.field_status_value AS node_data_field_lead_field_status_value, node_data_field_status.field_status_value AS node_data_field_lead_field_status_value_1 FROM pentestnode node LEFT JOIN pentestnode_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN pentestcontent_type_task node_data_field_lead ON node.vid = node_data_field_lead.vid WHERE node.type in ('task') ORDER BY node_data_field_lead_field_status_value_1 ASC LIMIT 0, 10 in /var/www/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

pixlkat’s picture

I have experienced this as well. In my case, it is a VBO view. I don't get the error unless I set the date field to be either sortable in the VBO options list, or in the sort options of the view. I discovered that the query is created correctly if the date field is first in the list of fields to display.

colinjones’s picture

I to had exactly the same problem, with the same version Views. I downgraded to 2.10 and the problem went away completely.

tomsm’s picture

Version: 6.x-3.0-alpha3 » 6.x-3.0-alpha2

I have the same issue with a flag view.
When I click on a column to sort, I get the following error:
user warning: Unknown column 'node_data_field_price.field_price_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid, node_data_field_image.field_image_list AS node_data_field_image_field_image_list, node_data_field_image.field_image_data AS node_data_field_image_field_image_data, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node.title AS node_title, node.language AS node_language, node_data_field_image.field_price_value AS node_data_field_image_field_price_value, node_data_field_image.field_retail_price_value AS node_data_field_image_field_retail_price_value, node_data_field_image.field_export_price_value AS node_data_field_image_field_export_price_value, flag_content_node.timestamp AS flag_content_node_timestamp, node_node__flag_content.content_id AS node_node__flag_content_content_id, node_node.nid AS node_node_nid, node_data_field_price.field_price_value AS node_data_field_image_field_price_value_1 FROM node node LEFT JOIN node node_node ON node.tnid = node_node.nid INNER JOIN flag_content flag_content_node ON node_node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = 1) LEFT JOIN content_type_product node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN flag_content node_node__flag_content ON node_node.nid = node_node__flag_content.content_id AND (node_node__flag_content.fid = 2 AND node_node__flag_content.uid = 1 AND node_node__flag_content.sid = 0) WHERE (node.status <> 0) AND (node.language ='en' OR node.language ='' OR node.language IS NULL) ) count_alias in F:\inetpub\vhosts\fysiomed.com\httpdocs\sites\all\modules\views\plugins\views_plugin_pager.inc on line 134.

I am using alpha3. With alpha1 I did not have this error.

I also have a similar error with a VBO view. I use the latest flag (2.x) and VBO (3.x) module versions.

tomsm’s picture

Version: 6.x-3.0-alpha2 » 6.x-3.0-alpha3

This bug also exists in alpha3

tomsm’s picture

Version: 6.x-3.0-alpha2 » 6.x-3.0-alpha3

Downgrading to alpha1 is not an option, I guess, because of the security issues. Right?

merlinofchaos’s picture

The security issues are all configuration dependent, so analyze them carefully. They shouldn't be much of a concern on a site that isn't in production.

steveg’s picture

FileSize
1.88 KB

It seems the author made a slight oversight in the coding between alpha1 and alpha2 which has not been corrected in alpha3. The following patch will correct it and should solve your problems. It works for me! Patch the alpha3 code with this patch.

dawehner’s picture

Status: Active » Needs work

This looks like wrong code style.

Majdi’s picture

#7 works for me
Thanks

jwjoshuawalker’s picture

Just wanted to report my findings...

I was using a view (Views Calc Table style plugin), and had several columns that were sortable. Upon clicking one, I would get the "user warning: Unknown column..." (yadda yadda) error as well.

I switched to latest 6-3.x-dev (April 18th version) but still had the issue. I looked over the changes in this patch and I think the general idea was moving the:

if (empty($this->fields[$alias])) {

from near the end of the function, and putting it at the top, before the array declaration and while statement like this:

    // Create a field info array.
    if (empty($this->fields[$alias])) {
    $field_info = array(
      'field' => $field,
      'table' => $table,
      'alias' => $alias,
    ) + $params;

And of course delete/comment it out down below (line 672)

This solved all my issues. Again, this was using the latest views 6-3.x-dev (Apr 18th).

dropall’s picture

I had this issue and the patch solved it.

The "click sorting" was not functioning and the patch solved that too.

Unfortunately, the same content is displayed in all the text fields.

Instead of "John|Doe|123|15:30|Apple", I get "John|John|123|15:30|John".

Any idea someone ?

tomsm’s picture

#7 works. Thanks!

dawehner’s picture

Could you please have a look at http://drupal.org/node/859368#comment-3246552 ?

I guess this one is a duplicate of the other issue.

drclaw’s picture

The patch from #7 fixes the issue, but that particular patch file paths looks like it's using windows style paths with backslashes. =P

Here's a new one with unix paths. Also these paths are relative to the views folder itself so you just need to copy it to the top level of the views module and run it with patch -p0 < views_unknown_column.718184_1.patch

drclaw’s picture

Wait, this one's better.

dougm’s picture

I'm seeing the same problem and have used 6.x-2.12, 6.x-3.0-alpha3 and 6.x-3.x-dev with no difference. It had been working. Not sure what I did to break it but it now gets a similar error. One additional data point is that the first two columns still sort but the rest get this error. I can rearrange the columns but the first two work but the rest get the failure.

dougm’s picture

A correction. I just tried 6.x-3.x-dev and it cleared up the problem.

dawehner’s picture

Title: User warning: Unkown column...in field list query... » User warning: Unkown column...in field list query...

fix title

MustangGB’s picture

Status: Needs work » Closed (won't fix)