View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
11513Bug reportsImport/Exportpublic2016-08-05 11:08
ReporterHeinrich Assigned Tomarkusfluer 
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary11513: Error 500 after uploading a CSV file with participants into a survey
Description

I want to upload a CSV file with participants into a survey (see attachment). The upload does not work and produces an ERROR 500. After having enabled debug mode the following error appears:

/is/htdocs/wpXYZ_HR5GTY7ZEJ/www/limesurvey/application/controllers/admin/tokens.php
(2427):
array()

On my webserver the following error is in the error log:

PHP Fatal error: Class 'Chtml' not found in /is/htdocs/wpXYZ_HR5GTY7ZEJ/www/limesurvey/application/controllers/admin/tokens.php on line 2428, referer: https://URL.de/index.php/admin/tokens/sa/import/surveyid/443655

Despite these errors, the first participant in the csv file is uploaded. If I have the same participant multiple times in the CSV file then no error occurs but limesurvey says that there were only duplicates and thusly no participants has been uploaded.

Steps To Reproduce

Open a survey
Click on participants
Click on Create and Import CSV
Upload the csv file attached
--> Error occurs

TagsNo tags attached.
Attached Files
Bug heat10
Complete LimeSurvey version number (& build)160731
I will donate to the project if issue is resolvedNo
BrowserChrome and IE
Database type & versionMySQL 5.5.47-37.7
Server OS (if known)Linux
Webserver software & version (if known)Apache
PHP Version5.6

Users monitoring this issue

Minstrel72

Activities

markusfluer

markusfluer

2016-08-02 10:24

administrator   ~40157

Please attach the csv file.
I will look into it then.

Heinrich

Heinrich

2016-08-02 10:26

reporter   ~40158

Thanks markusfluer! :)

markusfluer

markusfluer

2016-08-02 11:07

administrator   ~40160

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=19901

markusfluer

markusfluer

2016-08-02 11:13

administrator   ~40161

There was a small bug on our side, because an error visualisation methdod was not loaded correctly.
Still the bug did only appear when the csv-file was incorrect.
Please look into the csv file, that it is correctly parsed.
The CSV-File that you uploaded was errenous.
You do not need to quote the values in a csv file, the data separation comes from the comma, and if you quote, please see that you do not double, or triple quote.

Thank you very much for your bug report i hope we could help you.

Heinrich

Heinrich

2016-08-02 11:42

reporter   ~40163

Thank you Markusfleur! That was quick.
I've replaced the two lines with the lines mentioned by you. Upload now works smoothly. However, limesurvey is reporting that there has been an error and no data was uploaded. In particular it says:

Could not create token table
3 records in csv-file
3 records fulfill the minimum requirements
0 records have been uploaded

Warning

3 records with other invalid information

Line 1 : Array ( )
Line 2 : Array ( )
Line 3 : Array ( )

The csv file I'm uploading looks like this:

firstname,lastname,email
Max,Mustermann,mustermann@web.de
Fritz,Hansmann,fritz-hansmann@gmail.com
Wurst,Hans,hans-wurst@web.de

Any suggestions? Actually it's not a big issue because all records have succesfully been uploaded but I think for some users this error message might be irritating.

Thank you!

Minstrel72

Minstrel72

2016-08-03 16:59

reporter   ~40166

Hello,
this issue looks solved but the last message of Heinrich points out another bug, which I was able to replicate.
I have been able to upload my panel, nevertheless the upload reports a full failure.
BTW I just upgraded to 2.5 and it is much better than any previous version :-)

c_schmitz

c_schmitz

2016-08-05 11:08

administrator   ~40177

Version 2.50 Build 160804 released

Related Changesets

LimeSurvey: master 5ff1e397

2016-08-02 09:07:33

markusfluer

Details Diff
Fixed issue 11513: Error 500 after uploading a CSV file with participants into a survey
Dev: removed tracevar, because it just works on unix-based systems
Affected Issues
11513
mod - application/controllers/admin/tokens.php Diff File

Issue History

Date Modified Username Field Change
2016-08-02 09:38 Heinrich New Issue
2016-08-02 10:24 markusfluer Note Added: 40157
2016-08-02 10:24 markusfluer Assigned To => markusfluer
2016-08-02 10:24 markusfluer Status new => feedback
2016-08-02 10:25 Heinrich File Added: Teilnehmer_post_survey.csv
2016-08-02 10:26 Heinrich Note Added: 40158
2016-08-02 10:26 Heinrich Status feedback => assigned
2016-08-02 11:07 markusfluer Changeset attached => LimeSurvey master 5ff1e397
2016-08-02 11:07 markusfluer Note Added: 40160
2016-08-02 11:07 markusfluer Resolution open => fixed
2016-08-02 11:13 markusfluer Note Added: 40161
2016-08-02 11:13 markusfluer Status assigned => resolved
2016-08-02 11:13 markusfluer Fixed in Version => 2.5
2016-08-02 11:42 Heinrich Note Added: 40163
2016-08-03 16:55 Minstrel72 Issue Monitored: Minstrel72
2016-08-03 16:59 Minstrel72 Note Added: 40166
2016-08-05 11:08 c_schmitz Note Added: 40177
2016-08-05 11:08 c_schmitz Status resolved => closed
2021-08-05 00:15 guest Bug heat 8 => 10