Please help us help you and fill where relevant:
LimeSurvey version:
LimeSurvey Community Edition
Version 6.6.1+240806
with MSSQL 2019
Own server or LimeSurvey Cloud: Own Server
Survey theme/template: All
==================
After upgrading xampp for LimeSurvey to Apache 2.4.58 / PHP 8.2 we are getting a DB error when users try to open the Panel Integration Option on any Survey.
The generic error is:500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][ODBC Driver 18 for SQL Server]COUNT field incorrect or syntax errorAn internal error occurred while the Web server was processing your request.
The more detailed error is:
CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][ODBC Driver 18 for SQL Server]COUNT field incorrect or syntax error. The SQL statement executed was: SELECT COUNT(DISTINCT [t].[id]) FROM [dbo].[lime_survey_url_parameters] [t] LEFT OUTER JOIN [dbo].[lime_questions] [question] ON ([t].[targetqid]=[question].[qid]) LEFT OUTER JOIN [dbo].[lime_question_l10ns] [questionl10ns] ON ([questionl10ns].[qid]=[question].[qid]) LEFT OUTER JOIN [dbo].[lime_questions] [subquestion] ON ([t].[targetsqid]=[subquestion].[qid]) LEFT OUTER JOIN [dbo].[lime_question_l10ns] [subquestionl10ns] ON ([subquestionl10ns].[qid]=[subquestion].[qid]) WHERE (((t.sid=:surveyid) AND (questionl10ns.language=:language OR questionl10ns.language IS NULL)) AND (subquestionl10ns.language=:language OR subquestionl10ns.language IS NULL)). Bound with :surveyid='131666', :language='en'
If I copy / paste the select statement above I get the error below in SQL Studio
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near ':'.
Msg 319, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
