View Issue Details

IDProjectCategoryView StatusLast Update
0022427mantisbtmarkdownpublic2017-03-08 04:09
Reporteradelav1 Assigned Toatrol  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionno change required 
PlatformWindowsOSWindowsOS Version2008R2
Product Version2.2.0 
Summary0022427: Crash with specific description/note content and markdown on
Description

if in text or in a note of a bug, we have

  • one asterisk (not in first position)
  • 660 characters or more after the asterisk
  • markdown on
    => We cannot consult the bug, mantis crash.

The text sample is in the attachment

We have the bug in 2.1.0, 2.2.0 and fresh installation

TagsNo tags attached.
Attached Files
textContent.txt (1,485 bytes)   
Erreur fatale lors de l'édition d'un litige
Ex: 0331078





TransportsAlloin.Framework.Classes.Common.Exceptions.DAOException: Erreur lors de l'accès aux données ---> Oracle.DataAccess.Client.OracleException: ORA-00904: ""CT.PRESTATION"" : identificateur non valide
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at TransportsAlloin.Framework.Helpers.NH.DBCommandExtensions.ExecuteDataSet[T](IDbCommand commande)
   at TransportsAlloin.Macadam.DAO.GestionTiers.DAOLitige.LoadLitigeClientForPrinting(Int64 idLitige)
   --- End of inner exception stack trace ---
   at TransportsAlloin.Macadam.DAO.GestionTiers.DAOLitige.LoadLitigeClientForPrinting(Int64 idLitige)
   at TransportsAlloin.Macadam.Service.Edition.SO.SODossierLitige.LoadData(Contexte contexte, ParametreDossierLitige parameters, EditDossierLitige& data)
   at TransportsAlloin.Macadam.Service.Edition.SO.SOPrinting.PrintGeneric[T,U](Contexte contexte, U parameters, ServicePrinting`2 servicePrinting)
textContent.txt (1,485 bytes)   

Activities

atrol

atrol

2017-02-28 06:18

developer   ~0055820

Erreur fatale lors de l'édition d'un litige
Ex: 0331078

TransportsAlloin.Framework.Classes.Common.Exceptions.DAOException: Erreur lors de l'accès aux données ---> Oracle.DataAccess.Client.OracleException: ORA-00904: ""CT.PRESTATION"" : identificateur non valide
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at TransportsAlloin.Framework.Helpers.NH.DBCommandExtensions.ExecuteDataSet[T](IDbCommand commande)
at TransportsAlloin.Macadam.DAO.GestionTiers.DAOLitige.LoadLitigeClientForPrinting(Int64 idLitige)
--- End of inner exception stack trace ---
at TransportsAlloin.Macadam.DAO.GestionTiers.DAOLitige.LoadLitigeClientForPrinting(Int64 idLitige)
at TransportsAlloin.Macadam.Service.Edition.SO.SODossierLitige.LoadData(Contexte contexte, ParametreDossierLitige parameters, EditDossierLitige& data)
at TransportsAlloin.Macadam.Service.Edition.SO.SOPrinting.PrintGeneric[T,U](Contexte contexte, U parameters, ServicePrinting`2 servicePrinting)

atrol

atrol

2017-02-28 06:20

developer   ~0055821

adelav1,

I was not able to reproduce your problem on my test system.
I added also your context as a note without getting a crash.

This might be a PHP issue.

The following additional information may be useful:

  • Exact version of PHP, Database, Web server, Browser and Operating System
  • Relevant customizations (e.g. changes in config_inc.php, etc)
  • Installed plugins or custom functions ?
  • Was the MantisBT source code modified in any way ?
adelav1

adelav1

2017-02-28 07:58

reporter   ~0055822

Version MantisBT: 2.2.0
Version PHP: 5.4.14
Version DB MantisBT: 209
Version ADOdb: 5.20.9
Web server : Apache 2.4.4
Operating System: Windows 2008R2

browsers: Chrome, Firefox, IE 11

  • Plugins: MantisCoreFormating 2.2.0
  • Markdown Enabled
  • No custom functions
  • No changes in source code

When we disable Markdown, we don't have the problem.

