Solved: 5 Years, 3 Months, 1 Week ago [Error Message] SQL Error: 1406 - Data too long for column 'useragent' at row 1
#1
Solved: 5 Years, 3 Months, 1 Week ago
[Image: ziTgrZ7.png]
what on earth?

I can't access the site via Chrome/IE.
I can access the site via firefox.
Reply
#2
Solved: 5 Years, 3 Months, 1 Week ago
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.
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#3
Solved: 5 Years, 3 Months, 1 Week ago
(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!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)