Closed (duplicate)
Project:
Views (for Drupal 7)
Version:
7.x-3.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
3 Aug 2010 at 11:48 UTC
Updated:
3 Aug 2010 at 12:03 UTC
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
Comment #1
dawehnerPlease search first the issue queue next time :)
http://drupal.org/node/799604