View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0021182||mantisbt||db schema||public||2016-06-30 19:57||2016-07-12 13:13|
|Summary||0021182: SQL Server: Error deleting category|
Error deleting category in:
|Steps To Reproduce|
1) Install Mantis with SQL Server
This boils down to a problem comparing TEXT fields to quoted strings, in this case
Question: why keep VARCHAR and CHAR around at all? If we are using UTF-8 exclusively, then
|Tags||No tags attached.|
@atrol - would you like for me to take a crack at fixing this code? I know a fair amount of PHP, and have pretty good SQL Server skills. I think I know what is wrong here, and how to fix it.
I also have some motivation for getting Mantis to work properly here at our Windows/Office/SQL Server shop.
The Mantis code base looks well-written and easy to understand. I looked briefly at your latest development branch, and it doesn't look too different from the latest release version.
The only questions are:
1) Performing the fixes in a way that is compatible with your future goals.
Let me know what you think.
@kismert, that sounds very good, especially as there is no Mantis core developer at the moment that uses SQL-Server.
Submitting a patch is always a good idea, as it increases the chances of improvement eventually making it into MantisBT core. All contributions are welcome and greatly appreciated.
Patch submissions can be made in several ways. In the order of preference:
Kindly avoid to upload entire modified PHP files.
Please make sure that your submissions adhere to our Coding Guidelines , if they don't your patch might be rejected.
Version 1.2.x is no longer supported.