07253: Adding participants to a survey/generating tokens fail with MS-SQL errors

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

07253	Bug reports	Survey participants (Tokens)	public	2013-01-30 16:42	2013-02-23 15:16

Reporter	mgib134	Assigned To	c_schmitz
Priority	normal	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	07253: Adding participants to a survey/generating tokens fail with MS-SQL errors
Description	Adding a participant from the central participant database to a survey fails with MS-SQL errors and a boatload of unrelated html in the error message.
Steps To Reproduce	Open participant database Select a user, "Add to Survey" Select a survey -> Next to "Map your participant attributes..." page Continue
Tags	No tags attached.
Attached Files	limesurvey_survey_329556.lss (79,516 bytes) Conversion Error.PNG (56,608 bytes) Conversion Error.PNG (56,608 bytes) Incorrect Syntaxt Error.png (198,308 bytes) Invalid object name error.PNG (54,906 bytes) Invalid object name error.PNG (54,906 bytes) PK Violation Error.PNG (52,867 bytes) PK Violation Error.PNG (52,867 bytes)

Bug heat	8
Complete LimeSurvey version number (& build)	130122
I will donate to the project if issue is resolved	No
Browser	Chrome V 24.0.1312.56 m
Database type & version	MS-SQL 2005 V 9.00.5000.00
Server OS (if known)	Windows Server 2003 SP2
Webserver software & version (if known)	Windows Webserver 2008 R2
PHP Version	5.4.8

User List	mgib134

DenisChenu 2013-01-30 21:32 developer ~23904	Can you put the error HTML file here ?

mgib134 2013-01-30 21:51 reporter ~23905	Just a note: these were taken on various build numbers over the last few days/weeks. We're currently on build 130129, and the messages persist. Just FYI.

sammousa 2013-02-04 09:51 reporter ~23939	It seems the HTML errors are not actually errors. Basically when an internal server error occurs it is rendered inside a layout. The error message, however, just shows plain text which explains why there is a lot of html source visible. Fixing the database error will fix everything.

DenisChenu 2013-02-04 10:41 developer ~23940	Yes sammoussa, think same :). Did you start work on it ? Think i take 1 or 2 hours on this one today (if time .. )

DenisChenu 2013-02-04 11:02 developer ~23941 Last edited: 2013-02-04 11:11	I can't reproduce 8\| ms-sql only ? Or "maybe" with token associated automatically ?

mgib134 2013-02-06 19:30 reporter ~23953	Updated to build 130206 today, and that seems to have resolved the issue. Thought you'd like to know.

mgib134 2013-02-14 17:43 reporter ~24083	....and then it showed up again. Updating to 130213 again seemed to resolve, but I'm willing to be it's going to re-appear.

Date Modified	Username	Field	Change
2013-01-30 16:42	mgib134	New Issue
2013-01-30 16:42	mgib134	File Added: limesurvey_survey_329556.lss
2013-01-30 21:32	DenisChenu	Note Added: 23904
2013-01-30 21:49	mgib134	File Added: Conversion Error.PNG
2013-01-30 21:49	mgib134	File Added: Incorrect Syntaxt Error.png
2013-01-30 21:49	mgib134	File Added: Invalid object name error.PNG
2013-01-30 21:50	mgib134	File Added: PK Violation Error.PNG
2013-01-30 21:51	mgib134	Note Added: 23905
2013-01-31 12:05	c_schmitz	Assigned To	=> c_schmitz
2013-01-31 12:05	c_schmitz	Status	new => assigned
2013-01-31 14:26	c_schmitz	Assigned To	c_schmitz => jcleeland
2013-02-04 09:51	sammousa	Note Added: 23939
2013-02-04 10:41	DenisChenu	Note Added: 23940
2013-02-04 11:02	DenisChenu	Note Added: 23941
2013-02-04 11:11	DenisChenu	Note Edited: 23941
2013-02-06 19:24	mgib134	Issue Monitored: mgib134
2013-02-06 19:30	mgib134	Note Added: 23953
2013-02-14 17:43	mgib134	Note Added: 24083
2013-02-23 15:16	c_schmitz	Status	assigned => closed
2013-02-23 15:16	c_schmitz	Assigned To	jcleeland => c_schmitz
2013-02-23 15:16	c_schmitz	Resolution	open => fixed
2013-02-23 15:16	c_schmitz	Fixed in Version	=> 2.00+
2016-12-08 10:39	c_schmitz	Category	Tokens => Survey participants (Tokens)