View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
13117Bug reportsStatisticspublic2018-01-03 22:012018-01-10 17:16
Reporterpotus Assigned Toollehar  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.0.0-rc.x 
Summary13117: Statistics cannot be shown inside LimeSurvey
Description

Dear programmers,

thank your for your work!

I installed version 3.0.1+171228 freshly on a shared server of https://all-inkl.com/. After I had created the MySQL database manually, I went through the installation process without any difficulties.

MySQL: 5.6.38
PHP: 7.0

The following error message is shown whenever I use the "Statistik anzeigen" button to receive an interpretation inside LimeSurvey; the error reproduces with each survey I have created so far:

Interner Serverfehler
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: 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 viewsummaryall IN) AND noncompleted IN) AND statlang IN) AND `output' at line 1

Steps To Reproduce

Push "Statistik anzeigen" button.

Additional Information

MySQL database was manually created.

MySQL: 5.6.38
PHP: 7.0

TagsNo tags attached.
Attached Files
limesurvey_survey_774538.lss (24,261 bytes)
screenshot.png (30,463 bytes)   
screenshot.png (30,463 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)3.0.1+171228
I will donate to the project if issue is resolvedNo
BrowserFirefox 57.0.3 (64 bit)
Database type & versionMySQL: 5.6.38
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP VersionPHP: 7.0

Relationships

Relationship GraphDependency Graph
related to 13110 closedollehar Multilanguage doesn't work 

Users monitoring this issue

partofthething

Activities

partofthething

partofthething

2018-01-05 02:34

reporter   ~45421

Same problem here on a brand new fresh install. MySQL 5.7.20, apache2 2.4.18.
cookiemonster

cookiemonster

2018-01-08 17:02

reporter   ~45492

same, both on fresh install & update
MySQL 5.5.54 & Apache 2.4.7
fperli

fperli

2018-01-09 15:54

reporter   ~45522

I'm really having trouble
When I'm going to take the report from a specialist survey of this error

Screenshot_1.png (39,763 bytes)   
Screenshot_1.png (39,763 bytes)   
Screenshot_48.png (23,680 bytes)   
Screenshot_48.png (23,680 bytes)   
ollehar

ollehar

2018-01-09 17:04

administrator   ~45524

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=25884
ollehar

ollehar

2018-01-09 17:10

administrator   ~45525

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=25885
ollehar

ollehar

2018-01-09 17:13

administrator   ~45526

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=25886
ollehar

ollehar

2018-01-09 17:18

administrator   ~45527

Partly solved (won't work when debug = 2).
partofthething

partofthething

2018-01-09 17:59

reporter   ~45529

That fix seems to get me the HTML statistics nicely, thanks! I do get a very similar error now if I switch to PDF statistics and hit "View Statistics":

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: 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 `completionstate` IN) AND `viewsummaryall` IN) AND `noncompleted` IN) AND ' at line 1
fperli

fperli

2018-01-09 18:56

reporter   ~45532

I made the corrections in the files as informed above
when I click on displaying statistics does not do any action even selecting the filter

Screenshot_2.png (71,757 bytes)   
Screenshot_2.png (71,757 bytes)   
fperli

fperli

2018-01-09 19:04

reporter   ~45533

it worked, thank you

Related Changesets

LimeSurvey: master 7742e459

2018-01-09 17:04:05

ollehar

Details Diff 		Fixed issue 13117: Statistics cannot be shown Affected Issues
13117
mod - application/helpers/admin/statistics_helper.php Diff File
mod - application/views/admin/super/layout_insurvey.php Diff File

LimeSurvey: master b30f1e35

2018-01-09 17:10:39

ollehar

Details Diff 		Revert "Fixed issue 13117: Statistics cannot be shown"

This reverts commit 7742e45932d6ff0b339e0e2339183b491a04369b.		 Affected Issues
13117
mod - application/helpers/admin/statistics_helper.php Diff File
mod - application/views/admin/super/layout_insurvey.php Diff File

LimeSurvey: master 84b91415

2018-01-09 17:13:30

ollehar

Details Diff 		Fixed issue 13117: Statistics cannot be shown Affected Issues
13117
mod - application/helpers/admin/statistics_helper.php Diff File

Issue History

Date Modified Username Field Change
2018-01-03 22:01 potus New Issue
2018-01-03 22:01 potus File Added: limesurvey_survey_774538.lss
2018-01-03 22:01 potus File Added: screenshot.png
2018-01-05 02:34 partofthething Note Added: 45421
2018-01-05 02:36 partofthething Issue Monitored: partofthething
2018-01-08 11:24 LouisGac Relationship added related to 13110
2018-01-08 17:02 cookiemonster Note Added: 45492
2018-01-09 15:54 fperli File Added: Screenshot_1.png
2018-01-09 15:54 fperli File Added: Screenshot_48.png
2018-01-09 15:54 fperli Note Added: 45522
2018-01-09 16:54 ollehar Assigned To => ollehar
2018-01-09 16:54 ollehar Status new => assigned
2018-01-09 17:04 ollehar Changeset attached => LimeSurvey master 7742e459
2018-01-09 17:04 ollehar Note Added: 45524
2018-01-09 17:04 ollehar Resolution open => fixed
2018-01-09 17:10 ollehar Changeset attached => LimeSurvey master b30f1e35
2018-01-09 17:10 ollehar Note Added: 45525
2018-01-09 17:13 ollehar Changeset attached => LimeSurvey master 84b91415
2018-01-09 17:13 ollehar Note Added: 45526
2018-01-09 17:18 ollehar Note Added: 45527
2018-01-09 17:59 partofthething Note Added: 45529
2018-01-09 18:56 fperli File Added: Screenshot_2.png
2018-01-09 18:56 fperli Note Added: 45532
2018-01-09 19:04 fperli Note Added: 45533
2018-01-10 17:16 ollehar Status assigned => closed
2018-01-10 17:16 ollehar Fixed in Version => 3.0.2