"Components / Messaging / New Private Message " page "Select User" Error Problem - Joomla! Forum - community, help and support

hi,

"components / messaging / new private message " page "select user" following error comes when . how can solve this?

thanks,

error
[microsoft][odbc driver 11 sql server][sql server]column '#__users.lastresettime' invalid in select list because not contained in either aggregate function or group clause. sql=select a.* [#__users] left join #__user_usergroup_map map2 on map2.user_id = a.id map2.group_id in (7,8) , id not in (209) group [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendemail],[a].[registerdate],[a].[lastvisitdate],[a].[activation],[a].[params],[a].[email] order [a].[name] asc [microsoft][odbc driver 11 sql server][sql server]column '#__users.lastresettime' invalid in select list because not contained in either aggregate function or group clause. sql=select * ( select a.* , row_number() on (order [a].[name] asc) rownumber [#__users] left join #__user_usergroup_map map2 on map2.user_id = a.id map2.group_id in (7,8) , id not in (209) group [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendemail],[a].[registerdate],[a].[lastvisitdate],[a].[activation],[a].[params],[a].[email] ) a.rownumber between 1 , 20 [microsoft][odbc driver 11 sql server][sql server]column '#__users.lastresettime' invalid in select list because not contained in either aggregate function or group clause. sql=select a.* [#__users] left join #__user_usergroup_map map2 on map2.user_id = a.id map2.group_id in (7,8) , id not in (209) group [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendemail],[a].[registerdate],[a].[lastvisitdate],[a].[activation],[a].[params],[a].[email] order [a].[name] asc

what joomla version?
could give more info, eg using forum post assistant
viewtopic.php?f=621&t=582860