View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06677Bug reportsAccessibilitypublic2012-10-10 16:392012-10-11 11:38
ReporterErik_Inn Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06677: Cannot generate/view statistics of survey responses
Description

After receiving responses for a survey, response statistics can not be generated/viewed. The following error occurs:

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

Steps To Reproduce

Generate surver, send survey invitation(s), view responses, generate/view response statistics (see the printscreen attached to this ticket)

TagsNo tags attached.
Attached Files
Printscreen LimeSurvey bug.jpg (160,429 bytes)
survey_archive_293149.lsa (4,234 bytes)
Bug heat4
Complete LimeSurvey version number (& build)121009
I will donate to the project if issue is resolvedNo
BrowserMS Internet Explorer 9, Google Chrome 22.0.1229.79 m
Database type & versionMS SQL 2008
Server OS (if known)MS Windows Server 2008 service pack 2
Webserver software & version (if known)IIS 7
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-10-10 22:54

administrator   ~21191

Please attach the survey as .lsa file. Thank you.
Erik_Inn

Erik_Inn

2012-10-11 08:54

reporter   ~21196

Thanks for the quick response. Please find attached the survey as .lsa file
c_schmitz

c_schmitz

2012-10-11 11:38

administrator   ~21201

New version 2.00+ Build 121011 released.

Issue History

Date Modified Username Field Change
2012-10-10 16:39 Erik_Inn New Issue
2012-10-10 16:39 Erik_Inn File Added: Printscreen LimeSurvey bug.jpg
2012-10-10 22:53 c_schmitz Assigned To => c_schmitz
2012-10-10 22:53 c_schmitz Status new => assigned
2012-10-10 22:54 c_schmitz Note Added: 21191
2012-10-10 22:54 c_schmitz Status assigned => feedback
2012-10-11 08:54 Erik_Inn File Added: survey_archive_293149.lsa
2012-10-11 08:54 Erik_Inn Note Added: 21196
2012-10-11 08:54 Erik_Inn Status feedback => assigned
2012-10-11 09:55 c_schmitz Status assigned => resolved
2012-10-11 09:55 c_schmitz Fixed in Version => 2.00+
2012-10-11 09:55 c_schmitz Resolution open => fixed
2012-10-11 11:38 c_schmitz Note Added: 21201
2012-10-11 11:38 c_schmitz Status resolved => closed