Subgroup cannot be created with MSSQL
>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #1228300. --> Reported by: [kpastore](https://www.drupal.org/user/567168) >>> <p>When attempting to create a content type with the attributes of being both a group and content of a group, og fails when using SQL Server (MS SQL). The content type can be created, but when trying to add content of that type, the following error appears:</p> <blockquote><p><em>PDOException: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value '2.0' to data type int.: SELECT base.[gid] AS [gid], base.[etid] AS [etid], base.[entity_type] AS [entity_type], base.[label] AS [label], base.[state] AS [state], base.[created] AS [created] FROM {og} base WHERE ( ([base].[gid] IN (:db_condition_placeholder_0, :db_condition_placeholder_1)) ); Array ( [:db_condition_placeholder_0] =&gt; 1.0 [:db_condition_placeholder_1] =&gt; 2.0 ) in EntityAPIController-&gt;query() (line 143 of \sites\all\modules\entity\includes\entity.controller.inc).</em></p></blockquote>
issue