Contrib.social
Created on 23 May 2024, 8 months ago

Problem/Motivation

Just enabled the module and open the report page gets me this error. The module is not usable. We're running on PHP 8.3.6 and MySQL 8.0.19.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.parent_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT t.parent_type, t.entity_type, CONCAT(t.parent_type, ':', t.entity_type) AS composite_type FROM (SELECT p.id, p.type, p.status, p.parent_id, p.parent_type, p.parent_field_name, n.type AS entity_type, 1 AS is_active FROM paragraphs_item_field_data AS p LEFT JOIN node_field_data AS n ON n.nid = p.parent_id AND p.parent_type = 'node' WHERE p.parent_type = 'node' UNION SELECT p.id, p.type, p.status, p.parent_id, p.parent_type, p.parent_field_name, n.type AS entity_type, 1 AS is_active FROM paragraphs_item_field_data AS p LEFT JOIN paragraphs_item_field_data AS n ON n.id = p.parent_id AND p.parent_type = 'paragraph' WHERE p.parent_type = 'paragraph') t WHERE t.entity_type IS NOT NULL AND t.is_active <> '' GROUP BY composite_type ORDER BY composite_type; Array ( ) in Drupal\ps\ParagraphsStats->getAllUsedBundleTypes() (line 779 of modules/contrib/ps/src/ParagraphsStats.php).

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

1.0

Component

Code

Created by

🇩🇪Germany droprocker

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

Merge Requests

Comments & Activities

  • Issue created by @droprocker
  • Comment 8 months ago →
    🇩🇪Germany droprocker
  • First commit to issue fork.
  • Comment 4 months ago →
    🇦🇺Australia oceanic Melbourne, Victoria

    I've made a quick fix for this, adding the nonaggregated column "t.parent_type" to the GROUP BY clause, which still gives me the same output as the query beforehand and should fix the issue.

  • Merge request !3Correct MySQL strict GROUP BY error in PS query → (Open) created by pfrenssen
  • Comment about 19 hours ago →
    🇧🇬Bulgaria pfrenssen Sofia

    I can confirm the patch fixes the reported error. There are some other queries that also need to be updated to be compatible with only_full_group_by. Let's fix those also in scope of this issue.

    Example:

    Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.entity_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
contrib.social Blog FAQ Discussions
Production build 0.71.5 2024