[ZendTo] Problem with long names for dropoff sender

[Gretton, Liam]

Hi Jules,

I've come up against a similar problem in the backend MySQL DB schema that I've encountered before with organisation names (since fixed by you - thanks).

Now we're seeing some users with particularly long names, and they're unable to upload to ZendTo as their names exceed the 32 character limit in the dropoff.senderName field, but it's not trapped by the code.

The error log reports:

Error: Failed to add drop-off hX9Fem7GY2MFgXir. Error was Data too long for column 'senderName'

Though I haven't explicitly tried the latest 6.12-1 beta version, the schema appears to be the same for this table at least.

In our case the sender's name comes from the cn attribute in our LDAP directory.

It would be great if the senderName field's size could be bumped up, or the frontend altered to truncate the input if necessary.

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20220515/a8ddf920/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/20220515/a8ddf920/attachment-0001.gif>