View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
19137Bug reportsStatisticspublic2023-09-30 16:01
Reporterbabiel Assigned ToDenisChenu  
PrioritynoneSeveritypartial_block 
Status closedResolutionduplicate 
Product Version6.2.x 
Summary19137: Statistics export partially bricked
Description

Hello there,

we're experiencing some issues during statistics export after several updates that were performed using comfort updater. Precisely PDF export including statistics graphics doesn't work for us and export to excel at all. Export to HTML and to PDF, when statistics graphics are not included, seem to be working.

We patched from 5.4.8 to 6.2.6 and then to 6.2.7. On 6.2.7 the issues have been reported by out customer. I patched to 6.2.9, but the issues still persist. The major update was performed manually, for the updates to 6.2.7 and 6.2.9 the comfort updates was used.

During the major upgrade https://manual.limesurvey.org/Installation_security_hints/de#Setzen_von_Berechtigungen_auf_einem_selbstverwalteten_Linux-System has been considered. But this had blocked the comfort updates as it issued, that several files were not writeable. So I had to set the following file permissions additionally:

find application -type d -exec chmod 0750 {} \;
find application -type f -exec chmod 0640 {} \;
find tmp -type d -exec chmod 0750 {} \;
find tmp -type f -exec chmod 0640 {} \;
find upload -type d -exec chmod 0750 {} \;
find upload -type f -exec chmod 0640 {} \;
find assets -type d -exec chmod 0750 {} \;
find assets -type f -exec chmod 0640 {} \;
find docs -type d -exec chmod 0750 {} \;
find docs -type f -exec chmod 0640 {} \;
find locale -type d -exec chmod 0750 {} \;
find locale -type f -exec chmod 0640 {} \;
find tests/unit -type d -exec chmod 0750 {} \;
find tests/unit -type f -exec chmod 0640 {} \;
find themes/survey/fruity_twentythree -type d -exec chmod 0750 {} \;
find themes/survey/fruity_twentythree -type f -exec chmod 0640 {} \;

This way the comfort updater is happy, but I don't know if this bricked the statistics export utility.

Unfortunately no error is logged in vhost error or PHP logfile.

Steps To Reproduce

Steps to reproduce

Go to ndex.php/admin/statistics/sa/index/surveyid/171834 ( just pick a survey ) and export to pdf, including statistics graphics, and to excel.

Expected result

export works

Actual result

both times popup
"java Script error
An error occured! Please reload the page!"

developer console show http 500 error on /index.php/admin/statistics/sa/index/surveyid/171834

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)LimeSurvey Community Edition Version 6.2.9+230925
I will donate to the project if issue is resolvedYes
BrowserVivaldi, Chrome, Firefox
Database type & versionMySQL 8.0.34
Server OS (if known)Debian 11
Webserver software & version (if known)Apache 2.4.56
PHP Version7.4.33

Relationships

duplicate of 19111 closedmfavetti Statistics export partially bricked 

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-09-29 09:17 babiel New Issue
2023-09-30 16:01 DenisChenu Relationship added duplicate of 19111
2023-09-30 16:01 DenisChenu Assigned To => DenisChenu
2023-09-30 16:01 DenisChenu Status new => closed
2023-09-30 16:01 DenisChenu Resolution open => duplicate