After enabling this filter an AJAX error is shown. The filter 'Published' works allright. Below is the error message:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /admin/structure/views/ajax/preview/pics
StatusText: Internal Server Error
ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.status0ORnode.uidusercurrentuserANDusercurrentuser0ANDnodeviewownunpublishednodes1ORnodeadministernodes1' in 'where clause': SELECT COUNT(*) AS expression
FROM 
(SELECT field_data_field_pic.entity_id AS field_data_field_pic_entity_id, field_data_field_pic.etid AS field_data_field_pic_etid
FROM 
{node} node
LEFT JOIN {field_data_field_pic} field_data_field_pic ON node.nid = field_data_field_pic.entity_id AND field_data_field_pic.etid = :views_join_condition_0
WHERE (( (node.type IN  (:db_condition_placeholder_0)) AND (node.status0ORnode.uidusercurrentuserANDusercurrentuser0ANDnodeviewownunpublishednodes1ORnodeadministernodes1 IS NULL ) ))) subquery; Array
(
[:db_condition_placeholder_0] => referentie
[:views_join_condition_0] => 1
)
in views_plugin_pager->execute_count_query() (line 141 of /Users/ericsol/Documents/webroot/drupal7/sites/all/modules/views/plugins/views_plugin_pager.inc).

Comments

dawehner’s picture

Status: Active » Closed (duplicate)

Please search first the issue queue next time :)

http://drupal.org/node/799604