View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04939Bug reportsSurvey editingpublic2011-02-08 17:112011-02-17 18:25
Reporteremilus Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.91RC4 
Summary04939: Group ordering problem: group_order not correctly initialized when adding groups
Description

When adding groups to a new survey, the group order cannot be changed.

Steps To Reproduce

  1. Create a new survey, you get f.e. id 13687

  2. Start adding a group, save.

  3. Observe at SQL level that the first group_order entry is set at "0". (Pardon my LISP here)

CL-USER> (clsql:query "select * from lime_groups where sid=13687")
((46 13687 "First group" 0 "Test opmerking first group<br />" "en"))
("gid" "sid" "group_name" "group_order" "description" "language")

  1. Add another group and save.

  2. Observe at SQL level that the second group_order entry is also set at "0".

CL-USER> (clsql:query "select * from lime_groups where sid=13687")
((46 13687 "First group" 0 "Test opmerking first group<br />" "en")
(47 13687 "Second group" 0 "Test remarks second group<br />" "en"))
("gid" "sid" "group_name" "group_order" "description" "language")

  1. In limesurvey, try to flip the order of these groups. It is not possible.
Additional Information

When you manually re-initialize the group_order for one of those entries:
(clsql:query "update lime_groups set group_order=1 where gid=47 and sid=13687")

..you will be able to reorder.

Finally, adding a new group in limesurvey AFTER havng done the above, yields this result:
(clsql:query "select * from lime_groups where sid=13687")
((46 13687 "First group" 0 "Test opmerking first group<br />" "en")
(47 13687 "Second group" 1 "Test remarks second group<br />" "en")
(48 13687 "bla" 2 "This should be group 3<br />" "en"))
("gid" "sid" "group_name" "group_order" "description" "language")

..So it looks like group addition will go OK from then.

I did not attach this survey - since the reproduction is simple, basically an empty survey with two groups. Switching the DB driver does not seem to help.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)9642
I will donate to the project if issue is resolvedYes
BrowserFirefox 3.6.13
Database type & versionMS-SQL Server 2005 Database driver used = 'mssql_n'
Server OS (if known)Windows 2003
Webserver software & version (if known)IIS5
PHP Version5.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2011-02-08 18:05

updater   ~14090

Carsten, my first guess is that there is a MS SQL problem when adding groups. Can you check?
c_schmitz

c_schmitz

2011-02-10 20:08

administrator   ~14137

This happens with the mssql_n driver. mssql_odbc is not affected.
c_schmitz

c_schmitz

2011-02-17 18:25

administrator   ~14225

1.91RC4 released

Issue History

Date Modified Username Field Change
2011-02-08 17:11 emilus New Issue
2011-02-08 18:05 Mazi Note Added: 14090
2011-02-08 18:05 Mazi Assigned To => c_schmitz
2011-02-08 18:05 Mazi Status new => assigned
2011-02-10 20:08 c_schmitz Note Added: 14137
2011-02-10 20:08 c_schmitz Status assigned => resolved
2011-02-10 20:08 c_schmitz Fixed in Version => 1.91RC4
2011-02-10 20:08 c_schmitz Resolution open => fixed
2011-02-17 18:25 c_schmitz Note Added: 14225
2011-02-17 18:25 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing