Page 1 of 1

Error Code 206 on Category Deletion

Posted: 04 Feb 2013, 15:06
by dyzel
Hello, have made some new category's and now i want to delete one or two, but when i press delete next to the category i get this message.

Database query failed. Error received from database was #206: SQLState: 22018
Error Code: 206
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Operand type clash: text is incompatible with int
for the query: SELECT count(config_id) FROM mantis_config_table WHERE config_id = ? AND value = ?.

Can someone please tell me what to do?

Re: Error Code 206 on Category Deletion

Posted: 17 Jun 2013, 23:17
by eswartz
I have the same problem... is there a solution?

Re: Error Code 206 on Category Deletion

Posted: 18 Jun 2013, 07:48
by atrol
eswartz,
do you use MySQL or MS SQL?

Re: Error Code 206 on Category Deletion

Posted: 05 Aug 2013, 06:49
by seizai
me too... any solutions?

SQL 2008R2

Re: Error Code 206 on Category Deletion

Posted: 11 Jan 2016, 22:09
by jakal_x
This happens on ms sql server installations. There is a column named 'value' in table mantis_config_table that has a default data type of text. Change it to int.

Re: Error Code 206 on Category Deletion

Posted: 12 Jan 2016, 06:46
by atrol
jakal_x wrote:Change it to int.
This can't be a solution as we store also text in this column.