View Issue Details

This issue affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
06661Bug reportsCentral participant databasepublic2012-10-24 14:16
Reportersimid Assigned Toaniesshsethh  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Summary06661: Cannot import or add participant attributes
Description

I can create the attributes, but when I try to import or to edit attributes, I get the following error: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'attribute_id' cannot be null

Steps To Reproduce

Empty central participant database, create 2 attributes (Sex and Speciality)
Import a CSV file with the necessary mandatory fields, and two additional fields (Sex and Speciality).
Import is successful but no attributes imported, although matched at the import screen
When I try to manually change an attribute for a participant, I get the error described above.

TagsNo tags attached.
Attached Files
aniessh.csv (146 bytes)   
firstname, lastname, email, sex, maritalstatus
aniessh,sethh,aniesshsethh@gmail.com,male,single
sethh,aniessh,sethhaniessh@gmail.com,female,single
aniessh.csv (146 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)121006
I will donate to the project if issue is resolvedNo
BrowserFirefox 15.01
Database type & versionMySQL 5.1.65
Server OS (if known)Apache/ Linux
Webserver software & version (if known)Apache
PHP VersionPHP Version 5.2.17
Git branch / Pull Request URL

Users monitoring this issue

aniesshsethh

Activities

aniesshsethh

aniesshsethh

2012-10-21 15:00

reporter   ~21513

Last edited: 2012-10-21 15:02

About the editing of a single attribute, that has been fixed in issue 06669, as for the import CSV, I tried that and it's working fine, I am attaching the CSV with which I tested , can you please attach a sample of CSV that is not working , thanks :) .

simid

simid

2012-10-22 01:03

reporter   ~21518

Hi After the update, both the editing issue and the import are working. Thanx. The two were probably related.
Thank you

aniesshsethh

aniesshsethh

2012-10-22 16:17

reporter   ~21538

np at all :)

c_schmitz

c_schmitz

2012-10-24 14:16

administrator   ~21610

LimeSurvey 2.00+ Build 121024 released. Please update.

Issue History

Date Modified Username Field Change
2012-10-07 23:35 simid New Issue
2012-10-07 23:35 simid Status new => assigned
2012-10-07 23:35 simid Assigned To => jcleeland
2012-10-14 13:39 Mazi Issue Monitored: aniesshsethh
2012-10-21 15:00 aniesshsethh Note Added: 21513
2012-10-21 15:00 aniesshsethh File Added: aniessh.csv
2012-10-21 15:01 aniesshsethh Assigned To jcleeland => aniesshsethh
2012-10-21 15:01 aniesshsethh Status assigned => feedback
2012-10-21 15:02 aniesshsethh Note Edited: 21513
2012-10-21 15:02 aniesshsethh Note Edited: 21513
2012-10-22 01:03 simid Note Added: 21518
2012-10-22 01:03 simid Status feedback => assigned
2012-10-22 16:17 aniesshsethh Note Added: 21538
2012-10-22 16:19 aniesshsethh Status assigned => resolved
2012-10-22 16:19 aniesshsethh Resolution open => fixed
2012-10-24 14:16 c_schmitz Note Added: 21610
2012-10-24 14:16 c_schmitz Status resolved => closed