MyBB Community Forums

Full Version: ICQ Number/Yahoo ID/Skype ID/Google Hangouts ID can exceed database field
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
The values of ICQ Number, Yahoo ID, Skype ID and Google Hangouts ID are not validated (beside casting ICQ to integer) so you can easily exceed the length of the associated database fields:
Quote:SQL Error: 1406 - Data too long for column 'yahoo' at row 1
Verified this issue at my end as well on MyBB 1.8.21
(2019-06-30, 05:32 AM)StefanT Wrote: [ -> ]The values of ICQ Number, Yahoo ID, Skype ID and Google Hangouts ID are not validated (beside casting ICQ to integer) so you can easily exceed the length of the associated database fields:
Quote:SQL Error: 1406 - Data too long for column 'yahoo' at row 1

'Google +' was or will soon be deprecated. Is Google Hangouts part of 'Google +'?

If so, that would explain why Hangouts is not validated.
(2019-07-01, 04:43 AM)Serpius Wrote: [ -> ]
(2019-06-30, 05:32 AM)StefanT Wrote: [ -> ]The values of ICQ Number, Yahoo ID, Skype ID and Google Hangouts ID are not validated (beside casting ICQ to integer) so you can easily exceed the length of the associated database fields:
Quote:SQL Error: 1406 - Data too long for column 'yahoo' at row 1

'Google +' was or will soon be deprecated. Is Google Hangouts part of 'Google +'?

If so, that would explain why Hangouts is not validated.
Google+ is deprecated.
Google Hangouts is a separate product, basically it is a messenger with video calling, voice calling(Sort of like skype and messenger).
Yes, this should be validated.
Hi,

Thank you for your report. We have pushed this issue to our Github repository for further analysis where you can track our commits and progress with fixing this bug. Discussions regarding this bug may also take place there too.

Follow this link to visit the issue on Github: https://github.com/mybb/mybb/issues/3753

Thanks for contributing to MyBB!

Regards,
The MyBB Group