View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
10298Bug reportsStatisticspublic2016-02-04 08:332016-02-25 17:18
Reporterisamarx Assigned ToLouisGac 
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.50.x 
Summary10298: Missing questions in statistic filter
Description

There's a problem with the filter of the statistics.
In the filter area all matrix questions are missing and the multiple numeric input question.

When I set the filter and get the result the same questions are missing..

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)160202
I will donate to the project if issue is resolvedNo
Browser
Database type & version252
Server OS (if known)Windows 7
Webserver software & version (if known)Xampp 3.2.1
PHP Version5.5.11

Users monitoring this issue

isamarx

Activities

LouisGac

LouisGac

2016-02-04 10:12

developer   ~34558

could you please provide a lsa file so we can reproduce it here ?
LouisGac

LouisGac

2016-02-04 10:48

developer   ~34565

thanks for helping with debuging.
I just deleted the files
LouisGac

LouisGac

2016-02-17 13:49

developer   ~35309

should be corrected now.
Can you confirm ?
isamarx

isamarx

2016-02-18 13:54

reporter   ~35398

Everything is shown correctly but when I want to set the filter I get an error:
Column not found: 1054 Unknown column 'K434492X16X322SQ001' in 'field list'.
In my database the column is called '434492X16X322SQ001'.
I also tried to rename it but then I'm not able to save new surveys. After I submit I get the following error:
Syntax error or access violation: 1064 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 sid=434492' at line 1
This happens with the multiple numeric input and the normal short text input field.
LouisGac

LouisGac

2016-02-18 14:25

developer   ~35404

ok thank you for the report.
c_schmitz

c_schmitz

2016-02-25 17:18

administrator   ~35723

2.50+ Build 160225 released

Issue History

Date Modified Username Field Change
2016-02-04 08:33 isamarx New Issue
2016-02-04 10:12 LouisGac Note Added: 34558
2016-02-04 10:12 LouisGac Assigned To => LouisGac
2016-02-04 10:12 LouisGac Status new => feedback
2016-02-04 10:15 isamarx File Added: limesurvey_survey_277857 (1).lss
2016-02-04 10:17 isamarx File Added: survey_archive_277857.lsa
2016-02-04 10:35 isamarx Issue Monitored: isamarx
2016-02-04 10:42 isamarx Status feedback => assigned
2016-02-04 10:47 LouisGac File Deleted: limesurvey_survey_277857 (1).lss
2016-02-04 10:47 LouisGac File Deleted: survey_archive_277857.lsa
2016-02-04 10:48 LouisGac Note Added: 34565
2016-02-04 10:54 isamarx File Added: survey_archive_977944.lsa
2016-02-08 20:11 LouisGac File Deleted: survey_archive_977944.lsa
2016-02-17 13:49 LouisGac Note Added: 35309
2016-02-17 13:49 LouisGac Status assigned => feedback
2016-02-18 13:54 isamarx Note Added: 35398
2016-02-18 13:54 isamarx Status feedback => assigned
2016-02-18 14:25 LouisGac Note Added: 35404
2016-02-25 15:04 LouisGac Status assigned => resolved
2016-02-25 15:04 LouisGac Resolution open => fixed
2016-02-25 17:18 c_schmitz Note Added: 35723
2016-02-25 17:18 c_schmitz Status resolved => closed
2023-01-22 12:53 guest Bug heat 6 => 8