| Anonymous | Login | Signup for a new account | 2013-05-18 17:54 EDT | ![]() |
| Main | My View | View Issues | Change Log | Roadmap | Wiki | ManTweet | Repositories |
| View Issue Details [ Jump to Notes ] [ Wiki ] [ Related Changesets ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
| 0013363 | mantisbt | db mssql | public | 2011-09-30 12:19 | 2013-04-06 09:24 | ||||
| Reporter | rfoster | ||||||||
| Assigned To | rombert | ||||||||
| Priority | high | Severity | major | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Platform | Windows IIS Server | OS | Windows Server | OS Version | 2008 | ||||
| Product Version | 1.2.8 | ||||||||
| Target Version | 1.2.9 | Fixed in Version | 1.2.9 | ||||||
| Summary | 0013363: Application Failure when trying to select an issue | ||||||||
| Description | With 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 Reproduce | 1. 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 | ||||||||
| Tags | 2.0.x check | ||||||||
| Attached Files | |||||||||
Relationships |
||||||
|
||||||
Notes |
|
|
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. |
|
jyperion (reporter) 2011-10-14 06:34 |
thats works (MS SQL Server2005) and I add another patch in the case , you add Tags |
|
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 |