View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18793 | Bug reports | Database design | public | 2023-04-28 01:12 | 2023-06-19 18:35 |
Reporter | JanE | Assigned To | gabrieljenik | ||
Priority | normal | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 5.6.x | ||||
Summary | 18793: Quick Translation crash with MS SQL Database Error | ||||
Description | One of our custumers gets this error in LS 5.6 with MS SQL: CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique. This happens in the following LS versions: Microsoft SQL The error is not triggered with MySQL I am trying to reproduce the error locally, but that is not easy because we do not have MS SQL running. | ||||
Tags | No tags attached. | ||||
Bug heat | 14 | ||||
Complete LimeSurvey version number (& build) | 5.6.5+230214 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MS SQL Server 2016 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | PHP 8.0 (AFAIK) | ||||
@DenisChenu |
|
It's because it's added in defaultscope, MySQL and PGSDQL accept same order 2 times, not MSSQL It's the attended behaviour. |
|
Any idea what causes the crash in Quick Translation? |
|
An order added on a request in Quick translation |
|
Added by whom or what? If this is added by the LS code like in 18280 where should we start looking? |
|
I don't know : do a grep in controllers |
|
Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here. |
|
Hi Olle, thanks for replying. I do not get the error myself, but one of our customers does. I will ask them to change the debug level on their staging server. May take some time, because it happens to be a holiday over here. |
|
I have to update a local 5.X (but not 6.X) I check when it's done |
|
Hi Olle. Attached is the complete error report, pasted into a Word doc. This was on their staging server with LS 5.6.5+230214. |
|
Hi Olle, did you have a chance to look at this bug report? |
|
@ollehar Friendly ping. |
|
@gabrieljenik or @DenisChenu could pick this up, perhaps? |
|
I take it |
|
Top. Tell me if you want more info. Then I will ask our customer. |
|
PR for v5: https://github.com/LimeSurvey/LimeSurvey/pull/3218 |
|
@JanE Can you help testing? Maybe applyng the patch? |
|
PR for master: https://github.com/LimeSurvey/LimeSurvey/pull/3224 |
|
Thanks. Looking at the patch it should be easy tot backport: |
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34827 |
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34826 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34829 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34828 |
|
Fixed in Release 6.1.4+230620 |
|
And fixed in Release 5.6.27+230621, I see. Thanks @gabrieljenik |
|
LimeSurvey: 5.x 6dd9385b 2023-06-16 02:24 Gabriel Jenik Committer: GitHub Details Diff |
Fixed issue 18793: Quick Translation crash with MS SQL Database Error (#3218) |
Affected Issues 18793 |
|
mod - application/models/services/QuickTranslation.php | Diff File | ||
LimeSurvey: 5.x 6dd9385b 2023-06-16 02:24 Gabriel Jenik Committer: GitHub Details Diff |
Fixed issue 18793: Quick Translation crash with MS SQL Database Error (#3218) |
Affected Issues 18793 |
|
mod - application/models/services/QuickTranslation.php | Diff File | ||
LimeSurvey: master e0432a41 2023-06-16 02:24 Gabriel Jenik Committer: GitHub Details Diff |
Fixed issue 18793: Quick Translation crash with MS SQL Database Error (#3224) |
Affected Issues 18793 |
|
mod - application/models/services/QuickTranslation.php | Diff File | ||
LimeSurvey: master e0432a41 2023-06-16 02:24 Gabriel Jenik Committer: GitHub Details Diff |
Fixed issue 18793: Quick Translation crash with MS SQL Database Error (#3224) |
Affected Issues 18793 |
|
mod - application/models/services/QuickTranslation.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-04-28 01:12 | JanE | New Issue | |
2023-04-28 01:15 | JanE | Note Added: 74723 | |
2023-04-28 01:15 | JanE | Bug heat | 0 => 2 |
2023-04-28 01:19 | DenisChenu | Note Added: 74724 | |
2023-04-28 01:19 | DenisChenu | Bug heat | 2 => 4 |
2023-04-28 01:19 | JanE | Issue Monitored: JanE | |
2023-04-28 01:19 | JanE | Bug heat | 4 => 6 |
2023-04-28 11:32 | JanE | Note Added: 74731 | |
2023-04-28 15:27 | DenisChenu | Note Added: 74732 | |
2023-04-28 16:38 | JanE | Note Added: 74733 | |
2023-04-28 17:07 | DenisChenu | Note Added: 74734 | |
2023-05-02 10:08 | ollehar | Note Added: 74735 | |
2023-05-02 10:08 | ollehar | Bug heat | 6 => 8 |
2023-05-02 11:23 | JanE | Note Added: 74746 | |
2023-05-03 10:44 | ollehar | Assigned To | => ollehar |
2023-05-03 10:44 | ollehar | Status | new => feedback |
2023-05-03 10:44 | ollehar | Priority | none => normal |
2023-05-03 12:27 | DenisChenu | Note Added: 74773 | |
2023-05-04 12:44 | JanE | Note Added: 74807 | |
2023-05-04 12:44 | JanE | File Added: error-staging-LS5.6.5.docx | |
2023-05-04 12:44 | JanE | Status | feedback => assigned |
2023-05-16 11:51 | JanE | Note Added: 75005 | |
2023-06-13 08:46 | JanE | Note Added: 75569 | |
2023-06-13 09:50 | ollehar | Note Added: 75574 | |
2023-06-13 14:52 | gabrieljenik | Assigned To | ollehar => gabrieljenik |
2023-06-13 14:52 | gabrieljenik | Note Added: 75604 | |
2023-06-13 14:52 | gabrieljenik | Bug heat | 8 => 10 |
2023-06-13 14:57 | JanE | Note Added: 75606 | |
2023-06-13 16:44 | gabrieljenik | Assigned To | gabrieljenik => DenisChenu |
2023-06-13 16:44 | gabrieljenik | Status | assigned => ready for code review |
2023-06-13 16:44 | gabrieljenik | Note Added: 75616 | |
2023-06-13 22:11 | gabrieljenik | Note Added: 75618 | |
2023-06-13 22:11 | gabrieljenik | Assigned To | DenisChenu => gabrieljenik |
2023-06-13 22:11 | gabrieljenik | Status | ready for code review => ready for testing |
2023-06-14 18:29 | gabrieljenik | Note Added: 75636 | |
2023-06-14 18:46 | JanE | Note Added: 75637 | |
2023-06-16 00:24 | Changeset attached | => LimeSurvey 5.x 6dd9385b | |
2023-06-16 00:24 | Changeset attached | => LimeSurvey 5.x 6dd9385b | |
2023-06-16 00:24 | guest | Note Added: 75652 | |
2023-06-16 00:24 | guest | Note Added: 75653 | |
2023-06-16 00:24 | guest | Bug heat | 10 => 12 |
2023-06-16 00:24 | guest | Bug heat | 10 => 12 |
2023-06-16 00:26 | c_schmitz | Status | ready for testing => resolved |
2023-06-16 00:26 | c_schmitz | Resolution | open => fixed |
2023-06-16 00:33 | Changeset attached | => LimeSurvey master e0432a41 | |
2023-06-16 00:33 | guest | Note Added: 75654 | |
2023-06-16 00:35 | Changeset attached | => LimeSurvey master e0432a41 | |
2023-06-16 00:35 | guest | Note Added: 75655 | |
2023-06-19 11:52 | LimeBot | Note Added: 75707 | |
2023-06-19 11:52 | LimeBot | Status | resolved => closed |
2023-06-19 11:52 | LimeBot | Bug heat | 12 => 14 |
2023-06-19 18:35 | JanE | Note Added: 75724 |