View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
16271Bug reportsImport/Exportpublic2020-05-18 11:33
Reporterjbourgin Assigned Toollehar  
PrioritylowSeveritycrash 
Status closedResolutionwon't fix 
Product Version4.2.2 
Summary16271: Can't export/copy some surveys
Description

I noticed that for some surveys, the export button as .lss, .lsa or .txt does not work. It does nothing on Firefox, and it returns a server problem error on Chrome.

I just did a fresh install to see if it solved the problem, following the steps mentioned here: https://manual.limesurvey.org/Installation_-_LimeSurvey_CE and here : https://manual.limesurvey.org/Installation_security_hints

But the problem kept showing up.

Further, I tried to create a new survey from a copy of a survey that wouldn't export, and the following error showed up :

500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/MYnend0k' (Errcode: 13 - Permission denied)

For all purposes, you will find attached an html export of a survey which presents this bug.

Am I missing something ?

Thanks in advance for your help.

Steps To Reproduce

This is the problem. I don't really know what's going on :-( I wasn't able to identify what made a survey exportable or not. The problem can occur for surveys with few questions (2 or 3 for instance).

Additional Information

More specifically, for permissions I did :

chown -R www-data:www-data limesurvey/
chmod -R o-r-w-x limesurvey/
chmod -R -w limesurvey/
chmod -R 770 limesurvey/application/config/
chmod -R 770 limesurvey/tmp
chmod -R 770 limesurvey/upload
sudo systemctl restart apache2.service

TagsNo tags attached.
Attached Files
error.png (67,537 bytes)   
error.png (67,537 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)Version 4.2.2+200504
I will donate to the project if issue is resolvedNo
BrowserFirefox 76.0.1 (64 bits)
Database type & versionMySQL Ver 14.14 Distrib 5.7.29
Server OS (if known)Ubuntu Server 18.04 "Bionic Beaver" LTS (64bits)
Webserver software & version (if known)Apache2
PHP VersionPHP 7.7.24

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2020-05-14 09:25

developer   ~57766

/tmp/ … not a LimeSurvey issue , seems more a SQL issue.

SQL user must have some write issue in tmp …

And please : activate debug mode

jbourgin

jbourgin

2020-05-14 11:50

reporter   ~57779

Thanks for your response.

I attached the error log with debug mode. I will try to look further into this to find what the problem is. It's really strange because I never had these issues with LimeSurvey 3... Yet, I'd really prefer moving on to LimeSurvey due to new question editor and data encryption.

Best

error.pdf (99,698 bytes)
DenisChenu

DenisChenu

2020-05-14 11:59

developer   ~57780

I never had these issues with LimeSurvey 3.

Without any update or change on the server ?

jbourgin

jbourgin

2020-05-14 12:21

reporter   ~57782

Yes, absolutely. For instance, I just created the attached survey with LimeSurvey 3.22.15. I imported it in LimeSurvey 4.2.2 and it worked fine. Then, in LimeSurvey 4.2.2 I just did a copy of two questions, and then I wasn't able to export it again.

jbourgin

jbourgin

2020-05-14 12:24

reporter   ~57783

I attached a screenshot of the new structure in LimeSurvey 4.2.2, with a copy of two questions added

structure_ls4.png (25,373 bytes)   
structure_ls4.png (25,373 bytes)   
ollehar

ollehar

2020-05-14 16:32

administrator   ~57791

Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.

jbourgin

jbourgin

2020-05-14 16:41

reporter   ~57794

Thanks for your response.

I provided the error with debug = 2 in an earlier note (16271:57779). I reattach it here.

error-2.pdf (99,698 bytes)
ollehar

ollehar

2020-05-14 16:42

administrator   ~57795

Thank you. Screenshots are better than PDFs (for the future, because we can see them directly in the tracker).

ollehar

ollehar

2020-05-14 16:43

administrator   ~57796

Yes, this looks very much like a database configuration issue. You should search on Ubuntu forums instead.

jbourgin

jbourgin

2020-05-14 17:08

reporter   ~57802

Thanks for your response.

I already searched Ubuntu forums and did not find the solution, which is why I posted the bug here.

Following the advice provided by Denis Chenu here : https://forums.limesurvey.org/forum/french-forum/121216-conseils-sur-la-version-de-ls-%C3%A0-utiliser, I think I will stick with LimeSurvey 3 for now.

ollehar

ollehar

2020-05-14 17:11

administrator   ~57803

What's your permission for the /tmp root folder (not LimeSurvey tmp, system tmp)?

jbourgin

jbourgin

2020-05-14 17:19

reporter   ~57804

Great, that was it ! The permission was 755. I changed it for 777 and now it's working.

Thanks a lot !

DenisChenu

DenisChenu

2020-05-14 17:47

developer   ~57809

The strange issue is : why it work before ?

See : https://bugs.limesurvey.org/view.php?id=16271#c57780

ollehar

ollehar

2020-05-18 11:33

administrator   ~57873

Not related to LimeSurvey.

Issue History

Date Modified Username Field Change
2020-05-14 02:24 jbourgin New Issue
2020-05-14 02:24 jbourgin File Added: error.png
2020-05-14 02:24 jbourgin File Added: printable_survey_allez_848936.zip
2020-05-14 09:25 DenisChenu Note Added: 57766
2020-05-14 11:50 jbourgin Note Added: 57779
2020-05-14 11:50 jbourgin File Added: error.pdf
2020-05-14 11:59 DenisChenu Note Added: 57780
2020-05-14 12:21 jbourgin Note Added: 57782
2020-05-14 12:21 jbourgin File Added: limesurvey_survey_168744.lss
2020-05-14 12:24 jbourgin Note Added: 57783
2020-05-14 12:24 jbourgin File Added: structure_ls4.png
2020-05-14 16:32 ollehar Note Added: 57791
2020-05-14 16:33 ollehar Priority none => low
2020-05-14 16:41 jbourgin Note Added: 57794
2020-05-14 16:41 jbourgin File Added: error-2.pdf
2020-05-14 16:42 ollehar Note Added: 57795
2020-05-14 16:43 ollehar Note Added: 57796
2020-05-14 17:08 jbourgin Note Added: 57802
2020-05-14 17:11 ollehar Note Added: 57803
2020-05-14 17:19 jbourgin Note Added: 57804
2020-05-14 17:47 DenisChenu Note Added: 57809
2020-05-18 11:33 ollehar Assigned To => ollehar
2020-05-18 11:33 ollehar Status new => closed
2020-05-18 11:33 ollehar Resolution open => won't fix
2020-05-18 11:33 ollehar Note Added: 57873