View Issue Details

This issue affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
04947Bug reportsSurvey takingpublic2011-03-08 15:52
ReporterthaJack Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionwon't fix 
Product Version1.87+ 
Summary04947: 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)
Ubuntu Server 10.04
MSSQL (mssql_n driver)

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
Question 1
Question 2
Group 2
Question 3
Question 4

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.

TagsNo tags attached.
Attached Files
page01.jpg (53,014 bytes)   
page01.jpg (53,014 bytes)   
page02.jpg (57,890 bytes)   
page02.jpg (57,890 bytes)   
page03.jpg (47,209 bytes)   
page03.jpg (47,209 bytes)   
page04.jpg (61,309 bytes)   
page04.jpg (61,309 bytes)   
page05.jpg (61,368 bytes)   
page05.jpg (61,368 bytes)   
page06.jpg (48,216 bytes)   
page06.jpg (48,216 bytes)   
page07.jpg (58,144 bytes)   
page07.jpg (58,144 bytes)   
page08.jpg (19,059 bytes)   
page08.jpg (19,059 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)8518
I will donate to the project if issue is resolvedYes
BrowserChrome, Firefox, IE
Database type & versionMS SQL 2008 (I believe, maybe 2005)
Server OS (if known)Ubuntu 10.04 Server
Webserver software & version (if known)Apache
PHP Version5, I believe
Git branch / Pull Request URL

Users monitoring this issue

thaJack

Activities

thaJack

thaJack

2011-02-10 15:56

reporter   ~14132

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.

Mazi

Mazi

2011-02-10 17:13

updater   ~14133

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?!

Mazi

Mazi

2011-02-10 17:20

updater   ~14134

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.

thaJack

thaJack

2011-02-10 17:46

reporter   ~14135

Is that also what might cause screens 1, 3 and 6 in addition to them being out of order?

Mazi

Mazi

2011-02-11 00:29

updater   ~14139

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?

c_schmitz

c_schmitz

2011-02-11 00:34

administrator   ~14140

thaJack: what DB driver are you using exactly in config.php?

thaJack

thaJack

2011-02-11 02:17

reporter   ~14142

mssql_n

Mazi

Mazi

2011-02-11 03:54

updater   ~14143

Can you try using mssql_odbc or mssqlnative?

c_schmitz

c_schmitz

2011-02-11 13:10

administrator   ~14146

Last edited: 2011-02-11 13:14

yeah, mssql_n is experimental, as noted in config.php, and will be deprecated in 1.92

thaJack

thaJack

2011-02-11 16:20

reporter   ~14149

mssql_odbc doesn't work at all. mssqlnative isn't listed as an option in the config file.

thaJack

thaJack

2011-02-11 16:29

reporter   ~14150

says "mssqlnative extension not installed"

c_schmitz

c_schmitz

2011-02-11 16:55

administrator   ~14151

mssql_odbc is working just fine here - it is also thoroughly tested. mssqlnative is not yet available in 1.87.
I am sorry but currently I don't see a way to help you because we do not provide patches for old versions. Using mssql_odbc is your best shot.

Issue History

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