07196: Completing Admin Data Entry for survey with tokens screen gives SQL Error - LimeSurvey bugs, patches and feature requests

LimeSurvey issue tracker

Registration

View Issue Details [ Jump to Notes ] [ Related Changesets ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

07196

Bug reports

[All Projects] 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+

Target Version

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'

I will donate to the project if issue is resolved within 48 hrs

LimeSurvey build number

130108

Browser

IE8

Database & DB-Version

SQL Express 2012

Operating System (Server)

Server 2008

Webserver software & version

IIS 7

PHP Version

5.4.8

Attached Files

Relationships

Notes
(23696) mdekker (developer) 2013-01-16 16:05	Note to self: See 7122: https://github.com/LimeSurvey/LimeSurvey/commit/472d4700c9bc868c76c34368b2bfb24eec5eb515 [^] Probably needs a similar fix

(23708) c_schmitz (administrator) 2013-01-18 21:52	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11309 [^]

(23709) c_schmitz (administrator) 2013-01-18 21:57	@mdekker: No, it doesn't. @pfpDave: Please let us know if the patch resolves the issue for you.

(23755) c_schmitz (administrator) 2013-01-22 14:53	2.00+ Build 120122 released.

(23974) pfpDave (reporter) 2013-02-07 11:19	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.

Related Changesets
LimeSurvey: master da872d92 Timestamp: 2013-01-18 20:52:08 Author: c_schmitz Committer: Carsten Schmitz [ Details ] [ Diff ]	Fixed issue 07196: Completing admin data entry for survey with tokens screen gives SQL Error on MSSQL
	mod - application/controllers/admin/dataentry.php	[ Diff ] [ File ]

Issue History
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 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