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).
Active
1.0
Code
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.