View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
06911Bug reportsLimeSurvey Websitepublic2012-11-21 02:162012-12-04 13:16
Reportersedlacev Assigned Tomdekker  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Summary06911: Survey Participants import is broken
Description

Importing of new participants from CSV file is nonfunctional in our LimeSurvey.
So I have added manualy and second problem is assigning of respondents to survey is also nonfunctional. See attached file with error report.

TagsNo tags attached.
Attached Files
error.htm (1,408 bytes)    
<!DOCTYPE html PUBLIC
	"-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Internal Server Error</title>

<style type="text/css">
/*<![CDATA[*/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top: -5px}
.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
/*]]>*/
</style>
</head>

<body>
<h1>Internal Server Error</h1>
<h2>CDbCommand failed to execute the SQL statement: SQLSTATE[42703]: Undefined column: 7 ERROR:  column &quot;5e56258b-aac4-4915-956f-6d20e0997d65&quot; does not exist<br />
LINE 3: WHERE participant_id = &quot;5e56258b-aac4-4915-956f-6d20e0997d65...<br />
                               ^</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
</p>
<p>
Thank you.
</p>
<div class="version">
2012-11-21 02:03:00 </div>
</body>
</html>
error.htm (1,408 bytes)   
limesurvey_survey_385488.lss (79 bytes)
Import_Participants_CSV.png (88,707 bytes)   
Import_Participants_CSV.png (88,707 bytes)   
Import_Participants_CSV_TEST_DTB.csv (53 bytes)    
firstname,lastname,email
test,test,sedlo@geodis.cz
Import_Participants_CSV_TEST_DTB.csv (53 bytes)   
Import_Participants_CSV_setup.png (8,367 bytes)   
Import_Participants_CSV_setup.png (8,367 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)121115
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & version???
Server OS (if known)???
Webserver software & version (if known)???
PHP Version???

Users monitoring this issue

c_schmitz

Activities

c_schmitz

c_schmitz

2012-11-21 08:25

administrator   ~22354

Please update to the latest build and let us know if you still get the error.
sedlacev

sedlacev

2012-11-21 10:35

reporter   ~22360

Last edited: 2012-11-22 10:54

Hello,
Assigning participants to survey is now functional.
I still have problem to import participants from CSV file.
See attached file "Import_Participants_CSV.png"

Next problem I have to send inviting emails.
It writes me: "Could not instantiate mail function."

Thanks
sedlacev

sedlacev

2012-11-22 10:53

reporter   ~22402

Reminder sent to: c_schmitz, jcleeland

Hello,
I would ask you if the problems will be solved?
Thanks
jcleeland

jcleeland

2012-11-22 11:29

reporter   ~22409

Sedlacev, the image has some funny things going on in the CSV file.. would it be possible for you to attach a copy of that file? Even just the first two or three lines. Make the bug private if you have concerns.

In relation to having problem with sending invitation emails, that should be a new bug report please!
sedlacev

sedlacev

2012-11-22 14:41

reporter   ~22423

I have attached 2 files:
Import_Participants_CSV_TEST_DTB.csv - with my tested database for import. There is only the 1 participant.
Import_Participants_CSV_setup.png - it shows my settings for import
mdekker

mdekker

2012-11-28 15:41

reporter   ~22628

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

mdekker

2012-11-28 15:42

reporter   ~22630

I had error since there was no mysql connection and then it tries root without password. That was fixed by my commit. Then import partially works for me.
mdekker

mdekker

2012-11-28 15:44

reporter   ~22632

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

sedlacev

2012-11-29 12:48

reporter   ~22692

Our problem was in system CentOS 6.3 x86_64.
In default installation there was deny operation needed for import.
Now it is OK.
Thanks for help.
c_schmitz

c_schmitz

2012-12-04 13:16

administrator   ~22868

LimeSurvey 2.0+ build 121204 released.

Related Changesets

LimeSurvey: master 62d16b91

2012-11-28 15:41

mdekker


Details Diff		 Partial fix 06911: Survey Participants CSV import is broken Affected Issues
06911
mod - application/controllers/admin/participantsaction.php Diff File

LimeSurvey: 2.1 1b3b3467

2012-11-28 15:43

mdekker


Details Diff		 Partial fix 06911: Survey Participants CSV import is broken Affected Issues
06911
mod - application/controllers/admin/participantsaction.php Diff File

Issue History

Date Modified Username Field Change
2012-11-21 02:16 sedlacev New Issue
2012-11-21 02:16 sedlacev Status new => assigned
2012-11-21 02:16 sedlacev Assigned To => c_schmitz
2012-11-21 02:16 sedlacev File Added: error.htm
2012-11-21 02:18 sedlacev File Added: limesurvey_survey_385488.lss
2012-11-21 08:25 c_schmitz Note Added: 22354
2012-11-21 08:25 c_schmitz Status assigned => feedback
2012-11-21 10:31 sedlacev File Added: Import_Participants_CSV.png
2012-11-21 10:35 sedlacev Note Added: 22360
2012-11-21 10:35 sedlacev Status feedback => assigned
2012-11-21 10:38 c_schmitz Assigned To c_schmitz => jcleeland
2012-11-21 10:38 c_schmitz Priority immediate => normal
2012-11-22 10:53 sedlacev Issue Monitored: c_schmitz
2012-11-22 10:53 sedlacev Note Added: 22402
2012-11-22 10:53 sedlacev Note Edited: 22360
2012-11-22 10:53 sedlacev Note Edited: 22360
2012-11-22 10:54 sedlacev Note Edited: 22360
2012-11-22 10:54 sedlacev Note Edited: 22360
2012-11-22 11:29 jcleeland Note Added: 22409
2012-11-22 14:26 sedlacev File Added: Import_Participants_CSV_TEST_DTB.csv
2012-11-22 14:27 sedlacev File Added: Import_Participants_CSV_setup.png
2012-11-22 14:41 sedlacev Note Added: 22423
2012-11-28 15:40 mdekker Summary Survey Participants => Survey Participants import is broken
2012-11-28 15:41 mdekker Changeset attached => LimeSurvey master 62d16b91
2012-11-28 15:41 mdekker Note Added: 22628
2012-11-28 15:41 mdekker Assigned To jcleeland => mdekker
2012-11-28 15:41 mdekker Resolution open => fixed
2012-11-28 15:42 mdekker Note Added: 22630
2012-11-28 15:44 mdekker Changeset attached => LimeSurvey 2.1 1b3b3467
2012-11-28 15:44 mdekker Note Added: 22632
2012-11-29 12:48 sedlacev Note Added: 22692
2012-11-29 13:01 mdekker Status assigned => resolved
2012-12-04 13:16 c_schmitz Note Added: 22868
2012-12-04 13:16 c_schmitz Status resolved => closed
2021-08-05 01:01 guest Bug heat 8 => 10