Closed (duplicate)
Project:
Date
Version:
7.x-2.6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
30 Aug 2013 at 13:24 UTC
Updated:
27 Sep 2013 at 11:38 UTC
file : date_views_filter_handler.inc
function : date_combine_conditions
lines : 60-64
if ($field['table_name'] != $this->table || !empty($this->relationship)) {
$this->related_table_alias = $this->query->ensure_table($field['table_name'], $this->relationship);
}
$table_alias = !empty($this->related_table_alias) ? $this->related_table_alias : $field['table_name'];
$field_name = $table_alias . '.' . $field['field_name'];
Problem : When combining a custom Date field with the node's creation property, and only if the field is "above" 'Content: Post date' in the additional settings form, the query produced tries to access the following:
field_data_field_my_custom_date_field.created instead of node.created
thus producing the error:
Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_my_custom_date_field.created'
I cannot yet pinpoint why this is happening.
If the field in question appears "below" 'Content: Post date' in the filter's additional settings form, it works perfectly.
Comments
Comment #0.0
magtak commentedformatting
Comment #1
leewillis77 commentedThis is a duplicate of https://drupal.org/node/2072679 which contains a patch. Please do test the patch there and confirms it works for you.
Comment #2
magtak commentedSure thing, will do. Thanks and sorry for the dupe.
Comment #2.0
magtak commentedmore information