Problems with MantisGraph Plugin

[karl.reichert]

Hello,

the MantisGraph Plugin is really great, I like it a lot! But for some of my projects, not all graphs can be generated on "advanced summary" page. For others, all graphs are created. Anyone knows, if there is a log file or sth where I can check what might be the problem? Or does anyone has an idea what could be the reason for that behavoir?

I'm using Mantis 1.2.0 with the shipped MantisGraph Plugin (version 1.0)

Thanks!
Karl

[atrol]

not all graphs can be generated on "advanced summary" page.

Which can be generated, which not?
What does can not be generated mean? Nothing is shown?

I'm using Mantis 1.2.0 with the shipped MantisGraph Plugin (version 1.0)

Update to 1.2.1 is recommend

where I can check what might be the problem?

You could check the source code view of your browser and also the log files of your webserver
You could enable database tracing of MantisBT

[karl.reichert]

not all graphs can be generated on "advanced summary" page.

Which can be generated, which not?
What does can not be generated mean? Nothing is shown?

Firefox is showning a red X, which means, image not found, as far as I know. Please see the screenshot at http://karl-reichert.com/screenshots/Ma ... enshot.png

I'm using Mantis 1.2.0 with the shipped MantisGraph Plugin (version 1.0)

Update to 1.2.1 is recommend

I did the update to 1.2.1, the problem did not go away.

where I can check what might be the problem?

You could check the source code view of your browser and also the log files of your webserver
You could enable database tracing of MantisBT

I check the source code, found nothing wrong. Here is the important part of it:

Code: Select all

<table class="width100" cellspacing="1">
<tr>
	<td class="form-title" colspan="2">
		Zusammenfassung	</td>
</tr>
<tr valign="top">
<td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_cumulative_bydate.php&width=375" border="0" alt="" /></td><td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_bydeveloper.php&width=375" border="0" alt="" /></td></tr>
<tr valign="top">
<td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_byreporter.php&width=375" border="0" alt="" /></td><td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_byseverity.php&width=375" border="0" alt="" /></td></tr>
<tr valign="top">
<td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_bystatus.php&width=375" border="0" alt="" /></td><td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_byresolution.php&width=375" border="0" alt="" /></td></tr>
<tr valign="top">
<td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_bycategory.php&width=375" border="0" alt="" /></td><td width="50%" align="center"><img src="/Mantis/plugin.php?page=MantisGraph/summary_graph_bypriority.php&width=375" border="0" alt="" /></td></tr>
</table>

In the log files on the server, I also found nothing.
Can you please tell me how to enable that database tracing of MantisBT?

[atrol]

Can you please tell me how to enable that database tracing of MantisBT?

Add the following lines to your config_inc.php, after that log in as an administrator to see the trace

Code: Select all

$g_show_queries_count = ON;
$g_show_queries_list = ON;

[karl.reichert]

This is what I get:

Code: Select all

17 Abfragen ausgeführt (gesamt).
16 einzelne Abfragen ausgeführt. 1 0.0002 database_api.php:105 db_connect()
SET NAMES UTF8 
2 0.0004 plugin_api.php:771 plugin_register_installed()
SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC 
3 0.0009 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table 
4 0.0006 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='1abc73eb97b80427dcab22658d100d86b124a312ed5f931cf67b42ac81782785' 
5 0.0004 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=2 AND project_id=0 
6 0.0003 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1275567528 > expiry 
7 0.0004 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 
8 0.0003 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=2 
9 0.0003 tokens_api.php:43 token_exists()
SELECT id FROM mantis_tokens_table WHERE id=1620 
10 0.0003 tokens_api.php:224 token_update()
UPDATE mantis_tokens_table SET value='a:5:{s:6:"filter";b:1;s:7:"profile";b:0;s:10:"monitoring";b:0;s:11:"upload_form";b:0;s:13:"relationships";b:0;}', expiry=1307103528 WHERE id=1620 
11 0.0006 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name 
12 0.0004 project_api.php:123 project_cache_array_rows()
SELECT * FROM mantis_project_table WHERE id IN (10,4,19,6,5,23,22) 
13 0.0005 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name 
14 0.0003 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=20 
15 0.0003 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=24 
16 0.0003 tokens_api.php:156 token_delete()
DELETE FROM mantis_tokens_table WHERE type=2 AND owner=2 
17 0.0003 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1275567528 WHERE id=2 
 0.0068 SQL Queries Total Time 
 0.3075 Page Request Total Time 

I don't have a clue if this helps tracking the problem. Can you give me a hint?

[atrol]

Seems that you have a heavily customized system.
You could check whether the behaviour changes
a) with English settings instead of German (there exist some language related problems in MantisBT ATM)
b) in a dummy installtion without customizations

[karl.reichert]

Seems that you have a heavily customized system.
You could check whether the behaviour changes
a) with English settings instead of German (there exist some language related problems in MantisBT ATM)

If I set the language to English, it gets even worse, because no graphs are generated at all.

b) in a dummy installtion without customizations

This works, but I need the customizations of states and users for my projects.

Do you know if there are any open bugs regarding customization and graph plugin? If not, I would create one, because this is a major bug to my mind. At the moment, in my company, all graphs are created by Excel, which means counting the bugs in Mantis and pasting them into Excel, which is not really nice. I would like to etablish Mantis and all its features in my company, which means I need a working graph plugin, no matter which customizations and language settings are made.

[atrol]

If I set the language to English, it gets even worse, because no graphs are generated at all.

Is this gone after you resolved this one http://www.mantisbt.org/forums/viewtopi ... =3&t=10757

Do you know if there are any open bugs regarding customization and graph plugin?

Seems that moving the graph functionality of 1.1 to a plugin in 1.2 in combination with changing default graph library from JpGraph to eZcomponents introduced new issues. Get your own impression by setting a filter to category graph at MantisBT tracker. The developer of the plugin seems not to have the time at the moment to fix this.

You could try, whether using JpGraph fixes some problems, at least I got better looking results after changig this.
Just download the lastest version from http://sourceforge.net/projects/jpgraph ... 2/download and copy the contents of directory src to <yourMantis>/library/jpgraph (or change the directory in settings of the plugin)