View Issue Details

IDProjectCategoryView StatusLast Update
0019952mantisbtdb mssqlpublic2020-02-17 14:56
Reporterkamleshk Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionunable to reproduce 
Product Version1.2.12 
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 closeddregad 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 ?

dregad

dregad

2020-02-03 03:43

developer   ~0063561

kamleshk,

You never provided any feedback; as this issue was reported against a very old version of Mantis which is no longer supported, I am therefore resolving this issue as "no change required".

Feel free to reopen the issue at a later time, if the problem can be reproduced on the latest 2.x release.