Dependency Graph

Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
15833Bug reportsImport/Exportpublic2020-03-02 16:49
ReporterMalte Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version4.1.1 
Summary15833: Cannot export .dat-file needed for SPSS after updating to version 4
Description

After an update from version 3 to 4 when trying to export data from a number of surveys, the .dat-file (which is then converted into a SPSS-file / “Export response data to SPSS > Step 2 – Export data”) could not be downloaded any more. The browser shows an error message (translated from German - see also screenshot):
“Error: file not found
An error occurred while connecting to [address of webserver]
Please check the address for spelling mistakes.
Please check, if the address has been changes, deleted of moved.”

Export of all other types of data-files (e.g. CSV, Excel) I have tried so far, as well as the SPSS-syntax-file, works just fine.
I first realized this issue with version 4.0.0 build 200116 but the problem still persists after updating to version 4.1.1 build 200203.

TagsNo tags attached.
Attached Files
200207Screenshot_LimeSurvey.jpg (46,460 bytes)   
200207Screenshot_LimeSurvey.jpg (46,460 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)4.1.1 build 200203
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql version 425
Server OS (if known)Linux limesierra 4.15.0-76-generic #86-Ubuntu SMP Fri Jan 17 17:24:28 UTC 2020 x86_64
Webserver software & version (if known)Apache/2.4.29 (Ubuntu)
PHP Version7.2.24-0ubuntu0.18.04.2

Relationships

duplicate of 15073 closedc_schmitz Cannot export spss Data or Excel 

Activities

DenisChenu

DenisChenu

2020-02-07 12:07

developer   ~55798

Confirm a simpla LSA (one question text) broke

ollehar

ollehar

2020-02-07 12:14

administrator   ~55799

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

DenisChenu

DenisChenu

2020-02-07 12:21

developer   ~55801

@ollehar : i always have debug to 2. No error message :)

But since i log error …

2020/02/07 11:06:01 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ls_develop.lime_tokens_349151' doesn't exist. The SQL statement executed was: SHOW FULL COLUMNS FROM `lime_tokens_349151`.
2020/02/07 11:06:01 [error] [exception.CDbException] CDbException: The table "{{tokens_349151}}" for active record class "Token_349151" cannot be found in the database. in /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php:2390
Stack trace:
#0 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(413): CActiveRecordMetaData->__construct(Object(Token_349151))
#1 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(682): CActiveRecord->getMetaData()
#2 /mnt/data/shnoulle/nginx/www/master/application/models/LSActiveRecord.php(35): CActiveRecord->hasAttribute('created')
#3 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(398): LSActiveRecord->behaviors()
#4 /mnt/data/shnoulle/nginx/www/master/application/models/Dynamic.php(38): CActiveRecord::model('Token_349151')
#5 /mnt/data/shnoulle/nginx/www/master/application/models/Token.php(335): Dynamic::model('Token_349151')
#6 /mnt/data/shnoulle/nginx/www/master/application/helpers/export_helper.php(99): Token::model('349151')
#7 /mnt/data/shnoulle/nginx/www/master/application/controllers/admin/export.php(462): SPSSExportData('349151', '16384', '', ''', false, 'en')
#8 [internal function]: export->exportspss()
#9 /mnt/data/shnoulle/nginx/www/master/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(export), Array)
#10 /mnt/data/shnoulle/nginx/www/master/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal(Object(export), Object(ReflectionMethod), Array)
#11 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(308): Survey_Common_Action->runWithParams(Array)
#12 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(286): CController->runAction(Object(export))
#13 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(265): CController->runActionWithFilters(Object(export), Array)
#14 /mnt/data/shnoulle/nginx/www/master/application/controllers/AdminController.php(165): CController->run('export')
#15 /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(282): AdminController->run('export')
#16 /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(141): CWebApplication->runController('admin/export/sa...')
#17 /mnt/data/shnoulle/nginx/www/master/framework/base/CApplication.php(185): CWebApplication->processRequest()
#18 /mnt/data/shnoulle/nginx/www/master/index.php(195): CApplication->run()
#19 {main}
REQUEST_URI=/master/index.php/admin/export/sa/exportspss/sid/349151
HTTP_REFERER=http://limesurvey.local/master/index.php/admin/export/sa/exportspss/sid/349151
Malte

Malte

2020-02-07 12:23

reporter   ~55802

Thanks for your quick replies.

I imported the survey-example and had the same issue when trying to export the .dat-file.

I'll try to get the complete error mesage, as quick as possible (I personally do not have access to the server).

Malte

Malte

2020-02-10 10:08

reporter   ~55816

Debug =2 has been enabled.
However, we are not quite sure, where to find the error-log, as the error.log on the server does not contain any information.
There is now a performance log shown in the browser, but the information displayed there does not look like the other error-logs posted here (see screenshot - that shows just the last few lines).

Issue History

Date Modified Username Field Change
2020-02-07 10:45 Malte New Issue
2020-02-07 10:45 Malte File Added: 200207Screenshot_LimeSurvey.jpg
2020-02-07 12:07 DenisChenu File Added: survey_archive_349151.lsa
2020-02-07 12:07 DenisChenu Note Added: 55798
2020-02-07 12:14 ollehar Note Added: 55799
2020-02-07 12:14 ollehar Status new => feedback
2020-02-07 12:21 DenisChenu Note Added: 55801
2020-02-07 12:23 Malte Note Added: 55802
2020-02-07 12:23 Malte Status feedback => new
2020-02-10 10:08 Malte File Added: 200210Screenshot_LimeSurvey_log.jpg
2020-02-10 10:08 Malte Note Added: 55816
2020-03-02 16:49 c_schmitz Relationship added duplicate of 15073
2020-03-02 16:49 c_schmitz Assigned To => c_schmitz
2020-03-02 16:49 c_schmitz Status new => closed
2020-03-02 16:49 c_schmitz Resolution open => duplicate