View Issue Details

IDProjectCategoryView StatusLast Update
0024572mantisbtdb mssqlpublic2018-07-12 08:53
ReporterghirschyAssigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Product Version2.14.0 
Target VersionFixed in Version 
Summary0024572: When opening the summary tab APPLICATION ERROR 0000401 is displayed
Description

We use MSSQL and the summary page could not be displayed.
We have used Mantis for 2 months now. In the past the summary was correctly displayed.

Steps To Reproduce

Open Summary tab

TagsNo tags attached.

Relationships

related to 0019952 new error when click on Summary Link - APPLICATION ERROR 0000401 

Activities

dregad

dregad

2018-06-28 18:52

developer   ~0060191

In the past the summary was correctly displayed.

So the question is, what has changed between "the past" and now (upgrades, etc) ?

Please provide further details, including the offending SQL query.

ghirschy

ghirschy

2018-06-29 08:20

reporter   ~0060195

This is a new installation of Mantis, we didn't upgrade.
After the installation and for some time the Summary page was displayed correctly.

Where should I found de offending SQL query.
I'm attaching an image of what I see.

Thanks



Mantis.PNG (16,171 bytes)
Mantis.PNG (16,171 bytes)
dregad

dregad

2018-06-29 08:46

developer   ~0060196

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
ghirschy

ghirschy

2018-06-29 09:03

reporter   ~0060197

Thanks

Here is the page



Resumen - MantisBT.htm (12,728 bytes)
dregad

dregad

2018-06-29 10:02

developer   ~0060198

I can't reproduce this on my dev box, but I'm on MySQL. I don't know if it's caused by a data problem or something specific to MSSQL. I don't have access to an sql server environment so I'm afraid there is not much I can do to help. Did you try to manually execute the offending query ?

Also, you have not fully answered my earlier question: what has changed between "the past" and now (upgrades, etc) ? It could be a change in system configuration, database settings...

dregad

dregad

2018-06-29 10:09

developer   ~0060199

@cproensa as a side note, I'm surprised that the 401 error is not printing the offending SQL or even the actual Database query failed. Error received from database was #%1$d: %2$s for the query: %3$s. message - any idea why ?

ghirschy

ghirschy

2018-06-29 11:10

reporter   ~0060200

Also, you have not fully answered my earlier question: what has changed between "the past" and now (upgrades, etc) ? It could be a change in system configuration, database settings...
Nothing was changed, we only used more.

As I see on your previus note you expect to see the final sql query. Is this correct? I Would like to see the final query already "translated" to MSSQL

ghirschy

ghirschy

2018-06-29 11:29

reporter   ~0060201

I found a similar issue created: 0019952: error when click on Summary Link - APPLICATION ERROR 0000401

ghirschy

ghirschy

2018-07-12 08:53

reporter   ~0060254

Hi, any news about it. Can I see the offending query?

Issue History

Date Modified Username Field Change
2018-06-28 08:57 ghirschy New Issue
2018-06-28 18:52 dregad Status new => feedback
2018-06-28 18:52 dregad Note Added: 0060191
2018-06-29 08:20 ghirschy File Added: Mantis.PNG
2018-06-29 08:20 ghirschy Note Added: 0060195
2018-06-29 08:20 ghirschy Status feedback => new
2018-06-29 08:45 atrol Relationship added related to 0019952
2018-06-29 08:46 dregad Note Added: 0060196
2018-06-29 08:46 dregad Status new => feedback
2018-06-29 09:03 ghirschy File Added: Resumen - MantisBT.htm
2018-06-29 09:03 ghirschy Note Added: 0060197
2018-06-29 09:03 ghirschy Status feedback => new
2018-06-29 10:02 dregad Status new => feedback
2018-06-29 10:02 dregad Note Added: 0060198
2018-06-29 10:09 dregad Note Added: 0060199
2018-06-29 11:10 ghirschy Note Added: 0060200
2018-06-29 11:10 ghirschy Status feedback => new
2018-06-29 11:29 ghirschy Note Added: 0060201
2018-07-12 08:53 ghirschy Note Added: 0060254