View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07196 | Bug reports | Other | public | 2013-01-16 14:06 | 2013-02-07 11:21 |
| Reporter | pfpDave | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Fixed in Version | 2.00+ | ||||
| Summary | 07196: Completing Admin Data Entry for survey with tokens screen gives SQL Error | ||||
| Description | Using the Data Entry screen from the admin interface gives the SQL error below when a survey is 'Tokenised': Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.. The SQL statement executed was: UPDATE tokens_571774 SET usesleft=usesleft-1, completed='2013-01-16 13:04:22' WHERE token='wf2379qjgwcx9y7' | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 130108 | ||||
| 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 | |||||
|
Note to self: See 7122: https://github.com/LimeSurvey/LimeSurvey/commit/472d4700c9bc868c76c34368b2bfb24eec5eb515 Probably needs a similar fix |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11309 |
|
|
@mdekker: No, it doesn't. @pfpDave: Please let us know if the patch resolves the issue for you. |
|
|
2.00+ Build 120122 released. |
|
|
This seems to work for me, very many thanks. Sorry for being quiet recently, it's manic here but I'll get back into the testing properly soon. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-01-16 14:06 | pfpDave | New Issue | |
| 2013-01-16 16:05 | mdekker | Note Added: 23696 | |
| 2013-01-18 17:16 | mgib134 | Issue Monitored: mgib134 | |
| 2013-01-18 17:16 | mgib134 | Issue End Monitor: mgib134 | |
| 2013-01-18 21:47 | c_schmitz | Assigned To | => c_schmitz |
| 2013-01-18 21:47 | c_schmitz | Status | new => assigned |
| 2013-01-18 21:52 | c_schmitz | Status | assigned => resolved |
| 2013-01-18 21:52 | c_schmitz | Fixed in Version | => 2.00+ |
| 2013-01-18 21:52 | c_schmitz | Resolution | open => fixed |
| 2013-01-18 21:52 | c_schmitz | Changeset attached | => LimeSurvey master da872d92 |
| 2013-01-18 21:52 | c_schmitz | Note Added: 23708 | |
| 2013-01-18 21:57 | c_schmitz | Note Added: 23709 | |
| 2013-01-22 14:53 | c_schmitz | Note Added: 23755 | |
| 2013-01-22 14:53 | c_schmitz | Status | resolved => closed |
| 2013-02-07 11:19 | pfpDave | Note Added: 23974 | |
| 2013-02-07 11:19 | pfpDave | Status | closed => feedback |
| 2013-02-07 11:19 | pfpDave | Resolution | fixed => reopened |
| 2013-02-07 11:21 | c_schmitz | Status | feedback => closed |
| 2013-02-07 11:21 | c_schmitz | Resolution | reopened => fixed |