View Issue Details

IDProjectCategoryView StatusLast Update
0019952mantisbtdb mssqlpublic2018-06-29 08:45
ReporterkamleshkAssigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version1.2.12 
Target VersionFixed in Version 
Summary0019952: error when click on Summary Link - APPLICATION ERROR 0000401
Description

We have created new project and created new custome field with enumaration. for. data in this dropdown field are 13JUL2015

but when we click on summary for newly created project, we get below error


APPLICATION ERROR 0000401

Database query failed. Error received from database was 0000245: Conversion failed when converting the varchar value '13July2015' to data type int. 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 project_id=10
GROUP BY b.id, b.status, b.date_submitted, b.last_updated
ORDER BY b.id ASC.

TagsNo tags attached.

Relationships

related to 0024572 new When opening the summary tab APPLICATION ERROR 0000401 is displayed 

Activities

dregad

dregad

2015-08-02 17:54

developer   ~0051179

There are many known issues with MSSQL on mantis 1.2.x - could you please
verify if the same problem exists on the latest 1.3.x version ?

Issue History

Date Modified Username Field Change
2015-07-20 10:19 kamleshk New Issue
2015-08-02 17:54 dregad Note Added: 0051179
2018-06-29 08:45 atrol Relationship added related to 0024572