MantisBT - Issues

0015881: Citrix Farm FR2 HS

Sun, 19 May 2013 09:19:48 -0400

test

0015880: Am Failing to Login After Installation

Sun, 19 May 2013 03:27:22 -0400

APPLICATION ERROR 0000401
Database query failed. Error received from database was #22005: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification for the query: DELETE FROM mantis_tokens_table WHERE ? > expiry.

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.

0015795: Renew code signing certificate

Sat, 18 May 2013 09:39:42 -0400

Received an email:

We kindly inform that Standard Code Signing certificate with serial number: ... issued for Robert Munteanu - Open Source Developerwill expire in 30 days, on 2013-05-25 06:05:38 (GMT).

0015870: Deserialization issues caused by mc_config_get_string()

Sat, 18 May 2013 09:19:20 -0400

This issue was reported in 0015835

Some configuration options like handle_bug_threshold can be set to an integer (e.g. 55 for developer) or array (e.g. array(55, 70)). When it is set to an array, it is serialized fine, but the client fails deserializing the array as a string.

Two issues to resolve here:
- Fix the serialization / deserialization issues.
- Come up for an easy way for SOAP clients to get a value that is easy to process without much hassle around parsing.

0015864: Synchronization fails if no issue with ID 1 exists (No reproducibility with id 1)

Fri, 17 May 2013 15:20:42 -0400

com.itsolut.mantis.core.exception.MantisException: No reproducibility with id 1 .
at com.itsolut.mantis.core.MantisCache.getReproducibility(MantisCache.java:289)
at com.itsolut.mantis.core.MantisCache.getDefaultReproducibility(MantisCache.java:539)
at com.itsolut.mantis.core.MantisTaskDataHandler.createDefaultAttributes(MantisTaskDataHandler.java:558)
at com.itsolut.mantis.core.MantisTaskDataHandler.createTaskDataFromTicket(MantisTaskDataHandler.java:763)
at com.itsolut.mantis.core.MantisTaskDataHandler.getTaskData(MantisTaskDataHandler.java:269)
at com.itsolut.mantis.core.MantisRepositoryConnector.getTaskData(MantisRepositoryConnector.java:286)
at org.eclipse.mylyn.internal.tasks.core.sync.SynchronizeTasksJob.synchronizeTask(SynchronizeTasksJob.java:245)
at org.eclipse.mylyn.internal.tasks.core.sync.SynchronizeTasksJob.runInternal(SynchronizeTasksJob.java:218)
at org.eclipse.mylyn.internal.tasks.core.sync.SynchronizeTasksJob.run(SynchronizeTasksJob.java:153)
at org.eclipse.mylyn.internal.tasks.core.sync.SynchronizeTasksJob.run(SynchronizeTasksJob.java:129)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

0015869: API call mc_login with valid LDAP user which is not in mantis DB -> result: login failed

Fri, 17 May 2013 15:20:15 -0400

We use mantistouch and LDAP auth.
And we have a problem with the new users because they can't login until they aren't login to the mantis "normal" version.

We made a patch for it in the core/authentication_api.php:

