<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1808357124;
mso-list-type:hybrid;
mso-list-template-ids:-595305084 269025297 269025305 269025307 269025295 269025305 269025307 269025295 269025305 269025307;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>2 files need to be patched.</span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>1) Patch index.php as follows; the file should end
like this:</span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>-------------------------------------------</span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>echo "<table
align='center'><tr><td align='center'>"; <br>
// Under the Sugar Public License referenced above, you are required to leave
in all copyright statements in both <br>
// the code and end-user application. <br>
//echo("<br>&copy; 2004 <a href='http://www.sugarcrm.com'
target='_blank'>SugarCRM Inc.</a> All Rights Reserved.<BR
/>"); <br>
if($calculate_response_time) <br>
{ <br>
$endTime = microtime(); <br>
<br>
$deltaTime = microtime_diff($startTime, $endTime); <br>
echo('&nbsp;Server response time: '.$deltaTime.' seconds.'); <br>
} <br>
echo "</td></tr></table>\n"; <br>
} <br>
<br>
echo "<script>\n"; <br>
echo "var userDateFormat =
\"$current_user->date_format\"\n"; <br>
echo "</script>\n"; <br>
<br>
}</span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 31.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>-------------------------------------------</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>The
change is in the last few lines; this puts the assignment of userDateFormat
inside the check for viewing an attachment or not, and does so in (I think) a
nicer format.</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>2)
Change line 99 of startVtiger.sh to:</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>------------------</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>./bin/mysqld_safe
--basedir=$MYSQL_HOME --datadir=$MYSQL_HOME/data --socket=$mysql_socket
--tmpdir=$MYSQL_HOME/tmp --user=root --port=$mysql_port
--max_allowed_packet=16M --default-table-type=INNODB > /dev/null & </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>------------------</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>The
change is the addition of –max_allowed_packet=16M</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>Eventually,
we’re going to have to start distributing proper unix diff patches for
this stuff; it makes life MUCH easier.</span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>DG </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 face="Courier New"><span style='font-size:12.0pt;font-family:"Courier New"'> </span></font></p>
<p class=MsoNormal style='border:none;padding:0in'><font size=2 face="Times New Roman"><span style='font-size:10.0pt'> </span></font></p>
</div>
</div>
</body>
</html>