View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
07926Bug reportsStatisticspublic2013-06-14 19:312013-08-16 13:54
Reporterteslina Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05 RC 
Fixed in Version2.05 RC 
Summary07926: Statistic not displayed correctly (Zero values)
Description

I have just upgraded LimeSurvey from version 1.91 to 2.05b4. After the upgrade, the stats data wasn’t displayed correctly no more – even though all data was stored correctly in the database. For the count, I always got zero values.

The problem is caused by this faulty query:

[18:33:08.792][trace][system.db.CDbCommand] Querying SQL: SELECT count(*) FROM lime_survey_55836 WHERE 55836X2X122 = 'A1' AND NULL

Additional Information

Detailed bug information:
http://www.teslina.com/en/1609/allgemein/limesurvey-statistikdaten-unvollstandig-nach-upgrade-auf-version-2-xx/

Bugfix:

Page:

application/helpers/admin/statistics_helper.php

On line 3088:

if (!isset($sql) || !$sql) {$sql="NULL";}

replace with:

if (!isset($sql) || !$sql) {$sql=NULL;}

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)130609
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql 5.5.29
Server OS (if known)FreeBSD
Webserver software & version (if known)Nginx 1.2.8
PHP Version5.4.14

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-06-15 09:47

developer   ~25555

Can you test with 2.00 STABLE build please.

And if you have the patch why not put a pull request in our git system ?

Denis
mdekker

mdekker

2013-06-18 08:50

reporter   ~25576

I think this issue is only present in the 2.05 branch. Not sure where this line comes from. Will see if the proposed patch is ok.
mdekker

mdekker

2013-06-18 09:44

reporter   ~25579

I implemented this fix and some other stuff that was needed to get statistics going and 2.05 again. Please report any errors that you find after updating to todays github version.
c_schmitz

c_schmitz

2013-08-16 13:54

administrator   ~26015

2.05 beta 6 released

Issue History

Date Modified Username Field Change
2013-06-14 19:31 teslina New Issue
2013-06-15 09:47 DenisChenu Note Added: 25555
2013-06-18 08:50 mdekker Note Added: 25576
2013-06-18 09:44 mdekker Note Added: 25579
2013-06-18 11:26 mdekker Status new => resolved
2013-06-18 11:26 mdekker Fixed in Version => 2.05 RC
2013-06-18 11:26 mdekker Resolution open => fixed
2013-06-18 11:26 mdekker Assigned To => mdekker
2013-08-16 13:54 c_schmitz Note Added: 26015
2013-08-16 13:54 c_schmitz Status resolved => closed