[ZendTo] Problem with long names for dropoff sender

[Jules Field]

Hi Liam,

Sorry I never got back to you about this!

Are you using a MySQL/MariaDB back-end?
If you're using SQLite, I don't think it ever checks the string length 
anyway, it should just store all of it.

If you are using MySQL/MariaDB as the DB back-end, you should be able to 
just alter the table yourself to increase the max length of that string. 
Doing so won't break anything.

Cheers,
Jules.

On 15/05/2022 11:41 am, Gretton, Liam via ZendTo wrote:
>
> 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/>_
> _
> 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

Jules

-- 
Julian Field MEng CEng CITP MBCS MIEEE MACM

The current UK shipping forecast:
Shannon, Rockall: Southwesterly 6 to gale 8, perhaps severe gale 9 later in
west. Rough or very rough. Thundery showers. Good, occasionally poor.

www.Zend.To
Twitter: @JulesFM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20221031/ff5c61e1/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/20221031/ff5c61e1/attachment-0001.gif>