function auth_attempt_script_login( $p_username, $p_password = null ) {
global $g_script_login_cookie, $g_cache_current_user_id;
$t_user_id = user_get_id_by_name( $p_username );
//patch start
//create users if not exists in the mantis DB but exits in the LDAP
if ( false === $t_user_id ) {
$t_login_method = config_get( 'login_method' );
if ( LDAP == $t_login_method && ldap_authenticate_by_username( $p_username, $p_password ) ) {
$t_auto_create = true;
}
if ( $t_auto_create ) {
$t_cookie_string = user_create( $p_username, md5( $p_password ) );
if ( false === $t_cookie_string )
return false;
$t_user_id = user_get_id_by_name( $p_username );
if( false === $t_user_id ) {
return false;
}
} else {
return false;
}
}
// if( false === $t_user_id ) {
// return false;
// }
//patch end
$t_user = user_get_row( $t_user_id );
...

0015835: handle_bug_threshold is a serialized array - issue_edit_page.php not working

Fri, 17 May 2013 09:21:29 -0400

if the handle_bug_threshold is a serialized array:
example: a:2:{i:0;i:55;i:1;i:70;}
/Disable administrators bug handling rights/
then the issue edit page not working:

Handler: 8: Undefined index: users_result
File: *****/public_html/views/issue_edit.phtml
Line: 46
2: Invalid argument supplied for foreach()
File: ****/public_html/core/html_api.php
Line: 20

and in the page source I see one more error:
Error Type: SYSTEM NOTICE,
Error Description: Array to string conversion

If i patch it in the issue_edit_page.php by hand like this:
$handle_bug_threshold=array(55,70);
then no error messages but in the select box i see all users...

0015879: html_get_list_project_users function upgrade - show real names

Fri, 17 May 2013 08:32:41 -0400

We need a func upgrade to show real names in the Handler list.
I attach our new function to this ticket.

0015878: handler list on issue_edit_page.php page, ignore handle_bug_threshold value if it's an array

Fri, 17 May 2013 06:24:05 -0400

so example:
$handle_bug_threshold = array (40,55,70);
in this case the user list will be false.

our patch is in the wsdl, we changed the access type to array from integer:

NEW value:

0006447: The filter table columns shouldn't be used to divide the "Search/Filters" row at the bottom of the table.

Fri, 17 May 2013 05:45:15 -0400

If you create filters with long names, then the "Severity", "Resolution" and "Profile" columns get very wide, while the "Reporter", "Modified By", "Assigned To" and "Category" columns get squished. This is because the bottom row in the "Filters" table (with the white background) is divided based on the columns above (using colspan), rather than being its own nested table.

Having that last row be a full-width nested table would allow it to allocate its screen width for best appearance, while the filter entries above could separately allocate their width for their best appearance.

0015865: Showing attachments missing for report and developer

Fri, 17 May 2013 03:38:10 -0400

Hi,

I did transfer the attachments from database to Disk and its showing all
previous entries also. anyway fine

New problem is when administrator user is uploading any bug file its uploading
and showing in view issues page. But its showing as attachments missing for
reporter and developer when they are uploading bug file.

I have attached one screen shot.

Please help

Durga

0015868: Filename length is not checked

Thu, 16 May 2013 14:06:35 -0400

It appears possible to upload a file with a length longer as defined in the DB.
Definition is 83 positions but one can load a file with a longer name.
This leads to truncation of the file which on it's turn can lead to poor responce of the mantis system due to missing extension.

0011084: Login Dialog keeps popping up when using HTTP_AUTH

Thu, 16 May 2013 07:55:01 -0400

Using HTTP_AUTH to enable users to login with their System-Password doesn't work. The function auth_does_password_match doesn't handle HTTP_AUTH and therefor one cannot log in. Instead the Login Dialog keeps popping up.

0015863: Format xlsx. tidak bisa dibuka di excel 2003

Thu, 16 May 2013 03:05:52 -0400

Setiap kali saya memiliki file excel dengan format xlsx. saya tidak bisa membukanya dengan microsoft excel 2003.

0015496: Script to move attachments from db to disk not working

Wed, 15 May 2013 11:51:04 -0400

According to your advice I tried to transfer attachments from database to disk and have problem. See screenshort.

It is necessary to tell that the base initially was 1.2.1 and now 1.2.14

And one more big problem. Files aren't moved in the DISK to special folder for attachments. They copied to root mantis folder. Thus the new attachments saving to special folder for attachaments.

0012830: new HTMLMail plugin v0.1

Wed, 15 May 2013 10:10:36 -0400

I'm working on a new HTMLMail plugin. The plugin is able to replace the content of the normal Mantis mail.
This plugin is developed for mantis 1.2.4.

0015801: DATABASE SIZE INCREASE DRAMATICALLY

Wed, 15 May 2013 09:29:29 -0400

i am using mantis for last four year and recently i have upgraded to the latest release 1.2.12.

My mantis is hosted on a third party domain freehostia where i have to purchase database size. currenlty i have purchased 220mb of database size where as my actual databasee size is 196mb. there is one table named mantis_bug_file_table, the size of this table is around 180mb.

when i attach a file to any bug report db size increases from 196 mb to 319mb. this increase in size in not understandable. can you please help that why mantis is behaving like this for past three months.

0015811: Update SQL Queries instead of Writing to the Database

Wed, 15 May 2013 09:28:30 -0400

The SQL Queries is wrong, fields are missing and timezone are set incorrectly.

0012458: Problem with HTTP_AUTH and Web Services

Tue, 14 May 2013 16:52:40 -0400

My MantisBT site is authenticated by Apache using mod_auth_kerb over HTTPS with both SPNEGO and BASIC_AUTH enabled.

I have applied the patch described at http://www.eiben.weite-welt.com/2007/04/mantis_iwa/ [^] to enable SPNEGO authentication.

function mci_check_login() is used for every web services method to check authentication, but it expects username and password being provided for each call, which is not the case for authentication managed by Apache.

I have patched the mci_api.php file this way to make it work:

# return user_id if successful, otherwise false.
function mci_check_login( $p_username, $p_password ) {

# Alberto Zigoni: patch for auth_attempt_script_login to work
$t_login_method = config_get( 'login_method' );
if(HTTP_AUTH == $t_login_method) {
$p_username = auth_prepare_username('');
}
if( mci_is_mantis_offline() ) {
return false;
}

# if no user name supplied, then attempt to login as anonymous user.
if( is_blank( $p_username )) {
$t_anon_allowed = config_get( 'allow_anonymous_login' );
if( OFF == $t_anon_allowed ) {
return false;
}

$p_username = config_get( 'anonymous_account' );

# do not use password validation.
$p_password = null;
}

if( false === auth_attempt_script_login( $p_username, $p_password ) ) {
return false;
}

return auth_get_current_user_id();
}

authentication.api is patched as follows (sso_user_regex is a regex used to strip the '@DOMAIN' suffix from the username in HTTP header):

function auth_prepare_username( $p_username ) {
switch( config_get( 'login_method' ) ) {
case BASIC_AUTH:
$f_username = $_SERVER['REMOTE_USER'];
break;
case HTTP_AUTH:
if( !auth_http_is_logout_pending() ) {
if (isset($_SERVER['REMOTE_USER'])) { # $_SERVER['AUTH_TYPE'] == 'Negotiate' )
preg_match(config_get('sso_user_regex'), $_SERVER['REMOTE_USER'], $user_match);
$f_username = $user_match[1];
}
if( isset( $_SERVER['PHP_AUTH_USER'] ) ) {
$f_username = $_SERVER['PHP_AUTH_USER'];
}
} else {
auth_http_set_logout_pending( false );
auth_http_prompt();

/* calls exit */
return;
}
break;
default:
$f_username = $p_username;
break;
}
return $f_username;
}

0015860: How to create advance report page?

Tue, 14 May 2013 06:26:08 -0400

I would like to know why is advance report page is no more available, i have seen that there was just "include bug_report.php" in advance_report_page.php, is there any way already set to activate that page or do i have create link and functions by my self.?

Indeed i'm moving from mantis 1.0.0 to 1.2.14 and i would like to have some fields hidden like on simple report and visible on advance report of version 1.0.0.

0015838: new check.php does not check for obsolete config variables

Mon, 13 May 2013 12:00:45 -0400

new check.php does not check for obsolete config variables

0015762: email_regex_simple() case sensitive, leading to incorrect e-mail links

Mon, 13 May 2013 11:43:59 -0400

Since 1.2.12 email_regex_simple() is case sensitive, introduced by 0014453. This leads to incorrect e-mail links.

0009876: Performance problem with a lot of projects

Mon, 13 May 2013 11:39:57 -0400

GOOD NEWS FIRST:

Amazeing.. I am running a test which has about 2000 projects and organized into 8 SUBFOLDERS.. Performance time dropped from about 2 seconds load time to 30 seconds when I put all the projects into subfolders.. I actually expected an improvment and NOT a loss. After that, nothing in this forum helped improve. However, get this. I changed the mantis_project_hierarchy_table type from myISAM to innoDB in phpmyadmin just for shits and gigles after optimize did nothing.. Performance is down to about 3 seconds now. Bet I can make better if I optimize my.ini for innoDB. Warning. No idea what effect this will have in database. Use with causion.

BAD NEWS AND NEED OF MAJOR CHANGE IN MANTIS

Mantis is not very scalable to lots of projects.. needs major improvement.

1. Needs to break down projects alphabetically like user managemnt does. This is obvious. However, read on.
2. The logic that creats subprojects needs to be seriously reviewed and modified. Take a look:

If I drop supprojects and empty project hierarchy table all togther on my 2000 project build, page load time goes down to about 1.20 seconds from about 2.5 to 3 with innoDB enabled in mantis_project_hierarchy_table (NOT myISAM) .. However, with only 200 projects, I was getting .2 seconds which is MUCH FASTER using the stock myISAM setting... So ON MY SETUP - 6% longer load time for every 200 projects if you DONT use subprojects. If you do use subprojects. 12% longer for every 200 projects IF AND ONLY IF you convert hierarchy table to innoDB from myISAM... IF YOU DO NOT CONVERT TO INNODB, forget it. GOes up to like 90% longer for ever 200 projects and TAKES 30 SECONDS!! to load news page and a whopping 180 seconds to load project manager.

Is this becuase the subprojects draw array is somehow different than just projects? I dont understand. I was thinking subprojects would actually reduce load time.

0012885: Reimplement obsolete configuration checks based on obsolete.php as part of new admin/check/ interface

Mon, 13 May 2013 11:22:48 -0400

The rewritten check.php script (as a collection of checks in the admin/check/ directory) neglected to port across obsolete configuration checking from 1.2.x.

Configuration within the database (and perhaps also as defined in global PHP variables) needs to be validated against obsolete.php to notify the user if they're trying to use deprecated configuration options.

0010153: Reminder plugin

Mon, 13 May 2013 03:16:01 -0400

This plugin allows for sending an email to a handler once the due_date is within a defibale number of days.
This plugin can/will be extended with additional reminder functionality