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

steven jones’s picture

Status: Active » Fixed

Thanks for the report. A fix has committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.