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
Comment | File | Size | Author |
---|---|---|---|
Screen Shot 2017-03-27 at 10.15.16 AM.png | 25.34 KB | skessler |
Comments
Comment #2
skesslerI rebuilt the view and it has been completely resolved. I made the same View with the settings. I have no idea.
-Steve