[ZendTo] File Type Icons Bug

[Jules]

Karl,

Thanks for spotting that, it's something I never automatically fixed in 
the MySQL schema.
If you upgrade to the latest version I've just published (5.02-5), it 
should update the table tonight.
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.

If you're happy using the MySQL client command line, the SQL to make the 
change is this:
ALTER TABLE file MODIFY mimeType varchar(256) NOT NULL;

But, as I say, if you just update ZendTo and leave it overnight, it will 
automatically apply that change for you anyway.
The change is totally non-destructive and shouldn't damage your existing 
data in any way (I did test that!).

Thanks!
Jules.

On 26/02/2018 23:46, Karl Bundy wrote:
>
> Jules,
>
> 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.
>
> 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.
>
> Thanks,
>
> ---Karl
>
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/zendto

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

www.Zend.To
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20180227/bdab3c87/attachment.html