Contrib.social

Syntax error after configuring view

Open on Drupal.org →
Created on 14 July 2023, over 1 year ago
Updated 12 February 2024, 10 months ago

Problem/Motivation

I'm getting this error after configuring the custom table and add the relationship to the view:

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 '= quizzes.nid LEFT JOIN "quizzes" "quizzes_node" ON quizzes.entity_id = quizz...' at line 5: SELECT "node_field_data"."langcode" AS "node_field_data_langcode", "node_field_data"."created" AS "node_field_data_created", "node_field_data"."nid" AS "nid" FROM "node_field_data" "node_field_data" INNER JOIN "node" "node" ON node_field_data.nid = node.nid LEFT JOIN "quizzes" "quizzes" ON node. = quizzes.nid LEFT JOIN "quizzes" "quizzes_node" ON quizzes.entity_id = quizzes_node.nid WHERE "node_field_data"."status" = :db_condition_placeholder_0 ORDER BY "node_field_data_created" DESC LIMIT 5 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 )
🐛 Bug report
Status

Postponed: needs info

Version

2.0

Component

Code

Created by

🇪🇸Spain guardiola86

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024