View Issue Details

IDProjectCategoryView StatusLast Update
0016127mantisbtdb mssqlpublic2014-05-16 15:00
Reportermelven Assigned Toatrol  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
PlatformwindowsOSwindows server OS Version2008
Product Version1.2.15 
Summary0016127: occurs error when executing edit project
Description

after install mantis 1.2.15 with ms sql server 2008, I can not properly manage my projects, when I execute any one of my created project , I go t the following errors, it's very appreciated if any help, thanks !!

APPLICATION ERROR 0000401

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.

Full path: C:\inetpub\wwwroot\mantis\core\database_api.php
Line: 405
Variable Value Type
p_query SELECT DISTINCT u.id, u.username, u.realname FROM mantis_user_table u LEFT JOIN mantis_project_user_list_table p ON p.user_id=u.id AND p.project_id=? WHERE u.access_level<? AND u.enabled = ? AND p.user_id IS NULL ORDER BY u.realname, u.username string
p_limit -1 integer
p_offset -1 integer
g_db_log_queries boolean
g_db_param_count 19 integer
t_db_type odbc_mssql string
s_check_params 1 boolean
params 3 integer
i 3 integer
t_result boolean

arr_parms
Variable Value Type
0 1 integer
1 90 integer
2 1 boolean

g_queries_array
Variable Value Type
0 1 integer
1 1 integer
2 1 integer
3 1 integer
4 1 integer
5 1 integer
6 1 integer
7 1 integer
8 1 integer
9 1 integer
10 1 integer
11 1 integer
12 1 integer
13 1 integer
14 1 integer
15 1 integer
16 1 integer
17 1 integer
18 1 integer
19 1 integer
20 1 integer

Filename Line Function Args
C:\inetpub\wwwroot\mantis\core\database_api.php 405 - - trigger_error ( <string>'401', <integer>256 )
C:\inetpub\wwwroot\mantis\core\print_api.php 1036 - - db_query_bound ( <string>'SELECT DISTINCT u.id, u.username, u.realname FROM mantis_user_table u LEFT JOIN mantis_project_user_list_table p ON p.user_id=u.id AND p.project_id=? WHERE u.access_level<? AND u.enabled = ? AND p.user_id IS NULL ORDER BY u.realname, u.username', <Array> { [0] => 1, [1] => 90, [2] => true } )
C:\inetpub\wwwroot\mantis\manage_proj_edit_page.php 684 - - print_project_user_list_option_list ( <integer>1 )

Steps To Reproduce

step1 : login
step2 : click manage projects
step3 : choose one of the project to edit
step4 : error occurs

TagsNo tags attached.

Relationships

duplicate of 0013906 closeddregad Application error on manage_proj_edit_page.php 

Activities

melven

melven

2013-07-02 22:29

reporter   ~0037364

sorry, I'm the newer of this forum, I tracked to duplicated issue "0013906", but haven't found the answer, if anything I missed ? thank you very much !!

atrol

atrol

2013-07-03 02:36

developer   ~0037365

We are closing duplicate issues to have all communication at one place.
See [1] for our triaging process.

Your issue is a MS SQL issue.
There are various known issues using MantisBT with MS SQL.

I can't help you as I dont' use this database.
I hope other developers / users will provide support.

I recommend to have a look at all open issues with category "db mssql".
There you will find valuable information about the right database driver to use, patches, ....

[1] http://www.mantisbt.org/wiki/doku.php/mantisbt:support_corner

melven

melven

2013-07-03 05:39

reporter   ~0037367

okie, thanks for your guidance.

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040343

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul