View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09158 | Bug reports | Statistics | public | 2014-08-05 22:52 | 2014-09-09 01:06 |
Reporter | ScottIon | Assigned To | c_schmitz | ||
Priority | normal | Severity | block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 2.05+ | ||||
Summary | 09158: code crashes when trying to generate zip file of uploaded files | ||||
Description | When in the Browse Responses screen, viewing the list of survey responses, I tried to download a zip file of all the uploaded files. With debug mode off, there was no effect (screen refreshed, but no file download happened). Turning debug mode on resulted in a CDbException (see add'l info below). | ||||
Steps To Reproduce |
| ||||
Additional Information | CDbException Column name must be either a string or an array. \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\db\schema\CDbCommandBuilder.php(828) 816 } Stack Trace #0 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\db\schema\CDbCommandBuilder.php(621): CDbCommandBuilder->createInCondition(CMssqlTableSchema, null, array("4"), "[t].") #1 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\db\ar\CActiveRecord.php(1501): CDbCommandBuilder->createPkCriteria(CMssqlTableSchema, "4", "", array(), ...) #2 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\application\controllers\admin\responses.php(803): CActiveRecord->findAllByPk("4") #3 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\application\controllers\admin\responses.php(389): responses->_zipFiles("463464", "4", "Files_for_responses_4.zip") #4 unknown(0): responses->browse("463464") #5 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\actions\CAction.php(108): ReflectionMethod->invokeArgs(responses, array("463464")) #6 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\application\core\Survey_Common_Action.php(99): CAction->runWithParamsInternal(responses, ReflectionMethod, array("r" => "admin/responses/sa/browse/surveyid/463464", "sa" => "browse", "surveyid" => "463464", "iSurveyId" => "463464", ...)) #7 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\CController.php(308): Survey_Common_Action->runWithParams(array("r" => "admin/responses/sa/browse/surveyid/463464", "sa" => "browse", "surveyid" => "463464")) #8 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\CController.php(286): CController->runAction(responses) #9 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\CController.php(265): CController->runActionWithFilters(responses, array()) #10 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\application\controllers\AdminController.php(169): CController->run("responses") #11 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\CWebApplication.php(282): AdminController->run("responses") #12 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\web\CWebApplication.php(141): CWebApplication->runController("admin/responses/sa/browse/surveyid/463464") #13 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\framework\base\CApplication.php(180): CWebApplication->processRequest() #14 – \TDSBWWWDATA\WWWTST$\LimeSurvey\www\index.php(200): CApplication->run() 2014-08-05 20:34:15 Microsoft-IIS/7.5 Yii Framework/1.1.14 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | Version 2.05+ Build 140717 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | IE 11 | ||||
Database type & version | MS SQL 2012 | ||||
Server OS (if known) | Windows 2008 R2 | ||||
Webserver software & version (if known) | IIS | ||||
PHP Version | 5.4.17 | ||||
No problems here - did you clean your browser cache after updating to the latest version? If not please try that first. |
|
Yes - cleared the browser cache, and tried with multiple browsers (Firefox / Chrome). When we did the upgrade to the latest version, we also recycled the application pool. I'm also running into another issue now (since we upgraded to the latest version) - when I try to go in as a regular user to complete the survey, the 'Upload Files' window is not working. It allows me to select a file, but then does not display it in the window once selected, and doesn't store any info. Could all of this be related to folder permissions (or DB permissions)? We're running this on a Windows box w. SQL server. File permissions are set to read-only for everything except for full permissions on the /tmp folder (and all sub-folders). Are you testing on a linux/unix box or on Windows? |
|
Ehm, write permission needs to be set for the /upload folder (and any subfolders), too. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2014-08-05 22:52 | ScottIon | New Issue | |
2014-08-05 22:52 | ScottIon | File Added: limesurvey_survey_463464.lss | |
2014-08-06 16:08 | c_schmitz | Assigned To | => c_schmitz |
2014-08-06 16:08 | c_schmitz | Status | new => assigned |
2014-08-08 12:56 | c_schmitz | Note Added: 30402 | |
2014-08-08 12:56 | c_schmitz | Status | assigned => feedback |
2014-08-15 15:19 | ScottIon | Note Added: 30423 | |
2014-08-15 15:19 | ScottIon | Status | feedback => assigned |
2014-09-09 01:06 | c_schmitz | Note Added: 30508 | |
2014-09-09 01:06 | c_schmitz | Status | assigned => closed |
2014-09-09 01:06 | c_schmitz | Resolution | open => unable to reproduce |