View Issue Details

WikiRelated ChangesetsJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0014574mantisbtdb mssqlpublic2012-08-09 15:562014-09-23 18:05
Reportertomkraw1 Assigned Todregad  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.11 
Target Version1.2.12Fixed in Version1.2.12 
Summary0014574: sql server info during installation
Description

There is no information when installing MantisBT on the SQL Server using native driver about supported database versions. Solution is simple and I'm attaching a patch that checks for supported SQL Server version.

TagsNo tags attached.
Attached Files
install.php.patch (459 bytes)    
--- D:/wamp/www/www.mantis.local/admin/install-orig.php	Sat Jun 09 07:29:02 2012
+++ D:/wamp/www/www.mantis.local/admin/install.php	Thu Aug 09 21:49:40 2012
@@ -378,6 +378,10 @@
 			case 'pgsql':
 			case 'mssql':
 			case 'mssqlnative':
+				if( version_compare( $t_version_info['version'], '9.0.0', '<' ) ) {
+					$t_error = 'SQL Server 2005 or later is required for installation.';
+				}
+				break;
 			case 'db2':
 			default:
 				break;
install.php.patch (459 bytes)   

Relationships

related to 0015721 closedgrangeway Functionality to consider porting to master-2.0.x 
related to 0010607 closeddregad Non-ASCII characters, collation and MS SQL Server 

Activities

dregad

dregad

2012-08-10 05:17

developer   ~0032537

Thanks for the patch !
grangeway

grangeway

2013-04-05 17:56

reporter   ~0036149

Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040351

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
Paul

Related Changesets

MantisBT: master-1.2.x e05334c8

2012-08-09 22:06

dregad


Details Diff		 Fix 0014574: MSSQL server 2005 as minimum version Affected Issues
0014574
mod - admin/install.php Diff File
mod - docbook/administration_guide/en/installation.sgml Diff File

MantisBT: master 5a1b0586

2012-08-09 22:06

dregad


Details Diff		 Fix 0014574: MSSQL server 2005 as minimum version Affected Issues
0014574
mod - admin/install.php Diff File
mod - docbook/Admin_Guide/en-US/Installation.xml Diff File