MyBB Community Forums

Full Version: SQL Error: 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.
[Image: ziTgrZ7.png]
what on earth?

I can't access the site via Chrome/IE.
I can access the site via firefox.
Recent MyBB updates introduced changes to the length of the useragent column in the mybb_sessions table - it's possible that your database structure was not altered correctly.
You can inspect these values using e.g. phpMyAdmin and set the length to 200 (make a backup first):
ALTER TABLE `mybb_sessions` MODIFY COLUMN useragent varchar(200) NOT NULL default ''
The same might apply to mybb_adminsessions and mybb_spiders tables.
(2016-06-06, 09:20 PM)Devilshakerz Wrote: [ -> ]Recent MyBB updates introduced changes to the length of the useragent column in the mybb_sessions table - it's possible that your database structure was not altered correctly.
You can inspect these values using e.g. phpMyAdmin and set the length to 200 (make a backup first):
ALTER TABLE `mybb_sessions` MODIFY COLUMN useragent varchar(200) NOT NULL default ''
The same might apply to mybb_adminsessions and mybb_spiders tables.

I used this query on those 3 columns, its still showing  Sad Sad Sad
How come this is only happening with browsers other than firefox?

Edit:
phpmyadmin is retarded. I just checked and my query did not go through(wth?). I changed varchar to 200 manually.
It's fixed ! THANK YOU!