config_inc.php (10,646 bytes)   
<?php
    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                     TECHNIQUE                                             //
    ///////////////////////////////////////////////////////////////////////////////////////////////
    // SALT
    $g_crypto_master_salt     = 'QjJ6A0xN+MXJAwRMxP6jeNDCFYutlra2BFcRxx+3gd4=';
    // DATABASE
    $g_hostname               = '127.0.0.1';
    $g_db_type                = 'mysqli';
    $g_database_name          = 'mantis';
    $g_db_username            = 'mantis';
    $g_db_password            = 'mantis';
	$g_db_schema	          = '';
    // MAIL
    $g_enable_email_notification  = ON;
    $g_phpMailer_method           = 2 ;
    $g_smtp_host                  = 'frlio-smtp-relay';
    $g_webmaster_email            = 'arnaud.lepaul@kuehne-nagel.com';
    $g_from_email                 = 'donotreply@kuehne-nagel.com';
    $g_return_path_email          = 'donotreply@kuehne-nagel.com';
    $g_from_name                  = 'Mantis MOE';   
    // ATTACHEMENTS
    $g_file_upload_method                   = DISK;
    $g_absolute_path_default_upload_folder  = 'D:\Macadam\mantisMOE\attachments\\'; 
    $g_max_file_size		                = 25000000;
    // PASSWORDS / ACCOUNTS / COOKIE
    $g_allow_signup         = OFF;
    $g_send_reset_password  = OFF;
    $g_email_ensure_unique  = OFF; // creation de comptes de test avec le meme mail
    $g_cookie_prefix		= 'MANTISMOE';   
    
    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                     AFFICHAGE                                             //
    ///////////////////////////////////////////////////////////////////////////////////////////////
    // LANGUAGE / DATES
    $g_default_language     = 'french';
    $g_short_date_format    = 'd/m/y';
    $g_normal_date_format   = 'd/m/Y H:i';
    $g_complete_date_format = 'd/m/Y H:i';
    $g_default_timezone     = 'Europe/Paris';
    // CSV SEPARATOR
	$g_csv_separator = ';';
    // AVATARS
    $g_show_avatar           = OFF;
    // REALNAME
    $g_show_realname         = OFF; 
    // DISPLAY
    $g_window_title          = 'Mantis MOE Kuehne+Nagel Road';
	$g_logo_image            = 'images/mantis_logo_kn.png';
    $g_default_home_page     = 'view_all_bug_page.php';
    // MY DISPLAY
    $g_my_view_boxes = array (
                                'assigned'      => '1',
                                'monitored'     => '2',
                                'reported'      => '3',
                                'my_comments'   => '4',
                                'recent_mod'    => '5',
                                'unassigned'    => '6',
                                'resolved'      => '0',
                                'feedback'      => '0',
                                'verify'        => '0',
                            );
    $g_my_view_bug_count = 6;
    $g_default_limit_view = 100;
    // PRIORITY ICONS    
    $g_status_icon_arr = array (
        NONE      => 'fa-angle-double-down fa-lg fa-2x green',
        LOW       => 'fa-angle-down fa-lg fa-2x green',
        NORMAL    => 'fa-minus fa-lg orange2',
        HIGH      => 'fa-angle-up fa-lg fa-2x red',
        URGENT    => 'fa-angle-double-up fa-lg fa-2x red',
        IMMEDIATE => 'fa-exclamation-triangle fa-lg red'
        );

    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                       ETATS                                               //
    ///////////////////////////////////////////////////////////////////////////////////////////////    
    // ENUM
    #            NOUVEAU / EN ANALYSE  / AFFECTE     / DEVELOPPEMENT  / REALISE     / VALIDE INTC      / LIVRE        / REOUVERT   / FERME     / REJETE
    # cible    : '10:new , 11:analysis , 12:affected , 13:development , 80:resolved , 82:validatedintc , 85:delivered ,30:reopened , 90:closed , 91:rejected';

	$g_status_enum_string   = '10:new,11:analysis,12:affected,13:development,80:resolved,82:validatedintc,85:delivered,30:reopened,90:closed,91:rejected';
	$g_status_colors         = array( 
        'new'           => '#FF9999', # rose,
        'analysis'      => '#FFFF99', # jaune clair
        'affected'      => '#99CCFF', # beue clair
        'development'   => '#FFCC99', # jaune sablé
        'resolved'      => '#CCFFCC', # vert clair
        'validatedintc' => '#99FF99', # vert
        'delivered'	    => '#009900', # vert
        'reopened'      => '#FF9900', # orange
        'closed'        => '#999999', # gris
        'rejected'      => '#993300', # marron
        ); 
                                     
	# --- enum strings ----------------
	# status from $g_status_index-1 to 79 are used for the onboard customization (if enabled)
	# directly use Mantis to edit them.
	$g_access_levels_enum_string		= '10:viewer,25:reporter,40:updater,55:developer,70:manager,90:administrator';
	$g_project_status_enum_string		= '10:development,30:release,50:stable,70:obsolete';
	$g_project_view_state_enum_string	= '10:public,50:private';
	$g_view_state_enum_string			= '10:public,50:private';
	$g_priority_enum_string				= '30:normal,40:high,50:urgent';
	$g_severity_enum_string				= '50:minor,60:major,80:block';
	$g_reproducibility_enum_string		= '10:always,30:sometimes';
                           
    # @@@ for documentation, the values in this list are also used to define variables in the language files
    #  (e.g., $s_new_bug_title referenced in bug_change_status_page.php )
    # Embedded spaces are converted to underscores (e.g., "working on" references $s_working_on_bug_title).
    # they are also expected to be english names for the states
	$g_resolution_enum_string			= '10:open,20:fixed,50:not fixable,70:not a bug,80:suspended,90:wont fix';
	$g_sponsorship_enum_string          = '0:Unpaid,1:Requested,2:Paid';
	$g_custom_field_type_enum_string    = '0:string,1:numeric,2:float,3:enum,4:email,5:checkbox,6:list,7:multiselection list,8:date';

    
    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                    PERMISSIONS                                            //
    ///////////////////////////////////////////////////////////////////////////////////////////////
    // CHANGELOG
    $g_view_changelog_threshold         = DEVELOPER;
    // ROADMAP
    $g_roadmap_view_threshold           = DEVELOPER;
    // CONFIG (pour les colonnes surtout...)
    $g_manage_configuration_threshold   = DEVELOPER;
    $g_manage_site_threshold            = DEVELOPER;
    $g_manage_project_threshold         = DEVELOPER;
    // STATS
	$g_view_summary_threshold           = DEVELOPER;
    // CUSTOM FIELDS
    $g_custom_field_link_threshold      = ADMINISTRATOR;
    // BUGNOTES FOR VIEWERS
    $g_add_bugnote_threshold            = VIEWER;
    $g_bugnote_user_edit_threshold      = VIEWER;
    $g_bugnote_user_delete_threshold    = VIEWER;
    // DUE DATE
    $g_due_date_view_threshold          = NOBODY;
    $g_due_date_update_threshold        = NOBODY;
    // PERMALINK
    $g_create_permalink_threshold       = REPORTER;
    // NO PROFILES
    $g_enable_profiles                  = OFF;
    $g_add_profile_threshold            = NOBODY;
    $g_manage_global_profile_threshold  = NOBODY;
    // NO AUTOASSIGN
	$g_auto_set_status_to_assigned	    = ON;
    // TAGS
	$g_tag_view_threshold               = NOBODY;
	$g_tag_attach_threshold             = NOBODY;
	$g_tag_detach_threshold             = $g_tag_attach_threshold;
	$g_tag_detach_own_threshold         = $g_tag_attach_threshold;
	$g_tag_create_threshold             = $g_tag_attach_threshold;
	$g_tag_edit_threshold               = $g_tag_attach_threshold;
	$g_tag_edit_own_threshold           = $g_tag_attach_threshold;
	// PRIVATE  BUGNOTES
	$g_private_bugnote_threshold	    = NOBODY;
    // SUB PROJECT DISPLAY
	$g_summary_category_include_project	= ON;
    // NO CATEGORY
    $g_allow_no_category                = ON;
    // PROJECT DOCUMENTATION
	$g_enable_project_documentation	    = OFF;
    // NEWS
	$g_news_enabled	                    = OFF;
    
    // Masquer eta et projection.
	$g_enable_eta = OFF;
	$g_enable_projection = OFF;
    # Deactivate Build Field.
	$g_enable_product_build = OFF;
	# Deactivate product version.
	//$g_show_product_version = ON;
    
    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                    VISIBLE FIELDS                                         //
    ///////////////////////////////////////////////////////////////////////////////////////////////
    // REPORT
    $g_bug_report_page_fields = array('category_id',
		'handler', 'priority', 'severity', 'summary', 'description',
		'attachments', 'tags', 'target_version',);
    // VIEW
	$g_bug_view_page_fields = array ('id', 'project', 'category_id',
		'date_submitted', 'last_updated', 'due_date', 'reporter', 
        'handler', 'priority', 'severity', 'status', 'summary', 
        'description', 'attachments', 'tags', 'fixed_in_version','target_version',);
    // OTHER    
	$g_bug_print_page_fields = $g_bug_view_page_fields;
	$g_bug_update_page_fields = $g_bug_view_page_fields;
	$g_bug_change_status_page_fields = $g_bug_view_page_fields;
    
    ///////////////////////////////////////////////////////////////////////////////////////////////
    //                                    VISIBLE COLUMNS                                        //
    ///////////////////////////////////////////////////////////////////////////////////////////////
    // VIEW 
    $g_view_issues_page_columns =  array ('selection', 'edit', 'priority', 'id', 'attachment_count','bugnotes_count', 'custom_Canal', 'category_id', 
    'severity', 'reporter_id', 'status', 'date_submitted', 'last_updated',  'summary', 
    'target_version', 'fixed_in_version', 'custom_cible',);
    // EXPORTS
    $g_csv_columns =  array ('selection', 'edit', 'priority', 'id', 'attachment_count', 'bugnotes_count', 'custom_Canal', 'category_id', 
    'severity', 'reporter_id', 'status', 'date_submitted', 'last_updated', 'summary', 
    'target_version', 'fixed_in_version', 'custom_cible',);
    $g_excel_columns = $g_csv_columns;
    $g_print_issues_page_columns = $g_csv_columns;

