View Issue Details

IDProjectCategoryView StatusLast Update
16663Bug reportsQuestion editorpublic2020-09-21 14:54
Reportergabrieljenik Assigned Togabrieljenik  
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Product Version4.3.15 
Summary16663: Unable to install related question theme
Description

Question Theme installation fails on MsSQL

[error] [system.db.CDbCommand] CDbCommand::fetch() failed: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ''.. The SQL statement executed was: SELECT TOP 1 1 FROM [dbo].[dsc_question_themes] [t] WHERE (extends`=:extends) AND (LOWER([t].[name])=LOWER(:ycp0)).

[error] [exception.CDbException] CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '`'. in C:\inetpub\wwwroot\SMSystem\framework\db\CDbCommand.php:543

Additional Information

Seems to me the issue happens as the SQL statment is using backticks..
See: application\models\QuestionTheme.php::57
public function rules() { // NOTE: you should only define rules for those attributes that // will receive user inputs. return array( [ 'name', 'unique', 'caseSensitive' => false, 'criteria' => [ 'condition' => 'extends=:extends', 'params' => [ ':extends' => $this->extends ] ],

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.3.15
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMsSQL
Server OS (if known)
Webserver software & version (if known)
PHP Version7

Activities

gabrieljenik

gabrieljenik

2020-09-11 15:05

developer  

image.png (189,497 bytes)
gabrieljenik

gabrieljenik

2020-09-11 15:11

developer   ~59777

I think this is a fix
https://github.com/LimeSurvey/LimeSurvey/pull/1588

gabrieljenik

gabrieljenik

2020-09-18 11:13

developer   ~59870

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=30468

lime_release_bot

lime_release_bot

2020-09-21 14:54

administrator   ~59899

Fixed in Release 4.3.17+200921

Related Changesets

LimeSurvey: master 00cad18a

2020-09-11 15:07:07

gabrieljenik

Details Diff
Fixed issue 16663: Unable to install related question theme

Removing backticks as they are not accepted by MSSQL
Affected Issues
16663
mod - application/models/QuestionTheme.php Diff File

LimeSurvey: master 418f9144

2020-09-18 11:13:40

ollehar1


Committer: GitHub Details Diff
Fixed issue 16663: Unable to install related question theme

Dev: Merge pull request #1588 from gabrieljenik/bug/16663--Unable-to-install-related-question-theme
Affected Issues
16663
mod - application/models/QuestionTheme.php Diff File

Issue History

Date Modified Username Field Change
2020-09-11 15:05 gabrieljenik New Issue
2020-09-11 15:05 gabrieljenik File Added: image.png
2020-09-11 15:11 gabrieljenik Note Added: 59777
2020-09-18 11:13 ollehar1 Changeset attached => LimeSurvey master 418f9144
2020-09-18 11:13 gabrieljenik Changeset attached => LimeSurvey master 00cad18a
2020-09-18 11:13 gabrieljenik Note Added: 59870
2020-09-18 11:13 gabrieljenik Assigned To => gabrieljenik
2020-09-18 11:13 gabrieljenik Resolution open => fixed
2020-09-21 14:54 lime_release_bot Note Added: 59899
2020-09-21 14:54 lime_release_bot Status new => closed