View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
20175 | Bug reports | Print View | public | 2025-07-15 23:15 | 2025-08-07 14:34 |
Reporter | Mauro | Assigned To | tibor.pacalat | ||
Priority | none | Severity | crash | ||
Status | resolved | Resolution | fixed | ||
Product Version | 6.6.x | ||||
Summary | 20175: Print survey fails on SQL Server due to duplicated ORDER BY (sortorder,code) | ||||
Description | Description The problem is due to a duplicated ORDER BY clause in the SQL query executed by the controller PrintableSurvey.php (around line 1270). The query explicitly sets order => 'sortorder,code', even though this same clause is already included in the model's defaultScope(). Temporary fix | ||||
Steps To Reproduce | Steps to reproduce Create a survey with at least one multiple-choice or array question (with answer options). Go to the survey administration menu and click "Print survey". The application tries to render the survey content and fails. Expected result Actual result CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: ORDER BY sortorder, code, sortorder, code Workaround tested: | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 6.15.4+250710 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Microsoft SQL Server 2019, ODBC Driver 17 | ||||
Server OS (if known) | Ubuntu 22.04 | ||||
Webserver software & version (if known) | |||||
PHP Version | 8.3.19 | ||||
LimeSurvey: master 9ee0a356 2025-08-07 14:34 Gabriel Jenik Committer: GitHub Details Diff |
Fixed issue 20175: Print survey fails on SQL Server due to duplicated ORDER BY (sortorder,code) (04383) Co-authored-by: lapiudevgit <devgit@lapiu.biz> |
Affected Issues 20175 |
|
mod - application/controllers/admin/PrintableSurvey.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2025-07-15 23:15 | Mauro | New Issue | |
2025-07-15 23:15 | Mauro | File Added: ERROR_DETAIL.png | |
2025-07-15 23:15 | Mauro | File Added: ERROR_SQL_LIME.png | |
2025-07-23 15:32 | tibor.pacalat | Assigned To | => gabrieljenik |
2025-07-23 15:32 | tibor.pacalat | Status | new => assigned |
2025-07-30 15:48 | gabrieljenik | Assigned To | gabrieljenik => DenisChenu |
2025-07-30 15:48 | gabrieljenik | Status | assigned => ready for code review |
2025-07-30 15:48 | gabrieljenik | Note Added: 83157 | |
2025-07-30 15:48 | gabrieljenik | Bug heat | 0 => 2 |
2025-07-30 16:14 | DenisChenu | Assigned To | DenisChenu => tibor.pacalat |
2025-07-30 16:14 | DenisChenu | Status | ready for code review => ready for testing |
2025-08-07 14:34 | Changeset attached | => LimeSurvey master 9ee0a356 | |
2025-08-07 14:34 | guest | Note Added: 83187 | |
2025-08-07 14:34 | guest | Bug heat | 2 => 4 |
2025-08-07 14:34 | tibor.pacalat | Status | ready for testing => resolved |
2025-08-07 14:34 | tibor.pacalat | Resolution | open => fixed |