When I'm trying to add a filter on a field that comes from a relationship, I get an error when I try to save the view:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /admin/structure/views/view/presentations_dop/preview/page/ajax
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= node_field_data_field_presentation_collection.nid
WHERE (( (node.nid IN ('1065' at line 1: SELECT DISTINCT node_field_data_field_presentation_collection.title AS node_field_data_field_presentation_collection_title
FROM
{node} node
LEFT JOIN {node} node_field_data_field_presentation_collection ON .field_presentation_collection_nid = node_field_data_field_presentation_collection.nid
WHERE (( (node.nid IN (:oids_0, :oids_1, :oids_2, :oids_3, :oids_4, :oids_5, :oids_6, :oids_7, :oids_8, :oids_9, :oids_10, :oids_11, :oids_12, :oids_13, :oids_14, :oids_15, :oids_16, :oids_17, :oids_18, :oids_19, :oids_20, :oids_21, :oids_22, :oids_23, :oids_24, :oids_25, :oids_26, :oids_27, :oids_28, :oids_29, :oids_30, :oids_31, :oids_32, :oids_33, :oids_34, :oids_35, :oids_36, :oids_37, :oids_38, :oids_39, :oids_40, :oids_41, :oids_42, :oids_43, :oids_44, :oids_45, :oids_46, :oids_47, :oids_48, :oids_49, :oids_50, :oids_51, :oids_52, :oids_53, :oids_54, :oids_55, :oids_56, :oids_57, :oids_58, :oids_59, :oids_60, :oids_61, :oids_62, :oids_63, :oids_64, :oids_65, :oids_66, :oids_67, :oids_68, :oids_69, :oids_70, :oids_71, :oids_72, :oids_73, :oids_74, :oids_75, :oids_76)) )); Array
(
[:oids_0] => 10652
[:oids_1] => 10636
[:oids_2] => 10646
[:oids_3] => 10653
[:oids_4] => 10647
[:oids_5] => 10637
[:oids_6] => 10638
[:oids_7] => 10648
[:oids_8] => 10654
[:oids_9] => 10649
[:oids_10] => 10655
[:oids_11] => 10639
[:oids_12] => 10656
[:oids_13] => 10650
[:oids_14] => 10640
[:oids_15] => 10651
[:oids_16] => 10657
[:oids_17] => 10641
[:oids_18] => 10658
[:oids_19] => 10642
[:oids_20] => 10643
[:oids_21] => 10659
[:oids_22] => 10644
[:oids_23] => 14444
[:oids_24] => 14433
[:oids_25] => 14439
[:oids_26] => 14448
[:oids_27] => 10645
[:oids_28] => 14434
[:oids_29] => 14440
[:oids_30] => 14449
[:oids_31] => 14445
[:oids_32] => 14435
[:oids_33] => 14441
[:oids_34] => 14450
[:oids_35] => 14446
[:oids_36] => 14436
[:oids_37] => 14442
[:oids_38] => 14447
[:oids_39] => 14451
[:oids_40] => 14437
[:oids_41] => 14443
[:oids_42] => 14438
[:oids_43] => 11330
[:oids_44] => 11329
[:oids_45] => 12303
[:oids_46] => 24
[:oids_47] => 23
[:oids_48] => 12304
[:oids_49] => 14277
[:oids_50] => 20
[:oids_51] => 12305
[:oids_52] => 22
[:oids_53] => 32
[:oids_54] => 13859
[:oids_55] => 28
[:oids_56] => 33
[:oids_57] => 18
[:oids_58] => 30
[:oids_59] => 36
[:oids_60] => 14278
[:oids_61] => 19
[:oids_62] => 35
[:oids_63] => 17
[:oids_64] => 16
[:oids_65] => 25
[:oids_66] => 12306
[:oids_67] => 34
[:oids_68] => 27
[:oids_69] => 27
[:oids_70] => 14527
[:oids_71] => 21
[:oids_72] => 31
[:oids_73] => 12307
[:oids_74] => 15
[:oids_75] => 26
[:oids_76] => 29
)
in _views_filter_selective_query() (line 85 of /var/www/html/sites/all/modules/views_hacks/views_filters_selective/views_filters_selective.module).

When I select "Do not use a relationship", the saving works fine but of course it doesn't function as I want since the filter doesn't show me the right info as the relationship is gone.

I have tried both the currentl alpha2 and dev version and have the same problem...

Comments

infojunkie’s picture

Status: Active » Closed (duplicate)