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 | ||||
| Git branch / Pull Request URL | |||||
|
@ 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) |