0013409: Plugin database error with config_table and the value field as an text - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0013409	mantisbt	plug-ins	public	2011-10-14 09:54	2012-01-17 03:32

Reporter	jyperion	Assigned To	dregad
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Platform	MS SQL 2005
Product Version	1.2.8

Summary	0013409: Plugin database error with config_table and the value field as an text
Description	test With MS SQL 2005 the config_table is set with column "value" as a text type. When you install a plugin , there are database error due to config_table and the param array where value is an integer. test with several plugin (Source, XMLImportExport), the plugin_api.php want to "config_set" for shema with value at -1 or another integer (version 15 for Source) As the query is build with an integer for value (or float) , the SQL server return an error, because it is impossible to "UPDATE mantis_config_table set value = ?" and param is -1 and not '-1'
Additional Information	Pull request available: https://github.com/mantisbt/mantisbt/pull/17
Tags	mssql, plugin

atrol 2012-01-03 03:31 developer ~0030770	partially overlaps with patch to fix 0012081

dregad 2012-01-03 06:39 developer ~0030774	Thanks atrol, this is actually the same issue, and while jyperion's proposed pull request addresses it in a slightly different way, the results are identical, so I'm resolving this one as duplicate.

duplicate of	0012081	closed	dregad	call function config_set error
related to	0011776	closed	dregad	Support for Sql Server Native driver (sqlsrv)