View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0022634mantisbtdb mssqlpublic2017-03-31 14:002017-04-30 14:48
Reporterdharmangp25 Assigned Todregad  
PriorityhighSeveritymajorReproducibilityunable to reproduce
Status closedResolutionno change required 
Product Version2.2.2 
Summary0022634: Application Error 0000401 on page my_view_page.php
Description

I am trying to use mantis on windows server with mssql database. It was really hard to install it but I managed to install it. Most of the stuffs works great but when I login as a reporter, I cannot see anything on my_view_page.php. I can just see title. When I login as an administrator, I can see a SQL error which I am pasting below

Database query failed. Error received from database was #0: for the query: SELECT * FROM mantis_bug_history_table WHERE mantis_bug_history_table.bug_id IN ( SELECT mantis_bug_table.id FROM mantis_bug_table JOIN mantis_project_table ON mantis_project_table.id = mantis_bug_table.project_id WHERE mantis_project_table.enabled = ? AND ( mantis_bug_table.project_id = 1 ) ) AND date_modified >= ? AND date_modified < ? ORDER BY mantis_bug_history_table.date_modified DESC, mantis_bug_history_table.id DESC.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Our main project is up and running and we want this to be working great as soon as possible. I will really appreciate any help.

Thanks

TagsNo tags attached.

Activities

dregad

dregad

2017-03-31 15:39

developer   ~0056301

First of all, please note that none of the team members have access to MSSQL, so helping you will likely be difficult.

It was really hard to install it but I managed to install it

What gave you trouble, and what did you do to make it work ?

What happens when you run this query manually against your DB ?

Do you have any data in the history table ?

To get a better understanding of what is happening, you may want to set $g_log_level = LOG_DATABASE; and get debugging information about the error. Please follow these steps:

  1. temporarily configure your system as follows: 
    $g_display_errors = array(
E_WARNING => 'halt',
E_NOTICE => 'halt',
E_USER_ERROR => 'halt',
E_USER_WARNING => 'halt',
E_USER_NOTICE => 'halt'
);
$g_show_detailed_errors = ON;

WARNING - SECURITY RISK: the 'show_detailed_errors' config can cause MantisBT to display sensitive information about your system. We recommend to restrict its activation to a Test environment, only for as long as necessary. If possible, do not turn it ON globally, instead limit it for specific user(s) using the Manage Configuration page.

  1. Reproduce the error

If the output does not help you resolving the issue and you need further assistance,

  1. save the output of the error screen, preferably as an HTML page (not a screenshot !)
  2. be careful to remove/mask any confidential information if needed
  3. upload the results here
dregad

dregad

2017-03-31 16:06

developer   ~0056302

It may not be related to the error you're getting, but since you mentioned issues with installation, maybe you should to take a look at 0022063 - @obmsch's patch, which i merged a few minutes ago, resolves a blocking issue with the installer on MSSQL.
cproensa

cproensa

2017-04-03 14:55

developer   ~0056357

I have tested a mssql install and can't reproduce this error, with v2.2.2. or current master

with DB version:
Microsoft SQL Server vNext (CTP1.4) - 14.0.405.198 (X64)
Mar 11 2017 01:54:12
Copyright (C) 2016 Microsoft Corporation. All rights reserved.
on Linux (Ubuntu 16.04.1 LTS)
atrol

atrol

2017-04-23 10:58

developer   ~0056656

dharmangp25,

You did not provide any feedback; I am therefore resolving this issue as "no change required".

Feel free to reopen the issue at a later time and provide the requested information.