We don't really have the resources to debug and fix SQL Server issues, but feel free to apply a pull request with the solution.

What is the DB version in the database when this issue happen ?

WHERE (:gsid OR :gsid OR :gsid OR :gsid OR :gsid). ?

The DBVersion is 614.

Sorry the "where" is not correct, the correct one is:

WHERE (t.gsid=:gsid OR parentGroup2.gsid=:gsid OR parentGroup3.gsid=:gsid OR parentGroup4.gsid=:gsid OR parentGroup5.gsid=:gsid). Bound with :gsid=8

OK : then surely on other SQL version : MS SQL didn't accept one param for multiple value.

But if I run the same request with the ms sql client on the machine, the result is correct.

/opt/mssql-tools18/bin/sqlcmd -S xxxxxxx -U xxxxxxx -P xxxxxx -C -q "SELECT COUNT(DISTINCT [t].[sid]) FROM [dbo].[lime_surveys] [t] LEFT JOIN lime_surveys_groups parentGroup1 ON t.gsid = parentGroup1.gsid LEFT JOIN lime_surveys_groups parentGroup2 ON parentGroup1.parent_id = parentGroup2.gsid LEFT JOIN lime_surveys_groups parentGroup3 ON parentGroup2.parent_id = parentGroup3.gsid LEFT JOIN lime_surveys_groups parentGroup4 ON parentGroup3.parent_id = parentGroup4.gsid LEFT JOIN lime_surveys_groups parentGroup5 ON parentGroup4.parent_id = parentGroup5.gsid LEFT OUTER JOIN [dbo].[lime_surveys_languagesettings] [correct_relation_defaultlanguage] ON ([correct_relation_defaultlanguage].[surveyls_language]=[t].[language]) AND ([correct_relation_defaultlanguage].[surveyls_survey_id]=[t].[sid]) LEFT OUTER JOIN [dbo].[lime_users] [owner] ON ([t].[owner_id]=[owner].[uid]) LEFT OUTER JOIN [dbo].[lime_surveys_groups] [surveygroup] ON ([t].[gsid]=[surveygroup].[gsid]) WHERE (t.gsid=8 OR parentGroup2.gsid=8 OR parentGroup3.gsid=8 OR parentGroup4.gsid=8 OR parentGroup5.gsid=8)"

     41

(1 rows affected)

Yes, but MSSQL didn't accept column1=:value and column2=:value, Bound with :value=8

Need column1=:value1 and column2=:value2, Bound with :value1=8, :value2=8

About

The DBVersion is 614.

This is in version.php; i mean the current DBVersion set in database : lime_settings_global
It's to find where the issue happen on https://github.com/LimeSurvey/LimeSurvey/tree/master/application/helpers/update/updates

The version is 614 attached image with this

DBVersion_limesurvey.jpg (57,892 bytes)   

DBVersion_limesurvey.jpg (57,892 bytes)   

The version is 614 attached image with this

But then : update done until end ?

Then

I have upgraded the platform from 3.22 to 6.2.1 and now i´m getting an error CDbException when i try to execute this query:

What action ? All action ?
If yes : please activate debug mode : manual.limesurvey.org/Debug_mode

and send the HTML produced here.

Got it :)
I propose an untested fix …
You have to test yourself

https://github.com/LimeSurvey/LimeSurvey/pull/3431

@dcastro : please apply the patch and test

I have applied the patch and now everything works. Will this patch be incorporated into the code of the next version?

Thanks.

Hi @dcastro, thank you for confirming the fix. Yes, it will be a part of the next version.

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=35478

Fixed in Release 6.2.7+230918