User groups list does not work for hashed content types

PR ready for review: https://github.com/goalgorilla/open_social/pull/4183

zanvidmar → credited orest0402 → .

zanvidmar → credited mariiadeny → .

Reviewed and approved by mariiadeny and orest0402

This issue has been fixed, the changes will land on open_social version 12.4.6 and higher.

After the update I get the following error:

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Benutzer Gruppen[groups]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gc.plugin_id' in 'where clause': SELECT "groups_field_data"."created" AS "groups_field_data_created", "groups_field_data"."label" AS "groups_field_data_label", "groups_field_data"."id" AS "id" FROM "groups_field_data" "groups_field_data" INNER JOIN "groups" "groups" ON groups_field_data.id = groups.id WHERE ("groups"."id" IN (SELECT "gc"."gid" AS "gid" FROM "group_content_field_data" "gc" WHERE ("gc"."entity_id" = :db_condition_placeholder_0) AND ("gc"."plugin_id" LIKE :db_condition_placeholder_1 ESCAPE '\\'))) AND ("groups_field_data"."default_langcode" = :db_condition_placeholder_2) ORDER BY "groups_field_data_created" DESC, "groups_field_data_label" ASC LIMIT 3 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => %membership% [:db_condition_placeholder_2] => 1 ) in main() (Zeile 19 in /os/html/index.php).

@corn696, plese provide more detailed steps to reproduce, Open Social and Group module version used and the database structure for group_relationship_field_data table. Thank you.

Thank you for the response. The initial installation was on OS 7.

The error occurs when updating from OS 12.4.5 to OS 12.4.6, which introduces the change mentioned in this issue. The condition was updated to use gc.plugin_id instead of gc.type.

The group version should be locked by OS? Currently, it’s Group 8.x-1.6 (1.6.0).

It seems that the group_relationship_field_data table does not exist at all.

This issue has very specific change -> https://github.com/goalgorilla/open_social/pull/4183/files.
If group_relationship_field_data does not exist at all, this issue has nothing to do with it.
This is related issue https://www.drupal.org/project/social/issues/3298886 🐛 GroupStatistics::count() Does not work for hashed content types Needs review but I doubt that it has to do something with the mentioned bug.

Can you please add error trace or specify which method is throwing this error? Also please provide more detailed steps to reproduce - so what page are you trying to load. Thank you.

this issue has nothing to do with it.

Indeed, seems so. If i rollback the line a different error gets thrown.

Can you please add error trace or specify which method is throwing this error?

I created a new issue: Group plugin_id not found 🐛 Group plugin_id not found Active

I was able to reproduce the bug and added steps to reproduce to mentioned issue.

Automatically closed - issue fixed for 2 weeks with no activity.