View Issue Details

IDProjectCategoryView StatusLast Update
0022632mantisbtupgradepublic2017-04-15 10:24
Reporteraytolpgc Assigned Todregad  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionno change required 
Product Version2.2.1 
Summary0022632: Updating from 1.2.19 to 2.2.1 ... Attachements wont show
Description

Hi,

Just updated from 1.2.19 to 2.2.1. I use <<mysql Ver 15.1 Distrib 10.1.22-MariaDB, for Linux (x86_64) using readline 5.1>> and <<PHP 7.0.16>>.

The update process went fine and i can see everything (users, issues, projects, Etc.). The only problem i have is the attachements. They show the correct name and size, but when i click on the link it shows blank (no error, just a white screen). The same happens if i create a new issue.

I did a new install in the same machine to check if its a MySQL/Apache/PHP problem and attachements work fine.

Attachements are saved in the DB.

Any help to fix this issue will be appreciated :-)

Steps To Reproduce

update was done as described in: https://www.mantisbt.org/docs/master/en-US/Admin_Guide/html-desktop/#admin.install.upgrade

TagsNo tags attached.
Attached Files

Activities

dregad

dregad

2017-03-31 10:43

developer   ~0056299

Last edited: 2017-03-31 10:54

Sorry if I'm stating the obvious, but did you check the PHP / apache logs for errors ?

You may also want to try to configure your system to give debbuging information in case of error. Please follow these steps:

  1. temporarily configure your system as follows:
    $g_display_errors = array(
    E_WARNING => 'halt',
    E_NOTICE => 'halt',
    E_USER_ERROR => 'halt',
    E_USER_WARNING => 'halt',
    E_USER_NOTICE => 'halt'
    );
    $g_show_detailed_errors = ON;

WARNING - SECURITY RISK: the 'show_detailed_errors' config can cause MantisBT to display sensitive information about your system. We recommend to restrict its activation to a Test environment, only for as long as necessary. If possible, do not turn it ON globally, instead limit it for specific user(s) using the Manage Configuration page.

  1. Reproduce the error

If the output does not help you resolving the issue and you need further assistance,

  1. save the output of the error screen, preferably as an HTML page (not a screenshot)
  2. be careful to remove/mask any confidential information if needed
  3. upload the results here
aytolpgc

aytolpgc

2017-04-03 02:44

reporter   ~0056338

Hi,

Thanks for the advice! I added the debug lines u recomend and i get errors (attach html file). Seems that the main error is described as: <<'mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50552 Library:100122' in '/var/www/html/mantisbt/library/adodb/drivers/adodb-mysqli.inc.php' line 124>>.

