[ZendTo] File Type Icons Bug

[Bocquet Stéphane]

Maybe a little info here…

https://dev.mysql.com/doc/refman/5.7/en/char.html

With MySQL v5.0.3, VARCHAR is stuck at 255… after, you can go to 65535.

De : zendto-bounces at zend.to [mailto:zendto-bounces at zend.to] De la part de Jules
Envoyé : mardi 27 février 2018 11:31
À : Karl Bundy <karl.bundy at aldentorch.com>; ZendTo Users <zendto at zend.to>
Objet : Re: [ZendTo] File Type Icons Bug

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<mailto: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<http://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/58b380b1/attachment-0001.html