when having the filter "published or admin" in my data export display i receive the following error:
Debug:
'Exception: 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 \'***CURRENT_USER*** AND ***CURRENT_USER*** <> 0 AND ***VIEW_OWN_UNPUBLISHED_NODES\' at line 1'
in views_data_export_plugin_query_default_batched->execute() (line 813 of /.../modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).
Error messagePDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mysite.views_data_export_index_11' doesn't exist: SELECT COUNT(*) FROM {views_data_export_index_11}; Array ( ) in views_data_export_plugin_display_export->execute_initial() (line 248 of /.../modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).
as a workaround using filter "published" instead of "published or admin" worked for me
Comments
Comment #1
steven jones commentedThanks for the report. A fix has committed.