MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > 1406 - Data too long for column 'useragent' at row 1
Full Version: 1406 - Data too long for column 'useragent' at row 1
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

0btc

2016-06-30, 06:53 PM
Hello,

I'm getting this error on my forum. I did a backup restore when I migrated from Webmin to cPanel and now the forum shows -


SQL Error:
1406 - Data too long for column 'useragent' at row 1
Query:
REPLACE INTO mybb_sessions SET uid=0,sid='968d4781aa80e84dfd8aae3b8cebbfed',time=1467312883,ip=X'4e92652d',location='/index.php?',useragent='Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36',location1=0,location2=0,nopermission=0

Matt

2016-07-01, 10:37 AM
Strange, can you use phpMyAdmin to look at the structure of the mybb_sessions table and see what the length of the useragent column is? it should be 200, and that user agent string is only 109 characters so it should be fine.
MyBB Community Forums > 1.8 Support > General Support > 1406 - Data too long for column 'useragent' at row 1