I have a content type akce_skoly with a date field. When I create a block view with fields, it is OK. But when I want to create a page view based on nodes (not on fields), I obtain an error message:
user warning: Unknown column 'node_data_field_datum.delta' in 'on clause' query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node LEFT JOIN content_type_akce_skoly node_data_field_datum ON node.vid = node_data_field_datum.vid AND node_data_field_datum.delta = 0 WHERE (node.type in ('akce_skoly')) AND (node.status <> 0) ) count_alias in C:\Program Files\VertrigoServ\www\souvolyne\sites\all\modules\views\includes\view.inc on line 705.
user warning: Unknown column 'node_data_field_datum.delta' in 'on clause' query: SELECT node.nid AS nid, node_data_field_datum.field_datum_value AS node_data_field_datum_field_datum_value FROM node node LEFT JOIN content_type_akce_skoly node_data_field_datum ON node.vid = node_data_field_datum.vid AND node_data_field_datum.delta = 0 WHERE (node.type in ('akce_skoly')) AND (node.status <> 0) ORDER BY node_data_field_datum_field_datum_value ASC LIMIT 0, 10 in C:\Program Files\VertrigoServ\www\souvolyne\sites\all\modules\views\includes\view.inc on line 731.
Thank you in advance for help.
(I use PHP 5.2.5, Exported view and date field are attached).

CommentFileSizeAuthor
view_akce_skoly.txt9.17 KBmy-family
content_type_akce_skoly.txt3.64 KBmy-family

Comments

my-family’s picture

my-family commented

I have already found the origin of the problem (I mean origin in the settings, but I don´t know, where is the problem in code, if any). Former, the date field had the setting "Number of values: Unlimited"... and i changed it to "1". This caused the problem; after changing it back, the view - display type "page", even with row style: nodes, works well. Is it normal, that such a change in field settings causes so big problem? Is it possible to change this settings, or NOT? (there were NO data in additional fields).
Thank you in advacne.

arlinsandbulte’s picture

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

Is this still valid?
Please try testing the latest release or -dev

Thanks

arlinsandbulte’s picture

arlinsandbulte commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

no followup after more than two months at "postponed (maintainer needs more info)"
Marking as closed.

BTW: this might perhaps be fixed by #580178: Views: SQL Error "Unknown column" when using fields from different content-types in a filter
Or, there are other unknown column errors out there too. perhaps one of them is a dupe of this.

my-family’s picture

my-family commented

@arlinsandbulte: Sorry... I was not able to test the problem after more than 1 year (!!!) (I believe that the delay is not your fault personally, but neither mine). The original development environment does not exist any more, I had to solve my problem myself and had to use completely different solution that time. Anywyay, thanks for your suggestion.