View Issue Details

IDProjectCategoryView StatusLast Update
0014352mantisbtdb mssqlpublic2014-05-16 15:00
ReporterYusulf Assigned Toatrol  
PriorityhighSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
PlatformWindowsOSWindows Server OS Version2008 R2
Product Version1.2.10 
Summary0014352: Summary Error 401
Description

Hello community,i upgrade mantis from 1.0.8 to 1.2.10 but have a problem with summary option. I try open summary tab but alway recibe error 401

Database query failed. Error received from database was #0: [Microsoft][ODBC SQL Server Driver]Invalid parameter number for the query: SELECT b.id, b.date_submitted, b.last_updated, MAX(h.date_modified) as hist_update, b.status
FROM mantis_bug_table b LEFT JOIN mantis_bug_history_table h
ON b.id = h.bug_id AND h.type=0 AND h.field_name='status' AND h.new_value=?
WHERE b.status >=? AND 1<>1
GROUP BY b.id, b.status, b.date_submitted, b.last_updated
ORDER BY b.id ASC.

My System is Windows Server 2008 R2 , SQL Server 2008 R2 , ODBC Drivers 3.51 and 5.1

Steps To Reproduce

Login To Mantis
Open Summary Tab

TagsNo tags attached.

Relationships

duplicate of 0013905 closeddregad Application Error 0000401 on summary_page.php 

Activities

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040368

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