This is same error as introduced in 3.21 (mentioned here: https://www.drupal.org/project/views/issues/3040391). Why you release version that claimed to be stable and have this error inside?

Query generated by Views:

SELECT node.title AS node_title, node.created AS node_created, node.nid AS nid, node.language AS node_language, nodequeue_nodes_node.position AS nodequeue_nodes_node_position, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_teaser_node_entity_type, 'node' AS field_data_field_image_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_projectcontact} field_data_field_projectcontact ON node.nid = field_data_field_projectcontact.entity_id AND (field_data_field_projectcontact.entity_type = 'node' AND field_data_field_projectcontact.deleted = '0' AND field_data_field_projectcontact.delta = '0')
LEFT JOIN {users} users_field_data_field_projectcontact ON field_data_field_projectcontact.field_projectcontact_uid = users_field_data_field_projectcontact.uid
LEFT JOIN {nodequeue_nodes} nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND (nodequeue_nodes_node.qid = '4')
INNER JOIN {field_data_field_frontpage_hide} field_data_field_frontpage_hide_value_0 ON node.nid = field_data_field_frontpage_hide_value_0.entity_id AND (field_data_field_frontpage_hide_value_0.entity_type = 'node' AND field_data_field_frontpage_hide_value_0.deleted = '0' AND field_data_field_frontpage_hide_value_0.field_frontpage_hide_value = '1')
WHERE (( (node.type IN  ('article')) AND (node.status = 1 OR (node.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1) AND( (field_data_field_frontpage_hide_value_0.field_frontpage_hide_value = '1') )))
ORDER BY nodequeue_nodes_node_position DESC, node_created DESC
LIMIT 3 OFFSET 1

An error:

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 '))) ORDER BY nodequeue_nodes_node_position DESC, node_created DESC LIMIT 1 OFFSE' at line 5

Comments

codium created an issue. See original summary.

vali hutchison’s picture

vali hutchison commented

If you apply the patch from https://www.drupal.org/project/views/issues/3040391#comment-13045562 it fixes this issue.

codium’s picture

codium commented

@Vali Hutchison. I've already tried, the error is different:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_frontpage_hide_value_0.field_frontpage_hide_value' in 'where clause'

Is this patch working for you?

For me this patch is working only with dev version or downgrade to 3.20.

vali hutchison’s picture

vali hutchison commented

I applied the patch to version 7.x-3.22 and this fixed the same type of "Syntax error or access violation: 1064" error for a view with grouped filters. I haven't had the new error you mention in #3.

codium’s picture

codium commented

For me unfortunately it's not working. Generated SQL query below:

SELECT node.title AS node_title, node.created AS node_created, node.nid AS nid, node.language AS node_language, nodequeue_nodes_node.position AS nodequeue_nodes_node_position, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_teaser_node_entity_type, 'node' AS field_data_field_image_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_projectcontact} field_data_field_projectcontact ON node.nid = field_data_field_projectcontact.entity_id AND (field_data_field_projectcontact.entity_type = 'node' AND field_data_field_projectcontact.deleted = '0' AND field_data_field_projectcontact.delta = '0')
LEFT JOIN {users} users_field_data_field_projectcontact ON field_data_field_projectcontact.field_projectcontact_uid = users_field_data_field_projectcontact.uid
LEFT JOIN {nodequeue_nodes} nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND (nodequeue_nodes_node.qid = '4')
LEFT JOIN {field_data_field_frontpage_hide} field_data_field_frontpage_hide_value_0 ON node.nid = field_data_field_frontpage_hide_value_0.entity_id AND (field_data_field_frontpage_hide_value_0.entity_type = 'node' AND field_data_field_frontpage_hide_value_0.deleted = '0' AND field_data_field_frontpage_hide_value_0.field_frontpage_hide_value = '1')
WHERE (( (node.type IN  ('article')) AND (node.status = 1 OR (node.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1) AND( (field_data_field_frontpage_hide_value_0.field_frontpage_hide_value IS NULL ) )))
ORDER BY nodequeue_nodes_node_position DESC, node_created DESC
LIMIT 3 OFFSET 1

In current dev version (patched already included) everything is fine.

To summary: newest dev version is working (patch already included in newest release), newest stable version (3.22) is not working (with / without patch)

codium’s picture

codium commented
Priority: Critical » Major
damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Active » Closed (duplicate)
Parent issue: » #3040391: 3.21 Regression, malformed SQL: 'Is none of' within grouped exposed filter

7.x-3.22 was released to fix the PHP 5.3 compatibility problems with 7.x-3.21, just like the release notes said. We've been working on resolving other bugs from the 7.x-3.21 release in other issues and are working towards a new stable release. At a guess, this problem was probably resolved by #3040391: 3.21 Regression, malformed SQL: 'Is none of' within grouped exposed filter, I'm glad that the current dev snapshot resolves it for you.