View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
07191 | Bug reports | Survey participants (Tokens) | public | 2013-01-15 10:41 | 2013-03-02 16:34 |
Reporter | pfpDave | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 07191: Surey links not deleted when deactivating survey? - Error when adding a token to a survey that has previously had a token table | ||||
Description | Suspect Survey links not removed when survey deactivated looking as SQL? See steps to reproduce to see issue | ||||
Steps To Reproduce | Create Survey Error returned: <h1>CDbException</h1> CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK__survey_l__242D72FDE35AC69C'. Cannot insert duplicate key in object 'dbo.survey_links'. The duplicate key value is (6d4553a4-a2f0-49f4-83c3-30619a8fda5b, 2, 816272).. The SQL statement executed was: INSERT INTO [survey_links] ([participant_id], [token_id], [survey_id], [date_created]) VALUES (:participant_id, :token_id, :survey_id, :date_created) (C:\limesurvey\framework\db\CDbCommand.php:354) #0 C:\limesurvey\framework\db\CDbCommand.php(1178): CDbCommand->execute(Array) | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 130108 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 18 | ||||
Database type & version | SQL Express 2012 | ||||
Server OS (if known) | Server 2008 | ||||
Webserver software & version (if known) | IIS 7 | ||||
PHP Version | 5.4.8 | ||||
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11672 |
|
New version released. |
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11726 |
|
LimeSurvey: master 046f1ba4 2013-02-22 22:02 Details Diff |
Fixed issue 07191: Survey links not deleted when deactivating a survey |
Affected Issues 07191 |
|
mod - application/controllers/admin/surveyadmin.php | Diff File | ||
mod - application/models/Survey.php | Diff File | ||
LimeSurvey: 2.1 4db3f66d 2013-02-22 22:02 Details Diff |
Fixed issue 07191: Survey links not deleted when deactivating a survey |
Affected Issues 07191 |
|
mod - application/controllers/admin/surveyadmin.php | Diff File | ||
mod - application/models/Survey.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2013-01-15 10:41 | pfpDave | New Issue | |
2013-01-18 23:37 | c_schmitz | Assigned To | => c_schmitz |
2013-01-18 23:37 | c_schmitz | Status | new => assigned |
2013-01-22 13:57 | c_schmitz | Assigned To | c_schmitz => jcleeland |
2013-02-22 22:02 | c_schmitz | Assigned To | jcleeland => c_schmitz |
2013-02-22 22:02 | c_schmitz | Status | assigned => resolved |
2013-02-22 22:02 | c_schmitz | Fixed in Version | => 2.00+ |
2013-02-22 22:02 | c_schmitz | Resolution | open => fixed |
2013-02-22 22:02 | c_schmitz | Changeset attached | => LimeSurvey master 046f1ba4 |
2013-02-22 22:02 | c_schmitz | Note Added: 24206 | |
2013-02-26 20:03 | c_schmitz | Note Added: 24417 | |
2013-02-26 20:03 | c_schmitz | Status | resolved => closed |
2013-03-02 16:34 | c_schmitz | Changeset attached | => LimeSurvey 2.1 4db3f66d |
2013-03-02 16:34 | c_schmitz | Note Added: 24481 | |
2016-12-08 10:39 | c_schmitz | Category | Tokens => Survey participants (Tokens) |