View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06959 | Bug reports | Central participant database | public | 2012-11-26 14:21 | 2013-01-31 15:27 |
Reporter | pfpDave | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06959: 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) | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 121121 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | IE8 | ||||
Database type & version | SQL Express 2012 | ||||
Server OS (if known) | Server 2008 | ||||
Webserver software & version (if known) | IIS 7 | ||||
PHP Version | 5.4.8 | ||||
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+ |