I assume you did an upgrade to Joomla 3.6 well even if you didn't it seems for some reason you may not have the latest version of the JDatabaseQuerySqlsrv class that comes shipped with Joomla 3.6

Please check the file libraries\joomla\database\query\sqlsrv.php. if it does not contain the group function on line 373 then you don't have the latest version of this file. The group function was overridden in this class to combat the exact issue you are facing. This is the curse of doing a 'Select *' in MSSQL.

So if you update that file it should resolve your issue.

On a side note in the users list view there is no reason to do a 'Select a.*' from the users table. Not only is it not necessary but it is less perfomant.

But I'm with the old version of the class JDatabaseQuerySqlsrv and yet, I still have problems.
See the image below:

Yes. That is why you are having this issue. you need the new version.

I had installed the new version, but a problem of Joomla, I was not able to search the registered news. That is, when I typed in the website the word 'world', he showed me 0 results, but I had several news with the word 'world'. I believe this is a Joomla 3.6 problem for SQLServer.

Did you update to Joomla 3.6 ?
In which way? Did you check Database? (Extensions > Manage > Database)

No. I'm still in version 3.5.1.
Below the image of the requested path:

How did you do the update to Joomla 3.6?

do you have the lastResetTime field in #__users db table?

I have not updated Joomla. I downloaded the new version 3.6 on the official site and installed. And then I inserted some news and did research at the site, but were shown 0 results for me. This was in SQL Server, I have not tested on Mysql.

So I am confused. You say you have installed 3.6 but that you have 3.5.1
installed?

On 28 July 2016 at 14:55, efilho14 notifications@github.com wrote:

I have not updated Joomla. I downloaded the new version 3.6 on the
official site and installed. And then I inserted some news and did research
at the site, but were shown 0 results for me. This was in SQL Server, I

have not tested on Mysql.

This comment was created with the J!Tracker Application
https://github.com/joomla/jissues at issues.joomla.org/joomla-cms/11298
https://issues.joomla.org/tracker/joomla-cms/11298.

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#11298 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABPH8WDurmxDGAYeAehJ4QGiRW8Ea2Kzks5qaLTegaJpZM4JUKrB
.

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

yeah, me too. confused.

Okay. I'm in version 3.5.1 and following the playback steps of the issue it presents me the following error:

Steps to reproduce the issue

Administrator > Control Panel > Users > Groups

Click > Users in group Number

Expected result

Listing users belonging to the clicked group

Actual result

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column '#__users.lastResetTime' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SQL=SELECT a.* FROM [#__users] AS a LEFT JOIN #__user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 2 GROUP BY [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email] ORDER BY [a].[name] asc [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column '#__users.lastResetTime' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SQL=SELECT * FROM ( SELECT a.* , ROW_NUMBER() OVER (ORDER BY [a].[name] asc) AS RowNumber FROM [#__users] AS a LEFT JOIN #__user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 2 GROUP BY [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email] ) A WHERE A.RowNumber BETWEEN 1 AND 20 [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column '#__users.lastResetTime' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SQL=SELECT a.* FROM [#__users] AS a LEFT JOIN #__user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 2 GROUP BY [a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email] ORDER BY [a].[name] asc

So please update to 3.6. There were a huge number of changes since the
release of 3.5.1 and it is a waste of everyones time to debug your issue if
it has already been fixed

On 28 July 2016 at 15:03, efilho14 notifications@github.com wrote:

Okay. I'm in version 3.5.1 and following the playback steps of the issue
it presents me the following error:

Steps to reproduce the issue

Administrator > Control Panel > Users > Groups

Click > Users in group Number

Expected result

Listing users belonging to the clicked group

Actual result

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column
'#__users.lastResetTime' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause.
SQL=SELECT a.* FROM [#__users] AS a LEFT JOIN #__user_usergroup_map AS map2
ON map2.user_id = a.id WHERE map2.group_id = 2 GROUP BY
[a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email]
ORDER BY [a].[name] asc [Microsoft][ODBC Driver 11 for SQL Server][SQL
Server]Column '#__users.lastResetTime' is invalid in the select list
because it is not contained in either an aggregate function or the GROUP BY
clause. SQL=SELECT * FROM ( SELECT a.* , ROW_NUMBER() OVER (ORDER BY
[a].[name] asc) AS RowNumber FROM [#__users] AS a LEFT JOIN
#__user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id
= 2 GROUP BY
[a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email]
) A WHERE A.RowNumber BETWEEN 1 AND 20 [Microsoft][ODBC Driver 11 for SQL
Server][SQL Server]Column '#__users.lastResetTime' is invalid in the select
list because it is not contained in either an aggregate function or the
GROUP BY clause. SQL=SELECT a.* FROM [#__users] AS a LEFT JOIN
#__user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id
= 2 GROUP BY
[a].[id],[a].[name],[a].[username],[a].[password],[a].[block],[a].[sendEmail],[a].[registerDate],[a].[lastvisitDate],[a].[activation],[a].[params],[a].[email]
ORDER BY [a].[name] asc

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#11298 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABPH8QHQESK53Y89rHvAZKkjTlqiOGf2ks5qaLbLgaJpZM4JUKrB
.

Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/

I am closing this at this time @williamsandy has already said that you must update to 3.6 and it is fixed in 3.6.