I was setting up a view field and recived the following error in d7 alpha 7:
"An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /?q=admin/structure/views/ajax/preview/VIEW-TITLE
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.status0ORnode.uidusercurrentuserANDusercurrentuser0ANDnodev' in 'where clause': SELECT COUNT(*) AS expression
FROM
(SELECT field_data_field_image.entity_id AS field_data_field_image_entity_id, field_data_field_image.etid AS field_data_field_image_etid, 1 AS expression
FROM
{node} node
INNER JOIN {taxonomy_index} taxonomy_index ON node.nid = taxonomy_index.nid
LEFT JOIN {field_data_field_image} field_data_field_image ON node.nid = field_data_field_image.entity_id AND field_data_field_image.etid = :views_join_condition_0
WHERE (( (node.status0ORnode.uidusercurrentuserANDusercurrentuser0ANDnodeviewownunpublishednodes1ORnodeadministernodes1 IS NULL ) AND (node.type IN (:db_condition_placeholder_0)) AND (taxonomy_index.tid IN (:db_condition_placeholder_1)) ))) subquery; Array
(
[:db_condition_placeholder_0] => portfolio_piece
[:db_condition_placeholder_1] => 2
[:views_join_condition_0] => 1
)
in views_plugin_pager->execute_count_query() (line 141 of /home/XXX/public_html/XXX/sites/all/modules/views/plugins/views_plugin_pager.inc)."
Comments
Comment #1
dawehnerPlease update to the latest version. It's fixed already
Comment #2
ruralrooster commentedIndeed fixed by latest update. THX for the dedicated and great work!