View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06959Bug reportsCentral participant databasepublic2013-01-31 15:27
ReporterpfpDave Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06959: Edit a custom attribute that's already set gives an error
Description

Whilst attempting to edit a custom attribute against a participant int the Central Participant Database that's already set (doesn't happen if the value is null - ie no attribute record exists), the error below is returned and the edit doesn't happen:

DbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][SQL Server Native Client 11.0]COUNT field incorrect or syntax error. The SQL statement executed was: UPDATE [participant_attribute] SET [participant_id]=:participant_id, [attribute_id]=:attribute_id, [value]=:value WHERE participant_id = :participant_id AND attribute_id = :attribute_id. Bound with :participant_id='3db9a94b-3cf5-4f19-bfaa-b1db6644a031', :attribute_id='2', :value='Test2' (C:\limesurvey_test\framework\db\CDbCommand.php:354)

#0 C:\limesurvey_test\framework\db\CDbCommand.php(1212): CDbCommand->execute(Array)
#1 C:\limesurvey_test\application\models\ParticipantAttributeNames.php(345): CDbCommand->update('{{participant_a...', Array, 'participant_id ...', Array)
#2 C:\limesurvey_test\application\controllers\admin\participantsaction.php(1331): ParticipantAttributeNames->editParticipantAttributeValue(Array)
#3 [internal function]: participantsaction->editAttributevalue()
#4 C:\limesurvey_test\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(Object(participantsaction), Array)
#5 C:\limesurvey_test\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(participantsaction), Object(ReflectionMethod), Array)
#6 C:\limesurvey_test\framework\web\CController.php(309): Survey_Common_Action->runWithParams(Array)
#7 C:\limesurvey_test\framework\web\CController.php(287): CController->runAction(Object(participantsaction))
#8 C:\limesurvey_test\framework\web\CController.php(266): CController->runActionWithFilters(Object(participantsaction), Array)
#9 C:\limesurvey_test\application\controllers\AdminController.php(159): CController->run('participants')
#10 C:\limesurvey_test\framework\web\CWebApplication.php(276): AdminController->run('participants')
#11 C:\limesurvey_test\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/participa...')
#12 C:\limesurvey_test\framework\base\CApplication.php(162): CWebApplication->processRequest()
#13 C:\limesurvey_test\index.php(178): CApplication->run()
#14 {main}

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)121121
I will donate to the project if issue is resolvedNo
BrowserIE8
Database type & versionSQL Express 2012
Server OS (if known)Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-01-31 15:25

administrator   ~23921

pfpDave, I cannot reproduce this. Can you check if this is still an issue, please?

c_schmitz

c_schmitz

2013-01-31 15:27

administrator   ~23922

I am assuming that this is fixed. Please re-open if necessary.

Issue History

Date Modified Username Field Change
2012-11-26 14:21 pfpDave New Issue
2012-11-26 14:21 pfpDave Status new => assigned
2012-11-26 14:21 pfpDave Assigned To => jcleeland
2013-01-31 15:25 c_schmitz Note Added: 23921
2013-01-31 15:25 c_schmitz Assigned To jcleeland => c_schmitz
2013-01-31 15:25 c_schmitz Status assigned => feedback
2013-01-31 15:27 c_schmitz Note Added: 23922
2013-01-31 15:27 c_schmitz Status feedback => closed
2013-01-31 15:27 c_schmitz Resolution open => fixed
2013-01-31 15:27 c_schmitz Fixed in Version => 2.00+