Views 2 creates the following SQL:

SELECT node.title AS node_title,
node.nid AS nid,
votingapi_vote_node.value_type AS votingapi_vote_node_value_type,
votingapi_vote_node.value AS votingapi_vote_node_value,
votingapi_vote_node.timestamp AS votingapi_vote_node_timestamp,
votingapi_vote.timestamp AS votingapi_vote_node_timestamp_1
FROM node node
INNER JOIN votingapi_vote votingapi_vote_node ON node.nid = votingapi_vote_node.content_id AND votingapi_vote_node.content_type = 'advpoll'
WHERE (node.status <> 0) AND (votingapi_vote_node.value IS NOT NULL) AND (votingapi_vote_node.uid = 1)
ORDER BY votingapi_vote_node_timestamp_1 DESC

There is a syntax error in the above SQL statement.
The line directly before "FROM node node" reads
votingapi_vote.timestamp AS votingapi_vote_node_timestamp_1
It should read
votingapi_vote_node.timestamp AS votingapi_vote_node_timestamp_1
The _node is missing.

If you try to execute the statement in MySQL, it gives the following error:
#1054 - Unknown column 'votingapi_vote.timestamp' in 'field list'

I've been trying to fix this myself, but have spent too much time in trying to figure out the code. Hope someone can help me out real soon.

By the way, I'm using the Advanced Poll module.

Thanks.

Comments

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Postponed (maintainer needs more info)

There are reasons why http://drupal.org/node/571990 exists

There you can read for example that you should export your view.... or make an easier view, so the problem is reproducable....

dilvish’s picture

dilvish commented
Title: MySQL said: #1054 - Unknown column 'votingapi_vote.timestamp' in 'field list' » User warning: Unkown column...in field list query...
Component: poll data » Miscellaneous
Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Active

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.
dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Postponed (maintainer needs more info)

Thats 100% not the right export. You don't have cck fields in your query. But you don't have votingapi in your export

dilvish’s picture

dilvish commented
Status: Postponed (maintainer needs more info) » Active

I believe that's the right export for my point, I'm hijacking the thread since I'm pretty sure it's a similar issue to the one I found and the original complaint was mislabeled and misleading. I believe this is a problem with the Views query structure. The export and error message map to my View of a list of Task content nodes. The error message appears if I try to include the Due Date and/or Status fields.

dawehner’s picture

dawehner
Primary language German
commented

I'm totally confused.... Why did you hijacked this issue? I'm sorry, but i'm confused :)

dilvish’s picture

dilvish commented

I suspect it's the same core issue with the 3.0-alpha2 code. If it's not, I'm happy to open a new issue. The error's look similar to my novice eye. Just let me know what's best for you.

merlinofchaos’s picture

merlinofchaos commented

It's hard to tell if they're related. My initial inclination on the first one is that, because the table name is actually different from what is expected, there's a problem with voting api views integration with Views 3.

In your case, the table is actually missing from the JOIN completely and that looks different. I recommend a different issue.

dilvish’s picture

dilvish commented
Title: User warning: Unkown column...in field list query... » MySQL said: #1054 - Unknown column 'votingapi_vote.timestamp' in 'field list'
Component: Miscellaneous » poll data
Status: Active » Closed (fixed)

Moving to a new issue, #718184: User warning: Unkown column...in field list query...

n00b0101’s picture

n00b0101 commented

I ran into this error as well... Not sure if it's related to this particular instance, but I posted about it in the votingapi issue cue:

http://drupal.org/node/1192500