View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
07028Bug reportsSurvey participants (Tokens)public2012-12-07 09:58
ReporterpfpDave Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07028: Editing a participant in the CPD gives CDbException error
Description

As discussed in 06956, when attempting to edit a participant name in the CPD, the following error is given when you press Return:

CDbException
CDbCommand 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 [participants] SET [participant_id]=:participant_id, [firstname]=:firstname, [lastname]=:lastname, [email]=:email, [language]=:language, [blacklisted]=:blacklisted, [owner_uid]=:owner_uid WHERE participant_id = :participant_id. Bound with :participant_id='0251af7d-bc74-4f1b-9328-0682cf6631c2', :firstname='Fred', :lastname='Hardy-Test', :email='dummy.email@domain.co.uk', :language='en', :blacklisted='N', :owner_uid=1 (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\Participants.php(157): CDbCommand->update('{{participants}...', Array, 'participant_id ...', Array)
#2 C:\limesurvey_test\application\controllers\admin\participantsaction.php(532): Participants->updateRow(Array)
#3 [internal function]: participantsaction->editParticipant()
#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\application\controllers\admin\participantsaction.php(51): Survey_Common_Action->runWithParams(Array)
#7 C:\limesurvey_test\framework\web\CController.php(309): participantsaction->runWithParams(Array)
#8 C:\limesurvey_test\framework\web\CController.php(287): CController->runAction(Object(participantsaction))
#9 C:\limesurvey_test\framework\web\CController.php(266): CController->runActionWithFilters(Object(participantsaction), Array)
#10 C:\limesurvey_test\application\controllers\AdminController.php(169): CController->run('participants')
#11 C:\limesurvey_test\framework\web\CWebApplication.php(276): AdminController->run('participants')
#12 C:\limesurvey_test\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/participa...')
#13 C:\limesurvey_test\framework\base\CApplication.php(162): CWebApplication->processRequest()
#14 C:\limesurvey_test\index.php(178): CApplication->run()
#15 {main}

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)121204
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

mdekker

mdekker

2012-12-06 21:10

reporter   ~22986

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

mdekker

mdekker

2012-12-06 21:11

reporter   ~22987

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

c_schmitz

c_schmitz

2012-12-07 09:58

administrator   ~23000

2.00+ build 121207 released.

Related Changesets

LimeSurvey: master c2be07b8

2012-12-06 20:08:41

mdekker

Details Diff
Fixed 07028: Editing a participant in the CPD gives CDbException error Affected Issues
07028
mod - application/models/Participants.php Diff File

LimeSurvey: 2.1 e8144a36

2012-12-06 20:10:37

mdekker

Details Diff
Fixed 07028: Editing a participant in the CPD gives CDbException error Affected Issues
07028
mod - application/models/Participants.php Diff File

Issue History

Date Modified Username Field Change
2012-12-05 14:17 pfpDave New Issue
2012-12-06 21:02 mdekker Assigned To => mdekker
2012-12-06 21:02 mdekker Status new => assigned
2012-12-06 21:10 mdekker Changeset attached => LimeSurvey master c2be07b8
2012-12-06 21:10 mdekker Note Added: 22986
2012-12-06 21:10 mdekker Resolution open => fixed
2012-12-06 21:11 mdekker Changeset attached => LimeSurvey 2.1 e8144a36
2012-12-06 21:11 mdekker Note Added: 22987
2012-12-06 21:11 mdekker Status assigned => resolved
2012-12-06 21:11 mdekker Fixed in Version => 2.00+
2012-12-07 09:58 c_schmitz Note Added: 23000
2012-12-07 09:58 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)