View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08520Bug reportsImport/Exportpublic2014-01-08 21:592014-01-09 23:31
Reporterrossokr Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08520: Import participants from .csv fails if 'created by' field is NULL
Description

I recently upgraded LimeSurvey version 2.0. build 131206 to 2.0.5 build 131219. I have about 2090 participants (global) that were previously imported. After the upgrade I tried to import more users and the error I was eventually able to catch inside Participant::model()->insertParticipantCSV was:

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field 'created_by' doesn't have a default value. The SQL statement executed was: INSERT INTO lime_participants (participant_id, firstname, lastname, email, language, blacklisted, owner_uid) VALUES (:participant_id, :firstname, :lastname, :email, :language, :blacklisted, :owner_uid), referer: http://localhost/limesurvey-local/index.php/admin/participants/sa/attributeMapCSV

So I removed the NOT NULL restraint from the DB manually and the issue was fixed. My question is... was your intent to change the database (and forgot to update the code) or in fact change the actual code (and forgot to update the code)??

Steps To Reproduce

-create a .csv file with 'new' users to import (firstname,lastname,email)
-navigate to central database panel > import from .csv > import > continue
-'processing' message hangs

Additional Information

I realize that this issue may have already been resolved but since I just upgraded I wanted to get an understanding of why this change was made and if it was inadvertent. I will leave my database structure as-is, for now, until I hear otherwise.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.0.5 build 131219
I will donate to the project if issue is resolvedYes
BrowserChrome on Mac
Database type & versionMySQL 5.6.12 MySQL Community Server (GPL)
Server OS (if known)Mac OS X 10.7.5 (Lion)
Webserver software & version (if known)apache 2
PHP Version5.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-09 09:04

administrator   ~27782

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

c_schmitz

2014-01-09 09:05

administrator   ~27783

Thank you for reporting this. Please find the fix above. We are looking forward to your donation.
rossokr

rossokr

2014-01-09 22:12

reporter   ~27795

I've made the contribution and look forward to your support in the future
c_schmitz

c_schmitz

2014-01-09 23:31

administrator   ~27798

2.05+ build 140109 released

Related Changesets

LimeSurvey: master fcfac042

2014-01-09 08:05:27

c_schmitz

Details Diff 		Fixed issue 08520: Import participants from .csv fails Affected Issues
08520
mod - application/models/Participant.php Diff File

Issue History

Date Modified Username Field Change
2014-01-08 21:59 rossokr New Issue
2014-01-09 09:03 c_schmitz Assigned To => c_schmitz
2014-01-09 09:03 c_schmitz Status new => assigned
2014-01-09 09:04 c_schmitz Changeset attached => LimeSurvey master fcfac042
2014-01-09 09:04 c_schmitz Note Added: 27782
2014-01-09 09:04 c_schmitz Resolution open => fixed
2014-01-09 09:05 c_schmitz Note Added: 27783
2014-01-09 09:05 c_schmitz Status assigned => resolved
2014-01-09 09:05 c_schmitz Fixed in Version => 2.05+
2014-01-09 22:12 rossokr Note Added: 27795
2014-01-09 23:31 c_schmitz Note Added: 27798
2014-01-09 23:31 c_schmitz Status resolved => closed