| Project: | User Points |
| Version: | 7.x-1.0 |
| Component: | Code: userpoints |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Receive this error when clicking on "My points" in the user menu.
PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'taxonomy_term_data.weight' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: SELECT t.[tid] AS [tid], t.[name] AS [name], t.weight AS _field_0, t.tid AS _field_1, t.name AS _field_2 FROM {taxonomy_term_data} t INNER JOIN {userpoints_txn} p ON t.tid = p.tid AND p.uid = :uid WHERE ( ([t].[vid] = :db_condition_placeholder_0) ) GROUP BY t.tid, t.name ORDER BY t.weight ASC; Array ( [:db_condition_placeholder_0] => 2 [:uid] => 1 ) in userpoints_get_categories() (line 1661 of C:\inetpub\wwwroot\sites\all\modules\userpoints\userpoints.module).
Environment:
Windows Server 2008 R2
SQL Server 2008 R2
PHP SQL Server Driver 2.0.1