<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Karl,<br>
<br>
Thanks for spotting that, it's something I never automatically fixed
in the MySQL schema.<br>
If you upgrade to the latest version I've just published (5.02-5),
it should update the table tonight.<br>
If a "yum update" doesn't find the update, do a "yum clean all" and
then another "yum update zendto" and it should see it's available.<br>
<br>
If you're happy using the MySQL client command line, the SQL to make
the change is this:<br>
ALTER TABLE file MODIFY mimeType varchar(256) NOT NULL;<br>
<br>
But, as I say, if you just update ZendTo and leave it overnight, it
will automatically apply that change for you anyway.<br>
The change is totally non-destructive and shouldn't damage your
existing data in any way (I did test that!).<br>
<br>
Thanks!<br>
Jules.<br>
<br>
<div class="moz-cite-prefix">On 26/02/2018 23:46, Karl Bundy wrote:<br>
</div>
<blockquote type="cite"
cite="mid:e15e46e8aa6f4658b83be9ef27370793@MBX03B-IAD3.mex08.mlsrvr.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Jules,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I really like the new file type icons, but
we are running into a small issue here with office-type
documents. It appears that the mime-type gets truncated to 32
characters, and so the long mime-type for MS Office documents
get truncated from
“application-vnd.openxmlformats-officedocument.wordprocessingml.document”
to “application-vnd.openxmlformats-o” and therefore are not
able to find the proper file type icon, and they get the
default unknown.svg icon. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It would be great if the mimeType field in
the database could be expanded to hold the full mime-type
value for these types of files.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">---Karl<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto">http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng CEng CITP MBCS MIEEE MACM
'There have been nearly 3000 Gods so far but only yours actually exists.
The others are silly made up nonsense. But not yours. Yours is real.' - Anon
<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
</body>
</html>