View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06333Bug reportsSurvey takingpublic2012-08-04 21:58
Reporterslsemrau Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.92+ 
Summary06333: Survey Response File Downloads missing
Description

I'm perplexed with this one.

Survey setup and usage has been great so far. An administrator setup a survey with several questions that acquire file uploads. The survey is now expired and they are trying to download the files through the Admin interface. However it appears as though some of the files are missing, which in turn causes the actions (download files into a ZIP file) to fail.

  • It would be nice to have some sort of feedback when this fails instead of just refreshing the screen.

When I count the number of file uploads in the database response records I come up with 163 files listed; when I look at the directory where the files reside (/llimesurvey\upload\surveys\43687\files) there are 166 files.

  • Okay that's an interesting thing.

On the first response record I came across, where I cannot download the file uploaded, I did a little investigation:

  • The database table record for the survey, for that response where I can't download, the file DOES IN FACT show a data entry -->

[{"title":"Ledger for Gibbes 2011-12","comment":"Sent As PDF","size":"139.69","name":"224-230_HEYWARD_GIBBES_YTD_BUDGET_REPORT_FY_2011-2012.pdf","filename":"fu_3t7biqfifvj547c","ext":"pdf"}]

  • However when I go to the file upload directory above, that file name < fu_3t7biqfifvj547c > does not exist.

  • That would explain why the ZIP procedure is probably not working when I try to zip ALL files or just the files for that record.

What could have possibly happened that there would be a database entry for the upload ( info above ) yet no corresponding file in the upload directory?

I have several response records like this - over all I would have to say that 90% of the files are in fact there, 10% are missing.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)12170
I will donate to the project if issue is resolvedNo
Browser
Database type & versionSQL Server 2008 Enterprise
Server OS (if known)System Windows NT 6.1 build 7601 (Windows Server 2008 R2 Enterprise Edition Service Pack 1) i586
Webserver software & version (if known)IIS 7.5
PHP Version PHP Version 5.3.10
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-07-18 16:08

administrator   ~19767

It is hard to tell what could have caused this.

The easiest way to find out is by asking the particlar participant to send the file to you, then try to reproduce the issue using the same browser and responses.

Usually there are no sporadic errors, it must be somehow reproducable.

Can you try and give feedback?

slsemrau

slsemrau

2012-07-18 17:24

reporter   ~19787

Thank you for the quick reply. I have contacted the survey administrator to find out if they received the missing files via email as well as if any of the survey takers noticed anything when they tried to upload those files. I will update as soon as I have more information.

c_schmitz

c_schmitz

2012-07-26 11:18

administrator   ~19979

Any news?

c_schmitz

c_schmitz

2012-08-04 21:58

administrator   ~20190

Please reopen if you can reproduce it.

Issue History

Date Modified Username Field Change
2012-07-18 14:28 slsemrau New Issue
2012-07-18 16:08 c_schmitz Note Added: 19767
2012-07-18 16:08 c_schmitz Assigned To => c_schmitz
2012-07-18 16:08 c_schmitz Status new => feedback
2012-07-18 17:24 slsemrau Note Added: 19787
2012-07-18 17:24 slsemrau Status feedback => assigned
2012-07-20 10:28 c_schmitz Status assigned => feedback
2012-07-26 11:18 c_schmitz Note Added: 19979
2012-08-04 21:58 c_schmitz Status feedback => closed
2012-08-04 21:58 c_schmitz Resolution open => unable to reproduce
2012-08-04 21:58 c_schmitz Note Added: 20190