View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006519 | mantisbt | db oracle | public | 2005-12-20 08:46 | 2014-05-16 15:01 |
Reporter | Willimaendu | Assigned To | vboctor | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.0.0rc4 | ||||
Fixed in Version | 1.1.0a1 | ||||
Summary | 0006519: 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: So, I looked into the code and saw that you have after the loop the following statement $t_result->fields ... mysql obeys FETCH_MODE_BOTH, hence ->fields works, other drivers do not support thisI think that's the problem | ||||
Tags | No tags attached. | ||||
I replaced the code for loop with the following. Now it works for MS SQL2k... |
|
With Oracle I had the same problem, this is the solution : for ( $t_result = db_query( $query ); !$t_result->EOF; $t_result->MoveNext() ) { hide private bugs if user doesn't have access to view them. |
|
This is fixed as part 0006888. I didn't mark this as duplicate and set the category to "db oracle" so that the changelog reflects that it is fixed for both MS SQL and Oracle. The fix will be included in Mantis 1.1 and is available in CVS. |
|
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 |
|