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 |
Reporter | santics | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 4.1.5 | ||||
Fixed in Version | 4.1.9 | ||||
Summary | 15895: [IIS+SQL Server installation] List of questions don't load | ||||
Description | 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 | ||||
Additional Information | 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. | ||||
Bug heat | 6 | ||||
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 | ||||
PHP Version | 7.2.11 | ||||
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. I'm sorry. |
|
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? |
|
Date Modified | Username | Field | Change |
---|---|---|---|
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 |