View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06673Bug reportsStatisticspublic2012-10-09 23:122012-10-11 11:38
Reporterchrismbb Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06673: Admin cannot view statistics of responses
Description

When clicking on Responses and Statistics > Get statistics from these responses I get:
Internal Server Error

CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error

Steps To Reproduce

Create survey
Enter in at least one response
In the admin area click on Responses and Statistics
Click on Get statistics from these responses
It will then return the error

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)121009
I will donate to the project if issue is resolvedYes
BrowserChrome
Database type & versionMS SQL Server 2008 R2
Server OS (if known)Windows Server 2008 R2 Standard
Webserver software & version (if known)IIS 7
PHP Version5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-10-10 14:01

administrator   ~21168

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

c_schmitz

2012-10-10 14:01

administrator   ~21169

Thank you. We are looking forward to your donation.
c_schmitz

c_schmitz

2012-10-11 11:38

administrator   ~21204

New version 2.00+ Build 121011 released.

Related Changesets

LimeSurvey: master 84ce2f8b

2012-10-10 07:00

c_schmitz


Details Diff		 Fixed issue 06673: Admin cannot view statistics of responses when using MSSQL Affected Issues
06673
mod - application/models/Questions.php Diff File

Issue History

Date Modified Username Field Change
2012-10-09 23:12 chrismbb New Issue
2012-10-10 14:00 c_schmitz Assigned To => c_schmitz
2012-10-10 14:00 c_schmitz Status new => assigned
2012-10-10 14:01 c_schmitz Changeset attached => LimeSurvey master 84ce2f8b
2012-10-10 14:01 c_schmitz Note Added: 21168
2012-10-10 14:01 c_schmitz Resolution open => fixed
2012-10-10 14:01 c_schmitz Status assigned => resolved
2012-10-10 14:01 c_schmitz Fixed in Version => 2.00+
2012-10-10 14:01 c_schmitz Note Added: 21169
2012-10-11 11:38 c_schmitz Note Added: 21204
2012-10-11 11:38 c_schmitz Status resolved => closed