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

[Gretton, Liam]

Hi Jules,

Yep, I'm using MySQL (well, MariaDB).

Regards,

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/>
[cid:image001.gif at 01D68CDC.37AA4DD0]
Follow us on Twitter<https://twitter.com/uniofleicester> or visit our Facebook<http://www.facebook.com/uniofleicester> page

From: jules at zend.to <jules at zend.to>
Sent: 17 September 2020 09:56
To: ZendTo Users <zendto at zend.to>
Cc: Gretton, Liam <liam.gretton at leicester.ac.uk>
Subject: Re: [ZendTo] 'Your Organization' field too long for database

Liam,

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?

Cheers,
Jules.
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<mailto: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<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.le.ac.uk%2F&data=02%7C01%7Cliam.gretton%40leicester.ac.uk%7C10a0200a50b74a0857aa08d85ae773e7%7Caebecd6a31d44b0195ce8274afe853d9%7C0%7C0%7C637359297421298364&sdata=5QjX3n9TqQH7xAXDxC1%2BDpyZe8sKvSfpWpsofls%2B5q8%3D&reserved=0>
[cid:image001.gif at 01D68CDC.37AA4DD0]
Follow us on Twitter<https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Funiofleicester&data=02%7C01%7Cliam.gretton%40leicester.ac.uk%7C10a0200a50b74a0857aa08d85ae773e7%7Caebecd6a31d44b0195ce8274afe853d9%7C0%7C0%7C637359297421298364&sdata=nhERR6NpTq8208K1yRRw9M75oRjPyqKbfocRlcbJ52E%3D&reserved=0> or visit our Facebook<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.facebook.com%2Funiofleicester&data=02%7C01%7Cliam.gretton%40leicester.ac.uk%7C10a0200a50b74a0857aa08d85ae773e7%7Caebecd6a31d44b0195ce8274afe853d9%7C0%7C0%7C637359297421308357&sdata=%2FqgkbkOy7%2Bbc%2BO2u08gWB0rm588m8Co5D175UpQbaDA%3D&reserved=0> page




_______________________________________________

ZendTo mailing list

ZendTo at zend.to<mailto:ZendTo at zend.to>

http://jul.es/mailman/listinfo/zendto<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fjul.es%2Fmailman%2Flistinfo%2Fzendto&data=02%7C01%7Cliam.gretton%40leicester.ac.uk%7C10a0200a50b74a0857aa08d85ae773e7%7Caebecd6a31d44b0195ce8274afe853d9%7C0%7C0%7C637359297421318355&sdata=cddFTETdMlLg6ulqi4Vo5sY0YNcBS2x6T77x%2F2K0QHE%3D&reserved=0>



Jules



--

Julian Field MEng CEng CITP MBCS MIEEE MACM



'All the art of living lies in a fine mingling of letting go,

 and holding on.' - Henry Ellis



www.Zend.To<https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.zend.to%2F&data=02%7C01%7Cliam.gretton%40leicester.ac.uk%7C10a0200a50b74a0857aa08d85ae773e7%7Caebecd6a31d44b0195ce8274afe853d9%7C0%7C0%7C637359297421318355&sdata=ZKTQHmvprMarKK0a%2B2lK7Ft49HZL40Gpxtg43OEeypg%3D&reserved=0>

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