View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08027Bug reportsStatisticspublic2013-07-20 23:312013-10-20 01:02
Reporterremd Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary08027: Internal server error when viewing stats containing name and/or email in text field
Description

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "223SQ00"
LINE 1: ... "t" WHERE language='en' AND parent_qid=0 AND qid='223SQ00' ...

Steps To Reproduce

Create a question of type "Multiple short text", asking for Full name or email.
Stats will crash when ask to view the name or email.
all 15 other questions statistics view in the same survey work fine, as long as those 2 fields are not included.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130526
I will donate to the project if issue is resolvedNo
Browser
Database type & versionpostgres 8.4.11
Server OS (if known)ubuntu 10.04
Webserver software & version (if known)Apache/2.2.14
PHP VersionPHP Version 5.3.10
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-09-27 16:31

administrator   ~26400

Does this still happen if you use the latest 2.00 build? If yes, can you please attach the exported question/or survey?
c_schmitz

c_schmitz

2013-10-07 16:36

administrator   ~26595

Feedback please?
c_schmitz

c_schmitz

2013-10-20 01:02

administrator   ~26841

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2013-07-20 23:31 remd New Issue
2013-09-27 16:31 c_schmitz Note Added: 26400
2013-09-27 16:31 c_schmitz Assigned To => c_schmitz
2013-09-27 16:31 c_schmitz Status new => feedback
2013-10-07 16:36 c_schmitz Note Added: 26595
2013-10-20 01:02 c_schmitz Note Added: 26841
2013-10-20 01:02 c_schmitz Status feedback => closed
2013-10-20 01:02 c_schmitz Resolution open => unable to reproduce