I am using view 7.x-3.10 With I created one view with attachment and used term filter with views_selective_filters module. It shows

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS - row name.

Comments

artatum’s picture

artatum CreditAttribution: artatum commented
Category: Support request » Bug report

I've got a similar one :
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_latlon_, node.uid AS node_uid, field_data_field_photo. AS fi' at line 1
My field is a taxonomy vocabulary.

david_garcia’s picture

david_garcia CreditAttribution: david_garcia commented
Category: Bug report » Support request
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Only tested on MSSQL.

Provide proper issue description, technical details and patch.

artatum’s picture

artatum CreditAttribution: artatum commented

Hi
I have a View page with an attachment, a leaflet map. If I add the filter in the attachement I got no message, but if I add it to the page, I got this message. And the module does nothing.