When i try to build a CSV file the batch fails with this:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=4777&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'admin_iaml.views_data_export_index_2' doesn't exist: SELECT * FROM {views_data_export_index_2} ORDER BY vde_weight ASC LIMIT 0, 100; Array ( ) in views_data_export_plugin_display_export->query() (line 499 of /home/admin/public_html/iaml/sites/all/modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).

I have this same view running on a different site and it works fine; so interference with something on this site.

It looked a little like error here: #1822916: Error 'Base table or view not found:' when VDE-display is batched and cached. but i do not have caching enabled for this view.

Comments

liquidcms created an issue. See original summary.

liquidcms’s picture

Title: Building export fails with ajax error » Building export fails with ajax error: Base table or view not found
Augusto182’s picture

Same problem.

Traying to add "group by" using views query alter.

PapaGrande’s picture

Status: Active » Closed (duplicate)
Related issues: +#2209853: Exception caused by MySQL 5.6 gtid replication