Web server: Apache/2.4.25 (Red Hat)
Database: PostgreSQL version 10.0
Drupal: version 8.4.2
Installed profile: OpenSocial social-8.x-1.7
Our team is working on making the message stack works in a project.
Once user is subscribe to a content and we view the user's message_subscribe_ui page on user/4/message-subscribewe are getting The website encountered an unexpected error. page with the error message below. We have already enabled flag on content and testing user's subscription.
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Subscribe node[subscribe_node]: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: bigint = character varying LINE 4: ...g flagging_node_field_data ON node_field_data.nid = flagging... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: SELECT node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, flagging_node_field_data.id AS flagging_node_field_data_id FROM {node_field_data} node_field_data INNER JOIN {flagging} flagging_node_field_data ON node_field_data.nid = flagging_node_field_data.entity_id AND flagging_node_field_data.flag_id = :views_join_condition_0 WHERE ((flagging_node_field_data.uid = :flagging_uid )) AND (node_field_data.status = :db_condition_placeholder_1) ORDER BY node_field_data_created DESC NULLS LAST LIMIT 11 OFFSET 0; Array ( [:flagging_uid] => 4 [:db_condition_placeholder_1] => 1 [:views_join_condition_0] => subscribe_node ) in Drupal\views\Plugin\views\query\Sql->execute() (line 1489 of /opt/app-root/src/core/modules/views/src/Plugin/views/query/Sql.php).
Closed: works as designed
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I think this is part of a larger issue with the flag module not being compatible with PostgreSQL.
https://www.drupal.org/project/issues/flag?text=postgresql&status=Open&p... →
The issue is with how flag stores the flagged entity id as a string to handled content entities and config entities. PostgreSQL doesn't do implicit integer to string conversion.