No operator matches the given name and argument type

[johnreytanquinco]

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 when view the user's message_subscribe_ui page on user/4/message-subscribe we are getting result The website encountered an unexpected error. with the error message below. We have already enabled flag on content to 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).