View Issue Details

IDProjectCategoryView StatusLast Update
0007032mantisbtdb mssqlpublic2014-05-16 15:00
Reportervboctor Assigned Tovboctor  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.0rc4 
Fixed in Version1.0.3 
Summary0007032: Port: Error on opening Change Log
Description

I use Mantis with an MS SQL-Server 2000 over ODBC. When I'm opening the Change Log it produces an error:
APPLICATION ERROR #1100
Problem 0 not found.

So, I looked into the code and saw that you have after the loop the following statement $t_result->fields ...
In database_api.php there is a function db_fetch_array in which is little but important comment:

mysql obeys FETCH_MODE_BOTH, hence ->fields works, other drivers do not support this

I think that's the problem

TagsNo tags attached.

Relationships

related to 0006888 closedvboctor Changelog doesn't work on MS SQL 
child of 0006519 closedvboctor Error on opening Change Log 
child of 0006971 closedvboctor Mantis 1.0.3 Release 

Activities

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040426

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