View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18550 | Bug reports | Response browsing | public | 2022-12-12 18:44 | 2024-08-06 16:55 |
Reporter | DenisChenu | Assigned To | DenisChenu | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.28.x | ||||
Summary | 18550: MSSQL Reponse filter with underscore or bracket not working | ||||
Description | When have response with underscore ( | ||||
Steps To Reproduce | Steps to reproduceHave a MSSQL (and another DB to compare) Expected resultHave some value in response Actual resultEmpty result | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 5.4.14 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | SQLServer (MS) 15.00.4261 | ||||
Server OS (if known) | windows | ||||
Webserver software & version (if known) | https://github.com/LimeSurvey/LimeSurvey/pull/3900 | ||||
PHP Version | PHP7.4 | ||||
See Yii 2 Against Yii1 |
|
Own fix here : http://burnignorance.com/database-tips-and-tricks/how-to-escape-wildcard-characters-while-searching-in-sql-server/ |
|
No way to extend CBDCriteria or replace CBDCriteria ??? |
|
@ollehar : the only way to fix it seems to fix manually Yii1 … See https://github.com/yiisoft/yii/issues/4512#issuecomment-1400704265 We close as «Not fixable» an i create a Fork for MSSQL ? |
|
Did i take time to fix it in LimeSurey core |
|
Urgh. Not sure. |
|
Is this fixed in Yii 3 query builder or active record package, I wonder... |
|
Me too … i think i create a fork for one of my client, updating directly Yii But : if i do it for LS :
Tell me :) |
|
Fixed in Yii2, then Yii3 too. |
|
OK, so since master now require PHP 7.4 at least, it's actually possible for us to start to use Yii 3 packages step by step. Dunno if that would work here tho. |
|
take a lot more time , i do my fork :) |
|
Can be incluided in https://github.com/LimeSurvey/LimeSurvey/blob/master/application/core/LSDbCriteria.php |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36509 |
|
Fixed in Release 6.6.1+240806 |
|
LimeSurvey: master 23520134 2024-08-06 14:18:21 Committer: GitHub Details Diff |
Fixed issue 18550: MSSQL Reponse filter with underscore or bracket not working (03900) |
Affected Issues 18550 |
|
mod - application/core/LSDbCriteria.php | Diff File | ||
mod - application/models/Assessment.php | Diff File | ||
mod - application/models/LabelSet.php | Diff File | ||
mod - application/models/Participant.php | Diff File | ||
mod - application/models/ParticipantAttributeName.php | Diff File | ||
mod - application/models/Question.php | Diff File | ||
mod - application/models/QuestionGroup.php | Diff File | ||
mod - application/models/QuestionTheme.php | Diff File | ||
mod - application/models/SurveymenuEntries.php | Diff File | ||
mod - application/models/SurveysGroups.php | Diff File | ||
mod - application/models/Template.php | Diff File | ||
mod - application/models/TemplateConfiguration.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2022-12-12 18:44 | DenisChenu | New Issue | |
2022-12-12 18:44 | DenisChenu | File Added: survey_archive_MSSQL_compare.lsa | |
2022-12-12 18:44 | DenisChenu | File Added: MSSQL_bracket.mp4 | |
2022-12-12 18:44 | DenisChenu | File Added: MSSQL_underscore.mp4 | |
2022-12-12 18:44 | DenisChenu | Assigned To | => DenisChenu |
2022-12-12 18:44 | DenisChenu | Status | new => assigned |
2022-12-12 18:58 | DenisChenu | Note Added: 73068 | |
2022-12-12 18:58 | DenisChenu | Bug heat | 0 => 2 |
2022-12-12 19:02 | DenisChenu | Note Added: 73069 | |
2022-12-12 19:06 | DenisChenu | Note Edited: 73069 | |
2023-01-21 13:48 | DenisChenu | Note Added: 73521 | |
2023-05-04 16:34 | DenisChenu | Note Added: 74817 | |
2023-05-04 16:35 | DenisChenu | Assigned To | DenisChenu => ollehar |
2023-05-04 16:35 | DenisChenu | Status | assigned => feedback |
2023-05-04 16:35 | DenisChenu | Note Added: 74818 | |
2023-05-04 16:36 | DenisChenu | Note Edited: 74818 | |
2023-05-05 11:46 | ollehar | Note Added: 74831 | |
2023-05-05 11:46 | ollehar | Bug heat | 2 => 4 |
2023-05-05 11:47 | ollehar | Note Added: 74832 | |
2023-05-05 11:47 | ollehar | Note Edited: 74832 | |
2023-05-05 11:50 | DenisChenu | Note Added: 74833 | |
2023-05-05 11:50 | DenisChenu | Status | feedback => assigned |
2023-05-05 11:51 | DenisChenu | Note Added: 74834 | |
2023-05-05 11:51 | DenisChenu | Note Edited: 74834 | |
2023-05-05 12:01 | ollehar | Note Added: 74835 | |
2023-05-05 15:32 | DenisChenu | Note Added: 74843 | |
2023-06-16 10:42 | c_schmitz | Summary | MSSQL Reponse filter with underscore or bracket are broken => MSSQL Reponse filter with underscore or bracket not working |
2023-06-16 10:42 | c_schmitz | Description Updated | |
2023-06-16 10:44 | c_schmitz | Status | assigned => closed |
2023-06-16 10:44 | c_schmitz | Resolution | open => won't fix |
2023-07-27 15:29 | DenisChenu | Assigned To | ollehar => DenisChenu |
2023-07-27 15:29 | DenisChenu | Status | closed => feedback |
2023-07-27 15:29 | DenisChenu | Resolution | won't fix => reopened |
2023-07-27 15:29 | DenisChenu | Note Added: 76303 | |
2024-01-19 17:23 | DenisChenu | Status | feedback => assigned |
2024-01-19 17:23 | DenisChenu | Complete LimeSurvey version number (& build) | 3.28.42 and 5.4.14 => 5.4.14 |
2024-06-29 10:03 | DenisChenu | Assigned To | DenisChenu => gabrieljenik |
2024-06-29 10:04 | DenisChenu | Webserver software & version (if known) | IIS => https://github.com/LimeSurvey/LimeSurvey/pull/3900 |
2024-06-29 10:04 | DenisChenu | Note Added: 80498 | |
2024-06-29 10:08 | DenisChenu | Status | assigned => ready for code review |
2024-07-01 16:10 | gabrieljenik | Assigned To | gabrieljenik => tibor.pacalat |
2024-07-01 16:10 | gabrieljenik | Status | ready for code review => ready for testing |
2024-08-06 14:18 | tibor.pacalat | Status | ready for testing => resolved |
2024-08-06 14:34 | DenisChenu | Changeset attached | => LimeSurvey master 23520134 |
2024-08-06 14:34 | DenisChenu | Note Added: 80748 | |
2024-08-06 14:34 | DenisChenu | Assigned To | tibor.pacalat => DenisChenu |
2024-08-06 14:34 | DenisChenu | Resolution | reopened => fixed |
2024-08-06 16:55 | LimeBot | Note Added: 80755 | |
2024-08-06 16:55 | LimeBot | Status | resolved => closed |
2024-08-06 16:55 | LimeBot | Bug heat | 4 => 6 |