0013731: When i click on one tag mantis crash on sql

ID	Project	Category	View Status	Date Submitted	Last Update
0013731	mantisbt	db mssql	public	2012-01-06 03:24	2014-05-16 15:00

Reporter	jgreenhalgh	Assigned To	dregad
Priority	normal	Severity	crash	Reproducibility	always
Status	closed	Resolution	no change required
Platform	Sql server 2008	OS	Windows 2008	OS Version	2008 R2
Product Version	1.2.8

Summary	0013731: When i click on one tag mantis crash on sql
Description	Hi I can put one or more tag but i click on one tag i have one crash on sql
Additional Information	Log : APPLICATION ERROR 0000401 Échec de la requête de base de données. L'erreur renvoyée par la base de données était 0007001 : [Microsoft][ODBC SQL Server Driver]Champ COUNT incorrect ou erreur de syntaxe pour la requête : SELECT * FROM mantis_bug_tag_table WHERE tag_id != ? AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b LEFT JOIN mantis_project_user_list_table AS p ON p.project_id=b.project_id AND p.user_id=3 JOIN mantis_user_table AS u ON u.id=3 JOIN mantis_bug_tag_table AS t ON t.bug_id=b.id WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state ) AND t.tag_id=? ) . Merci d'utiliser le bouton « Précédent » de votre navigateur web pour retourner à la page précédente. Vous pourrez y corriger les problèmes identifiés par cette erreur ou choisir une autre action. Vous pouvez aussi choisir une option de la barre de menu pour aller directement dans une nouvelle section. Full path: C:\inetpub\wwwroot\mantis\core\database_api.php Line: 393 Variable Value Type p_query SELECT * FROM mantis_bug_tag_table WHERE tag_id != ? AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b LEFT JOIN mantis_project_user_list_table AS p ON p.project_id=b.project_id AND p.user_id=3 JOIN mantis_user_table AS u ON u.id=3 JOIN mantis_bug_tag_table AS t ON t.bug_id=b.id WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state ) AND t.tag_id=? ) string p_limit -1 integer p_offset -1 integer g_db_log_queries 0 integer g_db_param_count 15 integer s_check_params 1 boolean params 2 integer i 2 integer t_result boolean arr_parms Variable Value Type 0 2 integer 1 2 integer 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 Filename Line Function Args C:\inetpub\wwwroot\mantis\core\database_api.php 393 - - trigger_error ( <string>'401', <integer>256 ) C:\inetpub\wwwroot\mantis\core\tag_api.php 753 - - db_query_bound ( <string>'SELECT * FROM mantis_bug_tag_table WHERE tag_id != ? AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b LEFT JOIN mantis_project_user_list_table AS p ON p.project_id=b.project_id AND p.user_id=3 JOIN mantis_user_table AS u ON u.id=3 JOIN mantis_bug_tag_table AS t ON t.bug_id=b.id WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state ) AND t.tag_id=? ) ', <Array> { [0] => 2, [1] => 2 } ) C:\inetpub\wwwroot\mantis\tag_view_page.php 88 - - tag_stats_related ( <integer>2 )
Tags	No tags attached.

rombert 2012-02-01 17:27 reporter ~0031100	This seems to be a pretty nasty limitation of the ODBC driver. This is worked around in various places in the code, but it is not trivial in this case. The good news is that the 1.2 branch recently received support for the native SQL Server driver. Would it be possible for you to try with the native SQL Server driver and see if that works? The system requirements are documented at http://msdn.microsoft.com/en-us/library/cc296170.aspx .

emireal 2012-02-01 20:32 reporter ~0031101	Robert, I reported the issue 0013834 with the same problem. I am using version 2.0 of the Native driver.

jgreenhalgh 2012-02-02 15:55 reporter ~0031106	ok but i can't install the native client 2.0 because my version is higher ! how install the native driver 2.0. in the report issue 0013834 there are two files attached, i must install this files in my mantis ?

emireal 2012-02-02 16:14 reporter ~0031107	Sorry jgreenhalgh, I was answering Robert's question about installing the native driver. The files I uploaded are the error details. The native driver is a set of Dll's developed by Microsoft to use with PHP, you download the driver from microsoft's page, you decompress it and copy the correct (depending of the installation of PHP you have) dll to the EXT directory of the PHP installation. In this link you have the instruction to install Mantis + IIS7 + SQL and it explains the whole process: http://thegrayzone.co.uk/blog/2011/03/setting-up-mantisbt-on-iis-7-w-sql-server/

jgreenhalgh 2012-02-03 04:13 reporter ~0031110	I have unzip the driver and i have install the driver php_sqlsrv_52_nts_vc6.dll on my php 5.2. But i have same problem .

rombert 2012-02-03 04:34 reporter ~0031111	(In reply to comment 0013731:0031110) I have unzip the driver and i have install the driver php_sqlsrv_52_nts_vc6.dll on my php 5.2. But i have same problem . Just to make sure, did you reinstall using the new SQL driver?

jgreenhalgh 2012-02-13 03:39 reporter ~0031225	hi i have installe the new sql driver with the new php and i have this probleme APPLICATION ERROR 0000401 Merci d'utiliser le bouton « Précédent » de votre navigateur web pour retourner à la page précédente. Vous pourrez y corriger les problèmes identifiés par cette erreur ou choisir une autre action. Vous pouvez aussi choisir une option de la barre de menu pour aller directement dans une nouvelle section. Full path: C:\inetpub\wwwroot\mantis\core\database_api.php Line: 393 Variable Value Type p_query SELECT * FROM mantis_bug_tag_table WHERE tag_id != ? AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b LEFT JOIN mantis_project_user_list_table AS p ON p.project_id=b.project_id AND p.user_id=3 JOIN mantis_user_table AS u ON u.id=3 JOIN mantis_bug_tag_table AS t ON t.bug_id=b.id WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state ) AND t.tag_id=? ) string p_limit -1 integer p_offset -1 integer g_db_log_queries 0 integer g_db_param_count 15 integer s_check_params 1 boolean params 2 integer i 2 integer t_result boolean arr_parms Variable Value Type 0 1 integer 1 1 integer 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 Filename Line Function Args C:\inetpub\wwwroot\mantis\core\database_api.php 393 - - trigger_error ( <string>'401', <integer>256 ) C:\inetpub\wwwroot\mantis\core\tag_api.php 753 - - db_query_bound ( <string>'SELECT * FROM mantis_bug_tag_table WHERE tag_id != ? AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b LEFT JOIN mantis_project_user_list_table AS p ON p.project_id=b.project_id AND p.user_id=3 JOIN mantis_user_table AS u ON u.id=3 JOIN mantis_bug_tag_table AS t ON t.bug_id=b.id WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state ) AND t.tag_id=? ) ', <Array> { [0] => 1, [1] => 1 } ) C:\inetpub\wwwroot\mantis\tag_view_page.php 88 - - tag_stats_related ( <integer>1 )

jgreenhalgh 2012-09-20 09:09 reporter ~0032888	It's resolve with version 1.2.9

dregad 2012-09-20 10:44 developer ~0032890	That's good to hear. Thanks for the feedback !

grangeway 2014-05-16 15:00 reporter ~0040363	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

View Issue Details

Relationships

Activities