View Issue Details

IDProjectCategoryView StatusLast Update
0020946mantisbtdb mssqlpublic2016-05-24 09:27
ReporterShushine Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
OSWindows serverOS Version2008 
Product Version1.2.19 
Summary0020946: Error 401
Description

Hello,
My Mantis is installed on Windows Server 2008 with SQL SERVER 2008
The installation was successful tables are created
When I click on synthesis
I encounter the following error message:
Database query failed . Error received from database Was # 0 : 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 pm
ON = b.id h.bug_id AND h.type = 0 AND h.field_name = 'status' AND h.new_value =
WHERE b.status > = ? AND project_id = 1
GROUP BY b.id , b.status , b.date_submitted , b.last_updated
ORDER BY ASC b.id .

thank you in advance for your help
cordially

TagsNo tags attached.

Activities

dregad

dregad

2016-05-24 09:27

developer   ~0053214

There are known issues and limitations with use of sql server on Mantis 1.2.x.

Not having access to this platform I am not able to help you in details. However, I encourage you to download and install 1.3.0rc1 which has much better support for this DB platform.

You might also want to search for related issues on this tracker, someone may have posted additional information.