View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0017163 | mantisbt | db mssql | public | 2014-04-06 06:53 | 2023-05-04 16:23 |
Reporter | SamCPP | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | no change required | ||
Platform | Microsoft | OS | Windows | OS Version | All |
Product Version | 1.2.17 | ||||
Summary | 0017163: Image, text, ntext deprecated from MSSQL | ||||
Description | Recommended to change the db schema for MantisBT to not use these datatypes in MSSQL as they are flagged to be removed in future versions. Recommended to use the varbinary type. e.g. varbinary(max) or varbinary(8000) etc. See http://technet.microsoft.com/en-us/library/ms187993.aspx. E.g. [mantis_bug_file_table].[content] field. | ||||
Tags | No tags attached. | ||||
Sam, Same again - marking as suspended. Keep an eye on mantisbt-dev list if you would like to help out testing the mssql support. |
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|
We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported. There have been many improvements to MSSQL support in 1.3 and 2.x releases. We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue. |
|