View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06831Bug reportsStatisticspublic2012-11-08 19:49
Reporterhelper Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06831: CDbException when attempting to view individual survey result
Description

Microsoft SQL Server specific - works fine with MySQL

error:
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.. The SQL statement executed was: SELECT [id]
FROM [lime_survey_761276]
WHERE (true) AND (id > :id)
ORDER BY [id] ASC

Steps To Reproduce
  1. Using the attached survey
  2. Navigate to "Responses" > "Responses & statistics"
  3. Click on "Display responses" icon
  4. Click on the magnifying glass icon for an individual survey
TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)121104
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMicrosoft SQL Server 2008
Server OS (if known)Microsoft Windows 2008r2
Webserver software & version (if known)Apache 2.4.3
PHP VersionPHP 5.4.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-11-05 18:31

administrator   ~21962

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

helper

helper

2012-11-05 19:04

reporter   ~21963

Just a suggestion, but you may want to change

$wherefilterstate='1=1';

on line 285 also

c_schmitz

c_schmitz

2012-11-05 23:13

administrator   ~21964

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

c_schmitz

c_schmitz

2012-11-06 09:49

administrator   ~21976

New version released.

c_schmitz

c_schmitz

2012-11-06 10:37

administrator   ~21986

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

DenisChenu

DenisChenu

2012-11-08 19:49

developer   ~22022

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

Related Changesets

LimeSurvey: master ac399408

2012-11-05 17:31:33

c_schmitz

Details Diff
Fixed issue 06831: Exception when attempting to view individual survey result on MSSQL Affected Issues
06831
mod - application/models/Survey_dynamic.php Diff File

LimeSurvey: 2.1 3a1a79bf

2012-11-05 17:31:33

c_schmitz


Committer: DenisChenu Details Diff
Fixed issue 06831: Exception when attempting to view individual survey result on MSSQL Affected Issues
06831
mod - application/models/Survey_dynamic.php Diff File

LimeSurvey: master b0680f9a

2012-11-05 22:13:03

c_schmitz

Details Diff
Fixed issue 06831: Exception when attempting to view individual survey result on MSSQL Affected Issues
06831
mod - application/models/Survey_dynamic.php Diff File

LimeSurvey: 2.1 56a17935

2012-11-05 22:13:03

c_schmitz


Committer: DenisChenu Details Diff
Fixed issue 06831: Exception when attempting to view individual survey result on MSSQL Affected Issues
06831
mod - application/models/Survey_dynamic.php Diff File

LimeSurvey: 2.1 aca84818

2012-11-06 09:32:25

c_schmitz

Details Diff
Fixed issue 06806: If one of a 1-5 answer is never selected, there is a random value in statistics graph legend
Fixed issue 06831: Exception when attempting to view individual survey result on MSSQL
Affected Issues
06806, 06831
mod - application/models/Survey_dynamic.php Diff File

Issue History

Date Modified Username Field Change
2012-11-05 16:16 helper New Issue
2012-11-05 16:16 helper File Added: survey_archive_761276 (2).lsa
2012-11-05 18:31 c_schmitz Assigned To => c_schmitz
2012-11-05 18:31 c_schmitz Status new => assigned
2012-11-05 18:31 c_schmitz Status assigned => resolved
2012-11-05 18:31 c_schmitz Fixed in Version => 2.00+
2012-11-05 18:31 c_schmitz Resolution open => fixed
2012-11-05 18:31 c_schmitz Changeset attached => LimeSurvey master ac399408
2012-11-05 18:31 c_schmitz Note Added: 21962
2012-11-05 19:04 helper Note Added: 21963
2012-11-05 23:13 c_schmitz Changeset attached => LimeSurvey master b0680f9a
2012-11-05 23:13 c_schmitz Note Added: 21964
2012-11-06 09:49 c_schmitz Note Added: 21976
2012-11-06 09:49 c_schmitz Status resolved => closed
2012-11-06 10:37 c_schmitz Changeset attached => LimeSurvey 2.1 aca84818
2012-11-06 10:37 c_schmitz Note Added: 21986
2012-11-08 19:49 DenisChenu Changeset attached => LimeSurvey 2.1 3a1a79bf
2012-11-08 19:49 DenisChenu Changeset attached => LimeSurvey 2.1 56a17935
2012-11-08 19:49 DenisChenu Note Added: 22022