View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18736 | Bug reports | Import/Export | public | 2023-04-10 16:55 | 2023-05-22 11:30 |
Reporter | MikeatEduTech | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 6.0.x | ||||
Summary | 18736: Error exporting participants from MSSQL db | ||||
Description | Attempting to export participants from any given survey results in this error page: It looks like the webpage at https://***********/index.php?r=admin/tokens/sa/exportdialog/surveyid/292653 might be having issues, or it may have moved permanently to a new web address. Stack trace: [error] [system.db.CDbCommand] CDbCommand::fetchColumn() failed: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column "lime_tokens_292653.tid" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.. The SQL statement executed was: SELECT count(*)
| ||||
Steps To Reproduce | Steps to reproduceCreate blank survey. Expected resultCSV file downloaded. Actual resultError page as described in description block. | ||||
Tags | mssql | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 6.0.0+230405 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome, FF, Edge | ||||
Database type & version | MSSQL 2019 15.0.4298.1 | ||||
Server OS (if known) | Windows Server 2019 | ||||
Webserver software & version (if known) | Windows server 2022, IIS 10 | ||||
PHP Version | 8.2.4 | ||||
Why reassign ? |
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34685 |
|
Fixed in Release 6.1.0+230522 |
|
LimeSurvey: 5.x f4ff3399 2023-05-17 16:46 Details Diff |
Fixed issue 18736: Error exporting participants when using MSSQL DB |
Affected Issues 18736 |
|
mod - application/helpers/export_helper.php | Diff File | ||
LimeSurvey: master 5482c09e 2023-05-17 16:46 Details Diff |
Fixed issue 18736: Error exporting participants when using MSSQL DB |
Affected Issues 18736 |
|
mod - application/helpers/export_helper.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-04-10 16:55 | MikeatEduTech | New Issue | |
2023-04-11 09:32 | DenisChenu | Issue Monitored: DenisChenu | |
2023-04-11 09:32 | DenisChenu | Bug heat | 0 => 2 |
2023-05-04 14:19 | ollehar | Tag Attached: mssql | |
2023-05-16 16:06 | DenisChenu | Assigned To | => DenisChenu |
2023-05-16 16:06 | DenisChenu | Status | new => assigned |
2023-05-17 10:30 | p_teichmann | Assigned To | DenisChenu => c_schmitz |
2023-05-17 10:50 | DenisChenu | Note Added: 75018 | |
2023-05-17 10:50 | DenisChenu | Bug heat | 2 => 4 |
2023-05-17 14:47 | c_schmitz | Changeset attached | => LimeSurvey 5.x f4ff3399 |
2023-05-17 14:47 | c_schmitz | Note Added: 75032 | |
2023-05-17 14:47 | c_schmitz | Bug heat | 4 => 6 |
2023-05-17 14:47 | c_schmitz | Resolution | open => fixed |
2023-05-17 14:49 | c_schmitz | Status | assigned => resolved |
2023-05-17 14:49 | c_schmitz | Changeset attached | => LimeSurvey master 5482c09e |
2023-05-22 11:30 | LimeBot | Note Added: 75129 | |
2023-05-22 11:30 | LimeBot | Status | resolved => closed |
2023-05-22 11:30 | LimeBot | Bug heat | 6 => 8 |