For some reason, when I enable Views data export module in Modules menu, I can't access Configuration menu any more. When I click Configuration or visit /admin/config, I get this error:
__________
PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "WHERE" LINE 1: SHOW VARIABLES WHERE variable_name = 'max_allowed_packet' ^: SHOW VARIABLES WHERE variable_name = :name; Array ( [:name] => max_allowed_packet ) in views_data_export_requirements() (line 130 of /***DIRECTORIES_CENSORED***/sites/all/modules/views_data_export/views_data_export.install).
_________
Other DB and Drupal information:
- Drupal is using PostgreSQL 8.4.9 as it's main DB.
- Drupal version is 7.14.
- PHP version 5.3.14
I should also note, that Views, and Export functionality is functioning properly (I tried to export custom User data, and it worked really well), the only issue is that I can't access Configuration menu.
If you need more info, you can contact me, I'll be glad to give you more info.
Comments
Comment #1
stano.lacko CreditAttribution: stano.lacko commentedProblem is SQL command "SHOW VARIABLES..." which is not inplemented in PostgreSQL and is specific to MySQL.
It's important to delete or connect this section in file views_data_export.install in PostgreSQL.
Comment #2
xatoo CreditAttribution: xatoo commentedThis has been fixed in the current dev version.
#1690438: Fix MySQL-specific code in views_data_export_requirements