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 |