- 🇧🇾Belarus dewalt
Duplicates #2929733 🐛 SQL query error on PostgreSQL 9.5 when try to list Bookmarks Active older one.
When trying to create a view to display flagged items, I keep receiving the below error. I've tried different Versions of the module but receive the same error. Using Drupal 9.3.3
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Flag Followers[flag_followers]: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: bigint = character varying LINE 6: ...lagging_users_field_data" ON users_field_data.uid = flagging... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "users_field_data" "users_field_data" INNER JOIN "flagging" "flagging_users_field_data" ON users_field_data.uid = flagging_users_field_data.entity_id AND (flagging_users_field_data.flag_id = :views_join_condition_0 AND flagging_users_field_data.uid = :views_join_condition_1) LEFT JOIN "flag_counts" "flagging_users_field_data__flag_counts" ON flagging_users_field_data.flag_id = flagging_users_field_data__flag_counts.flag_id AND flagging_users_field_data__flag_counts.entity_id = flagging_users_field_data.entity_id WHERE "users_field_data"."status" = :db_condition_placeholder_0) "subquery"; Array ( [:db_condition_placeholder_0] => 1 [:views_join_condition_0] => following [:views_join_condition_1] => 1 ) in main() (line 19 of index.php).
Closed: duplicate
Views integration
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Duplicates #2929733 🐛 SQL query error on PostgreSQL 9.5 when try to list Bookmarks Active older one.