[ZendTo] 'Your Organization' field too long for database

jules at zend.to jules at zend.to
Thu Sep 17 09:55:37 BST 2020


Thank you for spotting that!

I will work out a fix (and an automatic way of quietly fixing the DB 
schema to extend this field) and put it in the next release.

BTW I assume you're using a MySQL DB back-end, yes?


On 17/09/2020 08:26, Gretton, Liam via ZendTo wrote:
> Hi,
> When someone requests to drop-off a file, one of the fields to 
> complete is 'Your organization'. If the user enters more than 32 
> characters here (which is not disallowed), then the form fails. The 
> zendto log reports:
> Error: Failed to add 2a753247dd272bb39c4547da5b44550f to authtable for 
> user at example.com. Error was Data too long for column 'Organization' at 
> row 1
> The column in the DB is only 32 characters, but the code is not 
> truncating the data from the form before trying to push it in.
> I'm currently running 6.03-5, though a check of the release notes of 
> the newer versions doesn't mention a fix for this yet.
> This has hit us with some collaborators whose organisations really do 
> have long names such as ' Swiss Tropical and Public Health Institute' 
> so my preference would be for the db field to be longer, and to have 
> the code truncate anything that doesn't fit. If I can find time today 
> I'll have a look through the code and try to submit a patch.
> Thanks,
> Liam
> *Liam Gretton
> Systems Specialist***
> **
> IT Services,
> University of Leicester, University Road, Leicester, LE1 7RH, UK
> *t:*+44 (0)116 252 2254
> *e:*liam.gretton at leicester.ac.uk <mailto:liam.gretton at leicester.ac.uk>
> *w:*www.le.ac.uk <http://www.le.ac.uk/>_
> _
> Follow us on Twitter <https://twitter.com/uniofleicester> or visit our 
> Facebook <http://www.facebook.com/uniofleicester> page
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://jul.es/mailman/listinfo/zendto



'All the art of living lies in a fine mingling of letting go,
  and holding on.' - Henry Ellis

Twitter: @JulesFM

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20200917/33119dc8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3340 bytes
Desc: not available
URL: <http://jul.es/pipermail/zendto/attachments/20200917/33119dc8/attachment-0001.gif>

More information about the ZendTo mailing list