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

dawehner’s picture

Short question.

Do you have the latest version of both core, ctools and views?

klaus66’s picture

Yes 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

klaus66’s picture

I 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.

bojanz’s picture

Status: Active » Fixed

This should be fixed in CVS.
Reopen the issue if it isn't.

klaus66’s picture

Thanks 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.

dawehner’s picture

Take sure that you really have the latest version (alpha1).

This was fixed last day.

klaus66’s picture

Thanks 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.

bojanz’s picture

Either 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.

klaus66’s picture

Thanks 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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.