View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04032 | Bug reports | Other | public | 2010-01-05 09:37 | 2010-01-09 00:33 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87 | ||||
Fixed in Version | 1.87+ | ||||
Summary | 04032: 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. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 8214 | ||||
I will donate to the project if issue is resolved | |||||
Browser | Firefox | ||||
Database type & version | MsSQL 2005 | ||||
Server OS (if known) | Windows 2008SP2 | ||||
Webserver software & version (if known) | IIS 7.0 | ||||
PHP Version | PHP 5.3.1 | ||||
@ hellmi: |
|
it is a general problem all groups have this issue. Please check group "meta" for example... |
|
Will be fixed in the next Plus version. |
|
@ hellmi: |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2010-01-05 09:37 |
|
New Issue | |
2010-01-05 09:37 |
|
Status | new => assigned |
2010-01-05 09:37 |
|
Assigned To | => user372 |
2010-01-05 09:37 |
|
LimeSurvey build number | => 8214 |
2010-01-05 09:37 |
|
Browser | => Firefox |
2010-01-05 09:37 |
|
Database & DB-Version | => MsSQL 2005 |
2010-01-05 09:37 |
|
Operating System (Server) | => Windows 2008SP2 |
2010-01-05 09:37 |
|
Webserver | => IIS 7.0 |
2010-01-05 09:37 |
|
PHP Version | => PHP 5.3.1 |
2010-01-05 09:46 |
|
Note Added: 10712 | |
2010-01-05 09:47 |
|
Status | assigned => feedback |
2010-01-05 10:27 |
|
File Added: limesurvey_survey_86855.csv | |
2010-01-05 10:27 |
|
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 |
|
Note Added: 10716 | |
2010-01-05 11:02 |
|
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) |