I have a table that has column sort enabled as well as three exposed filters. If I use one of the filters to narrow the view and then attempt to sort on a column heading, the last of the exposed filters gets the text "Array" inserted and the view finds nothing. It doesn't matter which exposed filter I use, the last gets the text added (appended). The filters by themselves or the sorting by itself work fine. This can be seen on this page: http://didea.3acres.org/ColorChart

This happens with both the current and previous -dev release. I can't use the alpha or official release due to other problems where sort doesn't work at all (http://drupal.org/node/718184).

Comments

rbosscher’s picture

rbosscher commented

I have the same problem.
I use also the dev release.
Mine is trowing this error...

user warning: Unknown column 'node_data_field_lastname.field_lastname_value' in 'field list' query: SELECT COUNT(*) FROM (SELECT users.picture AS users_picture, users.uid AS uid, users.name AS users_name, users.mail AS users_mail, node_users_node_data_field_firstname.field_firstname_value AS node_users_node_data_field_firstname_field_firstname_value, node_users.type AS node_users_type, node_users.nid AS node_users_nid, node_users.vid AS node_users_vid, node_users_node_data_field_firstname.field_lastname_value AS node_users_node_data_field_firstname_field_lastname_value, node_users_node_data_field_company_name.field_company_name_value AS node_users_node_data_field_company_name_field_company_name_v, node_users_node_data_field_firstname.field_country_value AS node_users_node_data_field_firstname_field_country_value, node_data_field_lastname.field_lastname_value AS node_users_node_data_field_firstname_field_lastname_value_1 FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile' LEFT JOIN og_uid og_uid ON users.uid = og_uid.uid LEFT JOIN node node_og_uid ON og_uid.nid = node_og_uid.nid LEFT JOIN content_field_expertise node_users_node_data_field_expertise ON node_users.vid = node_users_node_data_field_expertise.vid LEFT JOIN content_type_profile node_users_node_data_field_firstname ON node_users.vid = node_users_node_data_field_firstname.vid LEFT JOIN content_field_company_name node_users_node_data_field_company_name ON node_users.vid = node_users_node_data_field_company_name.vid ) count_alias in /home/raetscom/public_html/dev/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
user warning: Unknown column 'node_data_field_lastname.field_lastname_value' in 'field list' query: SELECT users.picture AS users_picture, users.uid AS uid, users.name AS users_name, users.mail AS users_mail, node_users_node_data_field_firstname.field_firstname_value AS node_users_node_data_field_firstname_field_firstname_value, node_users.type AS node_users_type, node_users.nid AS node_users_nid, node_users.vid AS node_users_vid, node_users_node_data_field_firstname.field_lastname_value AS node_users_node_data_field_firstname_field_lastname_value, node_users_node_data_field_company_name.field_company_name_value AS node_users_node_data_field_company_name_field_company_name_v, node_users_node_data_field_firstname.field_country_value AS node_users_node_data_field_firstname_field_country_value, node_data_field_lastname.field_lastname_value AS node_users_node_data_field_firstname_field_lastname_value_1 FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile' LEFT JOIN og_uid og_uid ON users.uid = og_uid.uid LEFT JOIN node node_og_uid ON og_uid.nid = node_og_uid.nid LEFT JOIN content_field_expertise node_users_node_data_field_expertise ON node_users.vid = node_users_node_data_field_expertise.vid LEFT JOIN content_type_profile node_users_node_data_field_firstname ON node_users.vid = node_users_node_data_field_firstname.vid LEFT JOIN content_field_company_name node_users_node_data_field_company_name ON node_users.vid = node_users_node_data_field_company_name.vid ORDER BY node_users_node_data_field_firstname_field_lastname_value_1 ASC in /home/raetscom/public_html/dev/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1096.
landing’s picture

landing commented

I've got the same problem

dww’s picture

dww
we/he/they
commented
Status: Active » Closed (duplicate)

Even though this is the older issue, let's continue the discussion at #1188828: Exposed filters mess up click sortable columns since that has a clearer description of the problem and a working patch. Everyone in here having trouble, please try applying the patch from #1188828 and reply there to confirm it solves your problems.

Thanks,
-Derek

dawehner’s picture

dawehner
Primary language German
commented
Title: exposed filters and table sort not getting along » exposed filters and table sort not getting along

fix title