Error Code 206 on Category Deletion

[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?

[eswartz]

I have the same problem... is there a solution?

[atrol]

eswartz,
do you use MySQL or MS SQL?

[seizai]

me too... any solutions?

SQL 2008R2

[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.

[atrol]

Change it to int.

This can't be a solution as we store also text in this column.