After submitting a private message I get this error

PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'LIMIT'.: SELECT pmi.[recipient] AS [recipient], pmi.[type] AS [type], u.[name] AS [name], pmi.recipient AS _field_0, u.name AS _field_1, pmi.type AS _field_2 FROM {pm_index} pmi LEFT OUTER JOIN {users} u ON u.uid = pmi.recipient AND pmi.type IN ('user', 'hidden') WHERE ( ([pmi].[thread_id] = :db_condition_placeholder_0) AND( ([pmi].[type] <> :db_condition_placeholder_1) OR( ([pmi].[type] = :db_condition_placeholder_2) AND ([pmi].[recipient] = :db_condition_placeholder_3) ))AND ((SELECT 1 FROM {pm_index} pmiu WHERE pmi.mid = pmiu.mid AND pmiu.recipient = :recipient LIMIT 1) = 1) ) GROUP BY pmi.recipient, u.name, pmi.type; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => hidden [:db_condition_placeholder_2] => hidden [:db_condition_placeholder_3] => 5 [:recipient] => 5 ) in _privatemsg_load_thread_participants() (Zeile 849 von C:\....\wwwroot\sites\all\modules\privatemsg\privatemsg.module).

I tried uninstalling, reinstall,

Thanks

Mike

Comments

berdir’s picture

Title: Error after submitting private message » Not compatible with MS SQL Server

This module is currently not compatible with MS SQL Server.

ptmkenny’s picture

Marked http://drupal.org/node/1406070 as duplicate

ptmkenny’s picture

Status: Active » Closed (duplicate)

Feature request here: http://drupal.org/node/1593358