I found an issue when trying to export when a select list (text) field has more than one value selected as a filter criterion in the View. In my example, each of these fields will always only have one value to export. Here is the error message.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname_drupal.views_data_export_index_81' doesn't exist: SELECT * FROM {views_data_export_index_81} ORDER BY vde_weight ASC LIMIT 0, 100; Array ( ) in views_data_export_plugin_display_export->query() (line 525 of /home/user/public_html/sites/all/modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).

There is also this User Notice right before the exception.
'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 \'AS field_data_field_name_, field_data_field_p_o_c_.field_p_o_c__value AS field_d\' at line 1'
in views_data_export_plugin_query_default_batched->execute() (line 956 of /home/user/public_html/sites/all/modules/views_data_export/plugins/views_data_export_plugin_display_export.inc).

We have no issue with any other exports. If you only select one value from the select list then it works like a charm. Attached is a screenshot with an example of the select field.

We are running Views 7.x-3.15 and Views data export 7.x-3.1 on Apache 2.4 with PHP 5.6 and MySQL 5.6.

Thanks,
Steve

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

skessler created an issue. See original summary.

skessler’s picture

Status: Active » Closed (cannot reproduce)

I rebuilt the view and it has been completely resolved. I made the same View with the settings. I have no idea.

-Steve