Googling a bit it seems i need to switch to "mysqlnd" (https://dev.mysql.com/downloads/connector/php-mysqlnd/).

Does this seem right? Someone with the same problem switched to mysqlnd and fixed the issue?

Thanks in advance for any help.

error.htm (4,687 bytes)   
<!DOCTYPE html>
<html><head>
	<meta http-equiv="Content-type" content="text/html; charset=UTF-8">
	<title>Error Log</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
</head>
<body class="skin-3">
<div class="col-md-12 col-xs-12"><div class="space-20"></div><div class="alert alert-danger"><p class="bold">SYSTEM WARNING</p><p>'mysqli_real_connect():
 Headers and client library minor version mismatch. Headers:50552 
Library:100122' in 
'/var/www/html/mantisbt/library/adodb/drivers/adodb-mysqli.inc.php' line
 124</p><p>		</p><table class="width-100">
			<tbody><tr>
				<td>Full path: /var/www/html/mantisbt/library/adodb/drivers/adodb-mysqli.inc.php</td>
			</tr>
			<tr>
				<td>Line: 124</td>
			</tr>
			<tr>
				<td>
					<table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">argHostname</td><td style="width=70%; word-wrap:break-word; overflow:auto;">localhost</td><td style="width=10%;">string</td></tr>
<tr><td style="width=20%; word-wrap:break-word; overflow:auto;">argUsername</td><td style="width=70%; word-wrap:break-word; overflow:auto;">{user}</td><td style="width=10%;">string</td></tr>
<tr><td style="width=20%; word-wrap:break-word; overflow:auto;">argPassword</td><td style="width=70%; word-wrap:break-word; overflow:auto;">{password}</td><td style="width=10%;">string</td></tr>
<tr><td style="width=20%; word-wrap:break-word; overflow:auto;">argDatabasename</td><td style="width=70%; word-wrap:break-word; overflow:auto;">bugtracker</td><td style="width=10%;">string</td></tr>
<tr><td style="width=20%; word-wrap:break-word; overflow:auto;">persist</td><td style="width=70%; word-wrap:break-word; overflow:auto;"></td><td style="width=10%;">boolean</td></tr>
<tr><td colspan="3" style="word-wrap:break-word"><br><strong>arr</strong></td></tr><tr><td colspan="3"><table class="width100" style="table-layout:fixed;"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td style="width=20%; word-wrap:break-word; overflow:auto;">0</td><td style="width=70%; word-wrap:break-word; overflow:auto;">5</td><td style="width=10%;">integer</td></tr>
<tr><td style="width=20%; word-wrap:break-word; overflow:auto;">1</td><td style="width=70%; word-wrap:break-word; overflow:auto;">0</td><td style="width=10%;">integer</td></tr>
</tbody></table></td></tr></tbody></table>				</td>
			</tr>
		</tbody></table>
<p></p><p></p><div class="table-responsive"><table class="table table-bordered table-striped table-condensed"><tbody><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr><td>/var/www/html/mantisbt/library/adodb/drivers/adodb-mysqli.inc.php</td><td>124</td><td>-</td><td>-</td><td>mysqli_real_connect</td><td>(
 &lt;Object&gt;&lt;mysqli&gt; ( [affected_rows] =&gt; NULL, 
[client_info] =&gt; NULL, [client_version] =&gt; NULL, [connect_errno] 
=&gt; NULL, [connect_error] =&gt; NULL, [errno] =&gt; NULL, [error] 
=&gt; NULL, [error_list] =&gt; NULL, [field_count] =&gt; NULL, 
[host_info] =&gt; NULL, [info] =&gt; NULL, [insert_id] =&gt; NULL, 
[server_info] =&gt; NULL, [server_version] =&gt; NULL, [stat] =&gt; 
NULL, [sqlstate] =&gt; NULL, [protocol_version] =&gt; NULL, [thread_id] 
=&gt; NULL, [warning_count] =&gt; NULL ), &lt;string&gt;'localhost', 
&lt;string&gt;'mantis', &lt;string&gt;'mantis.207', 
&lt;string&gt;'bugtracker', &lt;integer&gt;3306, &lt;string&gt;'', 
&lt;integer&gt;0 )</td></tr><tr><td>/var/www/html/mantisbt/library/adodb/adodb.inc.php</td><td>670</td><td>ADODB_mysqli</td><td>-&gt;</td><td>_connect</td><td>( &lt;string&gt;'localhost', &lt;string&gt;'mantis', &lt;string&gt;'mantis.207', &lt;string&gt;'bugtracker' )</td></tr><tr><td>/var/www/html/mantisbt/core/database_api.php</td><td>143</td><td>ADOConnection</td><td>-&gt;</td><td>Connect</td><td>( &lt;string&gt;'localhost', &lt;string&gt;'mantis', &lt;string&gt;'mantis.207', &lt;string&gt;'bugtracker' )</td></tr><tr><td>/var/www/html/mantisbt/core.php</td><td>225</td><td>-</td><td>-</td><td>db_connect</td><td>( &lt;string&gt;'', &lt;string&gt;'localhost', &lt;string&gt;'mantis', &lt;string&gt;'mantis.207', &lt;string&gt;'bugtracker' )</td></tr><tr><td>/var/www/html/mantisbt/index.php</td><td>31</td><td>-</td><td>-</td><td>require_once</td><td>( &lt;string&gt;'/var/www/html/mantisbt/core.php' )</td></tr></tbody></table><p></p></div></div>	<script type="text/javascript" src="error_files/bootstrap-3.js"></script>
</div></body></html>
error.htm (4,687 bytes)   
aytolpgc

aytolpgc

2017-04-03 05:03

reporter   ~0056340

Confirmed, installing php7-mysqlnd fixed the issue.

Thanks for all the help and hope this is usefull for someone in the future :-)

dregad

dregad

2017-04-03 06:49

developer   ~0056344

Thanks for the feedback, glad you were able to fix your problem.