?>
config_inc.php (10,646 bytes)   
atrol

atrol

2017-02-28 08:26

developer   ~0055823

Last edited: 2017-02-28 08:26

Are there any errors or warnings in your web server logs?

Do you get any errors or warnings when running admin/check/index.php?

Which database do you use?

adelav1

adelav1

2017-02-28 08:47

reporter   ~0055824

MySql 5.6

When we consult the bugs, apache seems to restart:
[Tue Feb 28 14:36:35.100119 2017] [mpm_winnt:notice] [pid 4840:tid 308] AH00418: Parent: Created child process 4352
[Tue Feb 28 14:36:35.755328 2017] [mpm_winnt:notice] [pid 4352:tid 492] AH00354: Child: Starting 64 worker threads.
[Tue Feb 28 14:36:36.332535 2017] [mpm_winnt:notice] [pid 4840:tid 308] AH00428: Parent: child process 4352 exited with status 255 -- Restarting.
[Tue Feb 28 14:36:36.426136 2017] [mpm_winnt:notice] [pid 4840:tid 308] AH00455: Apache/2.4.4 (Win32) PHP/5.4.14 configured -- resuming normal operations

Mantis check:
PHP
Xdebug extension is not loaded. For security reasons this extension should not be loaded on production and Internet facing servers. WARN
display_errors php.ini directive is disabled. For security reasons this directive should be disabled on all production and Internet facing servers. WARN
display_startup_errors php.ini directive is disabled. For security reasons this directive should be disabled on all production and Internet facing servers. WARN

atrol

atrol

2017-02-28 08:56

developer   ~0055825

As a first step I recommend to disable the Xdebug extension.

adelav1

adelav1

2017-02-28 09:03

reporter   ~0055826

I have disabled Xdebug and set display_errors & display_startup_errors to off.
We have no more warning in check page.

The problem remains.

atrol

atrol

2017-02-28 09:17

developer   ~0055827

adelav1,

This seems not to be a bug of MantisBT (you are asking for help on how to deal with PHP crashes). I am therefore resolving this issue as "no change required".

It seems there is a problem with your PHP installation.

You should be aware that you are using an outdated PHP version which is no longer supported. [1]
I recommend to upgrade at least to a newer or latest 5.4.45 version [2]
If possible, I recommend at the moment to use latest 7.0 version (7.0.16 at the moment) [3]

Feel free to reopen the issue, if you should find that upgrading PHP does not fix the issue.

[1] http://php.net/supported-versions.php
[2] http://php.net/ChangeLog-5.php#5.4.45
[3] http://php.net/ChangeLog-7.php#7.0.16