View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|15895||Bug reports||Survey editing||public||2020-02-19 13:00||2020-03-18 23:16|
|Fixed in Version||4.1.9|
|Summary||15895: [IIS+SQL Server installation] List of questions don't load|
When I try to access a survey's question list, the screen freezes and doesn't finish loading.
|Steps To Reproduce|
1.- You go into a survey
Thanks to testing with Internet Explorer I was able to solve this, since in this web browser the screen doesn't be frozen, it instead displays an error message --> […]Bad SQL Sintax[…]
|Tags||No tags attached.|
|Complete LimeSurvey version number (& build)||4.1.5|
|I will donate to the project if issue is resolved||No|
|Browser||Internet Explorer, Edge, Chrome and Firefox|
|Database type & version||SQL SERVER 2012|
|Server OS (if known)||Windows Server 2012 R2|
|Webserver software & version (if known)||IIS|
To resolve this, you need to change in 'application\models\question.php' the word group by [group] when it is being used to form an SQL statement.
For example on line 966:
You should change it to:
There were more cases in the code but I don't remember them anymore, and I no longer have this installation on my server.
It must have a Yii gloval solution, because we don't have to use it like this.
My opinon : we must use relations
@c_schmitz, can you please take a look at this one?
|2020-02-19 13:00||santics||New Issue|
|2020-02-19 13:08||santics||Note Added: 56095|
|2020-02-19 15:13||DenisChenu||Note Added: 56096|
|2020-03-18 19:46||cdorin||Note Added: 56651|
|2020-03-18 23:14||c_schmitz||Assigned To||=> c_schmitz|
|2020-03-18 23:14||c_schmitz||Status||new => closed|
|2020-03-18 23:14||c_schmitz||Resolution||open => fixed|
|2020-03-18 23:14||c_schmitz||Fixed in Version||=> 4.1.9|
|2020-03-18 23:16||c_schmitz||Changeset attached||=> LimeSurvey master dece010b|