MyBB Community Forums

When i try to log into another user i get the following mysql error

Quote:SQL Error:
1406 - Data too long for column 'location' at row 1
Query:
UPDATE mybb_sessions SET uid='1', time='1242789974', location='/member.php?action=profile&google_seo_user=xX50LashesXx&action=login&do=hijack&my_post_key=c0588a2bbb65065a304414c03a24a00a&google_seo_redirect=debug', useragent='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10', location1='0', location2='0', nopermission='0' WHERE sid='70e6effefa474741159002eced4749f5' LIMIT 1

Im pretty sure this has something to do with google seo but i dont know how to fix it.

Any help is appreciated

Well, I'm only starting to learn PHP/MySQL and I haven't used this plugin before. But from what I can tell its to let you know that the "location" column is longer then its allowed to be. So basically the below code is causing the error.

Quote:location='/member.php?action=profile&google_seo_user=xX50LashesXx&action=login&do=hijack&my_post_key=c0588a2bbb65065a304414c03a24a00a&google_seo_redirect=debug',

My suggestion would be to either find a way to shorten the string or perhaps give the column permission to be longer through PHPADMIN. Of course, I'm sure someone here could be more helpful as I'm just giving my guess on what I would do to fix it.

it has nothing todo with google seo, i have booth mods installed and it works fine

How would i shorten the string or give the column permission to be longer

Im still fairly new to this stuff but im trying to learn

try switching of google SEO debugger

Thank you -=snAke=- that worked like a charm.

And thank you to everyone else that helped

Sorry for answering to this old thread
I have a similar question and find no solution on the internet.

This is my error when opening threads that have long titles:

Quote:

Quote:SQL Error:1406 - Data too long for column 'location' at row 1
Query:REPLACE INTO forum_sessions SET
uid='1',sid='f3a3c64c0804a12a98dd278dc8b12bc8',time='1537943864',ip='2.183.54.222',location='/forum/showthread.php?google_seo_thread=آزمون-استخدامی-43نفر-کار-در-وزارت-نیرو-در-سراسر-کشور؛-مهلت-�',useragent='Mozilla/5.0 (Windows NT 6.1; rv:49.0) Gecko/20100101 Firefox/49.0',location1='31',location2='2277',nopermission='0'

Google seo debugging is off, by default. Increasing field size to VARCHAR (15000) also does not work.
Decreasing length of thread titles works, but i cannot do it for all threads one by one.

It sounds for me that Google Seo cannot convert seo-style thread title to original form (i.e. , forum/thread-1272).

Any help would be greatly appreciated.