Closed (fixed)
Project:
Views (for Drupal 7)
Version:
7.x-3.x-dev
Component:
Views Data
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Jan 2011 at 14:09 UTC
Updated:
20 Jan 2011 at 11:30 UTC
I have the following view:
$view = new view;
$view->name = 'test_search';
$view->description = 'Stellt die Trefferliste und den Search Block des Kleinanzeigenmarktes bereit ';
$view->tag = '';
$view->base_table = 'node';
$view->human_name = 'test_search';
$view->core = 7;
$view->api_version = '3.0-alpha1';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
/* Display: Standards */
$handler = $view->new_display('default', 'Standards', 'default');
$handler->display->display_options['use_more_text'] = 'Weiter';
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Zurücksetzen';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Beträge pro Seite';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 0;
/* Leerer Text: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['label'] = 'Keine Datensätze gefunden';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
$handler->display->display_options['empty']['area']['content'] = 'Zu ihrer Suche wurden keine Anzeigen gefunden.';
$handler->display->display_options['empty']['area']['format'] = 'plain_text';
/* Feld: Felder: field_kaz_image */
$handler->display->display_options['fields']['entity_id_1']['id'] = 'entity_id_1';
$handler->display->display_options['fields']['entity_id_1']['table'] = 'field_data_field_kaz_image';
$handler->display->display_options['fields']['entity_id_1']['field'] = 'entity_id';
$handler->display->display_options['fields']['entity_id_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['entity_id_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['entity_id_1']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['entity_id_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['entity_id_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['entity_id_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['entity_id_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['entity_id_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['entity_id_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['entity_id_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['entity_id_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['entity_id_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['entity_id_1']['click_sort_column'] = 'fid';
$handler->display->display_options['fields']['entity_id_1']['settings'] = array(
'image_style' => 'thumb_treffer',
'image_link' => '',
);
/* Feld: Beitrag: Titel */
$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'] = '';
$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']['absolute'] = 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;
/* Feld: Felder: body */
$handler->display->display_options['fields']['entity_id']['id'] = 'entity_id';
$handler->display->display_options['fields']['entity_id']['table'] = 'field_data_body';
$handler->display->display_options['fields']['entity_id']['field'] = 'entity_id';
$handler->display->display_options['fields']['entity_id']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['entity_id']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['entity_id']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['entity_id']['alter']['trim'] = 0;
$handler->display->display_options['fields']['entity_id']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['entity_id']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['entity_id']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['entity_id']['alter']['html'] = 0;
$handler->display->display_options['fields']['entity_id']['element_label_colon'] = 1;
$handler->display->display_options['fields']['entity_id']['element_default_classes'] = 1;
$handler->display->display_options['fields']['entity_id']['hide_empty'] = 0;
$handler->display->display_options['fields']['entity_id']['empty_zero'] = 0;
$handler->display->display_options['fields']['entity_id']['click_sort_column'] = 'value';
/* Feld: Felder: field_preis */
$handler->display->display_options['fields']['entity_id_2']['id'] = 'entity_id_2';
$handler->display->display_options['fields']['entity_id_2']['table'] = 'field_data_field_preis';
$handler->display->display_options['fields']['entity_id_2']['field'] = 'entity_id';
$handler->display->display_options['fields']['entity_id_2']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['entity_id_2']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['entity_id_2']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['entity_id_2']['alter']['trim'] = 0;
$handler->display->display_options['fields']['entity_id_2']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['entity_id_2']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['entity_id_2']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['entity_id_2']['alter']['html'] = 0;
$handler->display->display_options['fields']['entity_id_2']['element_label_colon'] = 1;
$handler->display->display_options['fields']['entity_id_2']['element_default_classes'] = 1;
$handler->display->display_options['fields']['entity_id_2']['hide_empty'] = 0;
$handler->display->display_options['fields']['entity_id_2']['empty_zero'] = 0;
$handler->display->display_options['fields']['entity_id_2']['click_sort_column'] = 'value';
$handler->display->display_options['fields']['entity_id_2']['settings'] = array(
'thousand_separator' => ' ',
'prefix_suffix' => 1,
);
/* Sortierkriterien: Beitrag: Beitragsdatum */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
/* Filter: Beitrag: Typ */
$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(
'announce' => 'announce',
);
/* Filter: Beitrag: Veröffentlicht */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
/* Filter: Felder: field_parked (field_parked) */
$handler->display->display_options['filters']['field_parked_value']['id'] = 'field_parked_value';
$handler->display->display_options['filters']['field_parked_value']['table'] = 'field_data_field_parked';
$handler->display->display_options['filters']['field_parked_value']['field'] = 'field_parked_value';
$handler->display->display_options['filters']['field_parked_value']['value'] = array(
0 => '0',
);
/* Display: Search Results */
$handler = $view->new_display('page', 'Search Results', 'searchresults');
$handler->display->display_options['defaults']['query'] = FALSE;
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['distinct'] = TRUE;
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
'entity_id_1' => 'entity_id_1',
'title' => 'title',
'entity_id' => 'entity_id',
'field_standort_postcode' => 'field_standort_postcode',
'field_standort_city' => 'field_standort_city',
'created' => 'created',
'entity_id_2' => 'entity_id_2',
);
$handler->display->display_options['style_options']['default'] = 'entity_id_2';
$handler->display->display_options['style_options']['info'] = array(
'entity_id_1' => array(
'sortable' => 0,
'align' => '',
'separator' => '',
),
'title' => array(
'sortable' => 0,
'align' => '',
'separator' => '',
),
'entity_id' => array(
'sortable' => 0,
'align' => '',
'separator' => '',
),
'field_standort_postcode' => array(
'align' => '',
'separator' => '',
),
'field_standort_city' => array(
'align' => '',
'separator' => '',
),
'created' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
'entity_id_2' => array(
'sortable' => 1,
'align' => '',
'separator' => '',
),
);
$handler->display->display_options['style_options']['override'] = 0;
$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']['exposed_block'] = FALSE;
$handler->display->display_options['exposed_block'] = TRUE;
$handler->display->display_options['defaults']['sorts'] = FALSE;
/* Sortierkriterien: Beitrag: Beitragsdatum */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['expose']['label'] = 'Beitrag: Beitragsdatum';
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter: Beitrag: Typ */
$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(
'announce' => 'announce',
);
/* Filter: Beitrag: Veröffentlicht */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
/* Filter: Felder: field_parked (field_parked) */
$handler->display->display_options['filters']['field_parked_value']['id'] = 'field_parked_value';
$handler->display->display_options['filters']['field_parked_value']['table'] = 'field_data_field_parked';
$handler->display->display_options['filters']['field_parked_value']['field'] = 'field_parked_value';
$handler->display->display_options['filters']['field_parked_value']['value'] = array(
0 => '0',
);
$handler->display->display_options['path'] = 'announce/test_results';
$translatables['test_search'] = array(
t('Standards'),
t('Weiter'),
t('Anwenden'),
t('Zurücksetzen'),
t('Sort By'),
t('Asc'),
t('Desc'),
t('Beträge pro Seite'),
t('- All -'),
t('Offset'),
t('Keine Datensätze gefunden'),
t('Zu ihrer Suche wurden keine Anzeigen gefunden.'),
t('field_kaz_image'),
t('body'),
t('field_preis'),
t('Search Results'),
t('Beitrag: Beitragsdatum'),
);
This is the sql:
SELECT field_data_field_kaz_image.entity_id AS field_data_field_kaz_image_entity_id, field_data_field_kaz_image.entity_type AS field_data_field_kaz_image_entity_type, field_data_field_kaz_image.delta AS field_data_field_kaz_image_delta, field_data_field_kaz_image.language AS field_data_field_kaz_image_language, field_data_field_kaz_image.field_kaz_image_fid AS field_data_field_kaz_image_field_kaz_image_fid, field_data_field_kaz_image.field_kaz_image_alt AS field_data_field_kaz_image_field_kaz_image_alt, field_data_field_kaz_image.field_kaz_image_title AS field_data_field_kaz_image_field_kaz_image_title, field_data_field_kaz_image.revision_id AS field_data_field_kaz_image_revision_id, field_data_field_kaz_image.bundle AS field_data_field_kaz_image_bundle, node.title AS node_title, node.nid AS nid, field_data_body.entity_id AS field_data_body_entity_id, field_data_body.entity_type AS field_data_body_entity_type, field_data_body.delta AS field_data_body_delta, field_data_body.language AS field_data_body_language, field_data_body.body_value AS field_data_body_body_value, field_data_body.body_summary AS field_data_body_body_summary, field_data_body.body_format AS field_data_body_body_format, field_data_body.revision_id AS field_data_body_revision_id, field_data_body.bundle AS field_data_body_bundle, field_data_field_preis.entity_id AS field_data_field_preis_entity_id, field_data_field_preis.entity_type AS field_data_field_preis_entity_type, field_data_field_preis.delta AS field_data_field_preis_delta, field_data_field_preis.language AS field_data_field_preis_language, field_data_field_preis.field_preis_value AS field_data_field_preis_field_preis_value, field_data_field_preis.revision_id AS field_data_field_preis_revision_id, field_data_field_preis.bundle AS field_data_field_preis_bundle, node.created AS node_created
FROM
{node} node
LEFT JOIN {field_data_field_parked} field_data_field_parked ON node.nid = field_data_field_parked.entity_id AND (field_data_field_parked.entity_type = :views_join_condition_0 AND field_data_field_parked.deleted = :views_join_condition_1)
LEFT JOIN {field_data_field_kaz_image} field_data_field_kaz_image ON node.nid = field_data_field_kaz_image.entity_id AND (field_data_field_kaz_image.entity_type = :views_join_condition_2 AND field_data_field_kaz_image.deleted = :views_join_condition_3)
LEFT JOIN {field_data_body} field_data_body ON node.nid = field_data_body.entity_id AND (field_data_body.entity_type = :views_join_condition_4 AND field_data_body.deleted = :views_join_condition_5)
LEFT JOIN {field_data_field_preis} field_data_field_preis ON node.nid = field_data_field_preis.entity_id AND (field_data_field_preis.entity_type = :views_join_condition_6 AND field_data_field_preis.deleted = :views_join_condition_7)
WHERE (( (node.type IN ('announce')) AND (node.status = '1') AND (field_data_field_parked.field_parked_value IN ('0')) ))
ORDER BY node_created ASC
LIMIT 10 OFFSET 0
When the record now have an image (field_kaz_image) the body field is empty, when there is no image in the record the body field shows the normal value.
But when I now set the bodyfield before the kaz_image_field in the ui then the bodyfield is in all records correct.
Comments
Comment #1
dawehnerShort question.
Do you have the latest version of both core, ctools and views?
Comment #2
klaus66 commentedYes I have all dev versions from 04.Jan2011
I have debug the results and the bodyfield(entity_id) is empty when there is a value for field_kaz_image(entity_id_1) and when the field_kaz_image come before the bodyfield.
I mean before so:
In the UI I have the following fields (bodyfield empty):
1. title
2. field_kaz_image
3. field_body
4. field_preis
In the UI I have the following fields (bodyfield not empty):
1. title
2. field_body
3. field_kaz_image
4. field_preis
Comment #3
klaus66 commentedI find the problem.
My field "field_kaz_image" is not translatable that means in the table field_confic the column translatable is 0 and the language is always undefined.
When I set my field_kaz_image to translatable = 1 then the view shows me the bodyfield.
But the problem is that my field_kaz_image field should not be translatable.
Comment #4
bojanz commentedThis should be fixed in CVS.
Reopen the issue if it isn't.
Comment #5
klaus66 commentedThanks for answer.
I think it is not fixed.
I try it with field_image and set the translatable column in table field_config to 0.
And then the bodyfield is empty. That was the only change I have made.
Comment #6
dawehnerTake sure that you really have the latest version (alpha1).
This was fixed last day.
Comment #7
klaus66 commentedThanks for answer.
I try it with the new versions (core 7.0, ctools 7.x-1.0-alpha2, views 7.x-3.0-alpha1) and it works fine.
Thank you.
Comment #8
bojanz commentedEither that, or update to the latest dev versions
However, I'm not sure that today's dev version contains the latest code (dereine was committing until late at night), you might need to wait for tomorrow's version.
Comment #9
klaus66 commentedThanks for answer.
I try it with the new versions (core 7.0, ctools 7.x-1.0-alpha2, views 7.x-3.0-alpha1) and it works fine.
Thank you.