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 | ||||
| Git branch / Pull Request URL | |||||
| 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+ |