View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04032Bug reportsOtherpublic2010-01-09 00:33
Reporteruser4627Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.87 
Fixed in Version1.87+ 
Summary04032: Export of question group structure failed using mssql
Description

http://limesurvey.example.com/admin/admin.php?action=exportstructureGroup&sid=86855&gid=144

[Microsoft][ODBC SQL Server Driver][SQL Server]The text data type cannot be selected as DISTINCT because it is not comparable.:SELECT DISTINCT lime_question_attributes.* FROM lime_question_attributes, lime_questions WHERE (lime_question_attributes.qid=lime_questions.qid) AND (lime_questions.gid=144)

Btw. is is possible to import a question group too? This would be quite useful for us.

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)8214
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMsSQL 2005
Server OS (if known)Windows 2008SP2
Webserver software & version (if known)IIS 7.0
PHP VersionPHP 5.3.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-01-05 09:46

  ~10712

@ hellmi:
1) can you do an export of the whole survey (survey structure as .csv-file)?
If yes, please attach the survey structure and tell us, which group makes problem at export.
2) Yes, importing a group structure is possible ==> you'll find the function at the same place, where you create a new group.

user4627

2010-01-05 10:27

  ~10713

it is a general problem all groups have this issue. Please check group "meta" for example...

c_schmitz

c_schmitz

2010-01-05 10:53

administrator   ~10714

Will be fixed in the next Plus version.

user372

2010-01-05 11:01

  ~10716

Last edited: 2010-01-05 11:06

@ hellmi:
1) c_schmitz fixed the bug regarding exporting LimeSurvey groups and MSSQL.
2) We noticed an error in your installation: it seems like you did an upgrade from a release candidate to the final version, because your exported survey structure contains an invalid field "lastpage" ==> to get a full functional LimeSurvey installation you'll have to delete the field "lastpage" with a database editor from the table "<prefix>_surveys".

Issue History

Date Modified Username Field Change
2010-01-05 09:37 user4627 New Issue
2010-01-05 09:37 user4627 Status new => assigned
2010-01-05 09:37 user4627 Assigned To => user372
2010-01-05 09:37 user4627 LimeSurvey build number => 8214
2010-01-05 09:37 user4627 Browser => Firefox
2010-01-05 09:37 user4627 Database & DB-Version => MsSQL 2005
2010-01-05 09:37 user4627 Operating System (Server) => Windows 2008SP2
2010-01-05 09:37 user4627 Webserver => IIS 7.0
2010-01-05 09:37 user4627 PHP Version => PHP 5.3.1
2010-01-05 09:46 user372 Note Added: 10712
2010-01-05 09:47 user372 Status assigned => feedback
2010-01-05 10:27 user4627 File Added: limesurvey_survey_86855.csv
2010-01-05 10:27 user4627 Note Added: 10713
2010-01-05 10:53 c_schmitz Status feedback => assigned
2010-01-05 10:53 c_schmitz Assigned To user372 => c_schmitz
2010-01-05 10:53 c_schmitz Note Added: 10714
2010-01-05 10:53 c_schmitz Status assigned => resolved
2010-01-05 10:53 c_schmitz Fixed in Version => 1.87+
2010-01-05 10:53 c_schmitz Resolution open => fixed
2010-01-05 11:01 user372 Note Added: 10716
2010-01-05 11:02 user372 Note Edited: 10716
2010-01-05 11:06 c_schmitz Note Edited: 10716
2010-01-09 00:33 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)