MyBB Community Forums
[Pushed] sessions - useragent column still varchar(100) ? - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Development (https://community.mybb.com/forum-161.html)
+--- Forum: MyBB 1.8 Development (https://community.mybb.com/forum-165.html)
+---- Forum: 1.8 Bugs and Issues (https://community.mybb.com/forum-157.html)
+----- Forum: Pushed (https://community.mybb.com/forum-183.html)
+----- Thread: [Pushed] sessions - useragent column still varchar(100) ? (/thread-168339.html)



sessions - useragent column still varchar(100) ? - avril - 2015-03-11

This issue is so old i though it was fixed 100 years ago allready, but i see its not.

In 1.8.x table sessions - column useragent is still varchar(100) which causes useragent string to be cut,
therefore for long strings it cannot be analysed / recognized properly when needed. 


RE: sessions - useragent column still 100 varchar(100) ? - Destroy666 - 2015-03-11

To which exact number should we increase it? I don't think there's a hard limit for useragents and 100 should suffice to get the most important informations.


RE: sessions - useragent column still 100 varchar(100) ? - avril - 2015-03-11

No idea, perhaps 256 could fit for most,
tho if you search google for it youll find stuff about 512 ect.. whatever..
can always search more and find maybe something out there define how long it may be, by so called, "standards".

Look at this for example, its way more than 100, and still it looks cut.
How much data that is useful for some is lost there...


RE: sessions - useragent column still varchar(100) ? - Jones H - 2015-06-25

There has been some discussion about this already on GitHub IIRC. It was increased somewhere to "200" but not everywhere. IMHO we should increase it to at least 200 as 100 is pretty short.


RE: sessions - useragent column still varchar(100) ? - Jones H - 2015-07-02

Anyone else? Otherwise I'll push it and change it to "200"


RE: sessions - useragent column still varchar(100) ? - Omar G. - 2015-07-02

Sure.


RE: sessions - useragent column still varchar(100) ? - Omar G. - 2015-07-02

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/2128

Thanks for contributing to MyBB!

Regards,
The MyBB Group