View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04947 | Bug reports | Survey taking | public | 2011-02-10 15:51 | 2011-03-08 15:52 |
| Reporter | thaJack | Assigned To | c_schmitz | ||
| Priority | urgent | Severity | partial_block | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.87+ | ||||
| Summary | 04947: Survey running out of order. | ||||
| Description | Running a sample survey causes unknown screen to appear and survey questions to be presented out of order. LimeSurvey 1.87+ (because we need assessment scores on multiple choice questions) | ||||
| Steps To Reproduce | Sample survey will consist of two groups with two questions in each group. They will all be free text and not mandatory, just to keep things simple. Group 1 There will be no conditions on any of the questions.Limesurvey running on Ubuntu Server 10.04 and connecting to Microsoft SQL Server using the mssql_n driver. The installation routine is able to successfully create and populate the database. | ||||
| Additional Information | On the same server, we do not have these issues if we change the config.php to use the local MySQL server. However, we have business requirements that could be more easily met if we could make it reliable with MS SQL. Not sure this problem is specifically related to MS SQL, but seems to be. | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 8 | ||||
| Complete LimeSurvey version number (& build) | 8518 | ||||
| I will donate to the project if issue is resolved | Yes | ||||
| Browser | Chrome, Firefox, IE | ||||
| Database type & version | MS SQL 2008 (I believe, maybe 2005) | ||||
| Server OS (if known) | Ubuntu 10.04 Server | ||||
| Webserver software & version (if known) | Apache | ||||
| PHP Version | 5, I believe | ||||
| Git branch / Pull Request URL | |||||
|
The screens uploaded are numbered in the order they are seen as I step through the survey. As you can see, it is clearly out of order. Questions are presented in the order 1, 3, 4, 2. Screens 1, 3 and 6 don't make any sense to me. Running on MySQL I am never shown a screen that just indicates the name of the group without any questions. The normal survey I want to run in production has several groups of questions (runs fine on MySQL) and I definitely don't want to have an additional screen with each group. Either way, if this could be resolved quickly to make the us feel comfortable in the stability when we run it on Microsoft SQL, we will happily make a donation to the project. |
|
|
I tested at 1.91RC3 and MySQL and as said, there the problem does not show up. Carsten, can youn please test on MS SQL?! |
|
|
I also remember a similar problem with group soring values of "0" assigned to each group of a survey at MS SQL, maybe this is the same issue. |
|
|
Is that also what might cause screens 1, 3 and 6 in addition to them being out of order? |
|
|
I can't say for sure if these problems are connected but it is possible. What happens if you run the survey at 1.90 with MS SQL? |
|
|
thaJack: what DB driver are you using exactly in config.php? |
|
|
mssql_n |
|
|
Can you try using mssql_odbc or mssqlnative? |
|
|
yeah, mssql_n is experimental, as noted in config.php, and will be deprecated in 1.92 |
|
|
mssql_odbc doesn't work at all. mssqlnative isn't listed as an option in the config file. |
|
|
says "mssqlnative extension not installed" |
|
|
mssql_odbc is working just fine here - it is also thoroughly tested. mssqlnative is not yet available in 1.87. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-02-10 15:51 | thaJack | New Issue | |
| 2011-02-10 15:51 | thaJack | File Added: limesurvey_survey_33477.csv | |
| 2011-02-10 15:51 | thaJack | Issue Monitored: thaJack | |
| 2011-02-10 15:52 | thaJack | File Added: page01.jpg | |
| 2011-02-10 15:52 | thaJack | File Added: page02.jpg | |
| 2011-02-10 15:52 | thaJack | File Added: page03.jpg | |
| 2011-02-10 15:52 | thaJack | File Added: page04.jpg | |
| 2011-02-10 15:52 | thaJack | File Added: page05.jpg | |
| 2011-02-10 15:53 | thaJack | File Added: page06.jpg | |
| 2011-02-10 15:53 | thaJack | File Added: page07.jpg | |
| 2011-02-10 15:53 | thaJack | File Added: page08.jpg | |
| 2011-02-10 15:56 | thaJack | Note Added: 14132 | |
| 2011-02-10 17:13 | Mazi | Note Added: 14133 | |
| 2011-02-10 17:18 | Mazi | Assigned To | => c_schmitz |
| 2011-02-10 17:18 | Mazi | Status | new => assigned |
| 2011-02-10 17:20 | Mazi | Note Added: 14134 | |
| 2011-02-10 17:46 | thaJack | Note Added: 14135 | |
| 2011-02-11 00:29 | Mazi | Note Added: 14139 | |
| 2011-02-11 00:29 | Mazi | Status | assigned => feedback |
| 2011-02-11 00:34 | c_schmitz | Note Added: 14140 | |
| 2011-02-11 02:17 | thaJack | Note Added: 14142 | |
| 2011-02-11 02:17 | thaJack | Status | feedback => assigned |
| 2011-02-11 03:54 | Mazi | Note Added: 14143 | |
| 2011-02-11 03:54 | Mazi | Status | assigned => feedback |
| 2011-02-11 13:10 | c_schmitz | Note Added: 14146 | |
| 2011-02-11 13:14 | c_schmitz | Note Edited: 14146 | |
| 2011-02-11 16:20 | thaJack | Note Added: 14149 | |
| 2011-02-11 16:20 | thaJack | Status | feedback => assigned |
| 2011-02-11 16:29 | thaJack | Note Added: 14150 | |
| 2011-02-11 16:55 | c_schmitz | Note Added: 14151 | |
| 2011-02-11 16:55 | c_schmitz | Status | assigned => resolved |
| 2011-02-11 16:55 | c_schmitz | Resolution | open => won't fix |
| 2011-03-08 15:52 | c_schmitz | Status | resolved => closed |
| 2021-09-21 02:23 | guest | Bug heat | 6 => 8 |