View Issue Details

IDProjectCategoryView StatusLast Update
0009254mantisbtdb mssqlpublic2023-05-04 16:23
Reporteraugur Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
PlatformIIS PHPOSWindows XPOS VersionSP2
Product Version1.1.1 
Summary0009254: Project_get_field in file_api gets wrong result
Description

project_get_field( $t_project_id, 'file_path' );

Line 642 in file_api.php give a wrong result.
In the SQL Server is a NULL value be stored, but the function return a string with one blank. So the absolute_path_default_upload_folder will not be taken.

If an individual file path is set for a project, all works fine.

Best regards

Steps To Reproduce

Set no individual download path and it can be reproduced every time in my enviroment.

TagsNo tags attached.

Activities

grangeway

grangeway

2014-02-17 13:26

reporter   ~0039449

Marking as Suspended

MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release.

I'd strongly advise using MYSQL for now.

The new DB layer already contains the appropriate fixes for MS SQL Support.

grangeway

grangeway

2014-03-27 19:12

reporter   ~0039752

MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release.

I'd strongly advise using MYSQL for now.

The new DB layer already contains the appropriate fixes for MS SQL Support.

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040331

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

dregad

dregad

2023-04-22 10:50

developer   ~0067692

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

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.

[1] http://www.mantisbt.org/download.php