MantisBT

View Issue Details Jump to Notes ] Wiki ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0013363mantisbtdb mssqlpublic2011-09-30 12:192013-04-06 09:24
Reporterrfoster 
Assigned Torombert 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformWindows IIS ServerOSWindows ServerOS Version2008
Product Version1.2.8 
Target Version1.2.9Fixed in Version1.2.9 
Summary0013363: Application Failure when trying to select an issue
DescriptionWith a new installation using SQL Server 2008 with the new Microsoft sqlsrv database plugin (patches from new issues applied)

When selecting created issues I get this error when there are no Tags created through the Management interface:

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0000102: SQLState: 42000
Error Code: 102
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.
for the query: SELECT id, name, description FROM mantis_tag_table WHERE id IN ( ) ORDER BY name ASC .
 
Steps To Reproduce1. Create a project
2. DON'T create any tags
3. Create an issue
4. try to select any issue by it's ID
  - APPLICATION ERROR 0000401 occurs
5. Create a tag, labelled "tesT"
6. try to select any issue by it's ID
  - issue loaded correctly
Tags2.0.x check
Attached Filespatch file icon Correct-tag-retrieval-on-SQL-Server-when-no-tags-are.patch [^] (847 bytes) 2011-09-30 14:04 [Show Content]

- Relationships
related to 0015721new Functionality to consider porting to master-2.0.x 

-  Notes
User avatar (0029904)
rombert (developer)
2011-09-30 14:04

Please apply the following patch and let me know if it fixed the issue. I do not have an SQL Server instance around to test.
User avatar (0029958)
jyperion (reporter)
2011-10-14 06:34

thats works (MS SQL Server2005) and I add another patch in the case , you add Tags
User avatar (0036324)
grangeway (developer)
2013-04-05 17:57

Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch

- Related Changesets
MantisBT: master 47a2de44
Timestamp: 2011-09-30 11:02:52
Author: rombert
Details ] Diff ]
Correct tag retrieval on SQL Server when no tags are defined

Fix 0013363 : Application Failure when trying to select an issue
mod - core/tag_api.php Diff ] File ]
MantisBT: master-1.2.x 59b1fff9
Timestamp: 2011-09-30 11:02:52
Author: rombert
Details ] Diff ]
Correct tag retrieval on SQL Server when no tags are defined

Fix 0013363 : Application Failure when trying to select an issue
mod - core/tag_api.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2011-09-30 12:19 rfoster New Issue
2011-09-30 14:01 rombert Description Updated View Revisions
2011-09-30 14:01 rombert Steps to Reproduce Updated View Revisions
2011-09-30 14:01 rombert Assigned To => rombert
2011-09-30 14:01 rombert Priority normal => high
2011-09-30 14:01 rombert Status new => assigned
2011-09-30 14:01 rombert Target Version => 1.2.9
2011-09-30 14:01 rombert Category bugtracker => db mssql
2011-09-30 14:04 rombert File Added: Correct-tag-retrieval-on-SQL-Server-when-no-tags-are.patch
2011-09-30 14:04 rombert Note Added: 0029904
2011-10-05 18:50 rombert Changeset attached => MantisBT master 47a2de44
2011-10-05 18:50 rombert Status assigned => resolved
2011-10-05 18:50 rombert Resolution open => fixed
2011-10-05 18:50 rombert Fixed in Version => 1.3.x
2011-10-05 18:50 rombert Changeset attached => MantisBT master-1.2.x 59b1fff9
2011-10-14 06:34 jyperion Note Added: 0029958
2011-10-24 04:30 dregad Fixed in Version 1.3.x => 1.2.9
2011-10-24 04:30 dregad Description Updated View Revisions
2011-10-24 04:30 dregad Steps to Reproduce Updated View Revisions
2012-03-03 21:45 vboctor Status resolved => closed
2013-04-05 17:57 grangeway Status closed => acknowledged
2013-04-05 17:57 grangeway Note Added: 0036324
2013-04-05 18:23 grangeway Relationship added related to 0015721
2013-04-06 03:42 dregad Status acknowledged => closed
2013-04-06 07:23 grangeway Status closed => acknowledged
2013-04-06 09:24 dregad Tag Attached: 2.0.x check
2013-04-06 09:24 dregad Status acknowledged => closed


MantisBT 1.2.16dev master-1.2.x-8c2bd07 [^]
Copyright © 2000 - 2013 MantisBT Team
Time: 0.0927 seconds.
memory usage: 2,847 KB
Powered by Mantis Bugtracker