View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04329Bug reportsPrint Viewpublic2010-05-10 17:372010-05-21 19:03
ReporterMazi Assigned Tomachaven  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.90b 
Target Version1.90RC1 
Summary04329: SQL error when using "print answers" at the end of a survey
Description

When completing the attached survey I receive the following SQL error when clicking on the "print answers" link: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language = 'en' ORDER BY sortorder, title' at line 4:SELECT * FROM lime190_labels WHERE lid= AND language = 'en' ORDER BY sortorder, title"

I'm using a fresh 1.90beta system which wasn't updated (because I had problems) but installed from scratch.

TagsNo tags attached.
Attached Files
limesurvey_survey_85389.lss (119,745 bytes)
Bug heat4
Complete LimeSurvey version number (& build)8704
I will donate to the project if issue is resolved
BrowserFirefox 3.6.3
Database type & versionMySQL 5
Server OS (if known)Win 7
Webserver software & version (if known)Apache 2.2
PHP Version5.3.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

machaven

machaven

2010-05-12 08:52

reporter   ~11785

Um i'm sure there can probably a couple bugs still but i haven't picked it up yet. This file was totaly neglected with the subquestion changes. This is a huge duplication of code which i already saw in conditionshandling perviously. The code is used to generate data with the column name, title, question texts to be displayed. As in the left coloumn of print answers and in the question list under conditions. We need to think about moving this code out and creating a function for this or we will have more problems with implementing questions etc. This functionality is probably in statistics as well.
machaven

machaven

2010-05-12 08:55

reporter   ~11786

Fixed in SVN
lemeur

lemeur

2010-05-21 19:03

developer   ~11913

beta3 release

Issue History

Date Modified Username Field Change
2010-05-10 17:37 Mazi New Issue
2010-05-10 17:37 Mazi Status new => assigned
2010-05-10 17:37 Mazi Assigned To => c_schmitz
2010-05-10 17:37 Mazi File Added: limesurvey_survey_85389.lss
2010-05-10 18:55 machaven Assigned To c_schmitz => machaven
2010-05-12 08:52 machaven Note Added: 11785
2010-05-12 08:55 machaven Note Added: 11786
2010-05-12 08:55 machaven Status assigned => resolved
2010-05-12 08:55 machaven Resolution open => fixed
2010-05-21 19:03 lemeur Note Added: 11913
2010-05-21 19:03 lemeur Status resolved => closed