My b2evolution Version: Not Entered
Please, I need some help with this error just encountered. :(
I ran into an interesting issue while using Internet Explorer 7 on my main computer while logging into B2E.
I received the following error:
An unexpected error has occured!
If this error persits, please report it to the administrator.
Go back to home page
Additional information about this error:
Data too long for column 'user_browser' at row 1(Errno=1406)
Your query: DataObject::dbinsert()
INSERT INTO evo_users (user_login, user_pass, user_locale, user_email, user_level, dateYMDhour, user_allow_msgform, user_notify, user_showonline, user_nickname, user_validated, user_firstname, user_lastname, user_idmode, user_ip, user_domain, user_browser, user_grp_ID)
The browser value string was set to: (last five fields for context)
'namefl', '10.29.81.59', '10.29.81.59', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; Tablet PC 2.0; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; MS-RTC LM 8)', 4)
The browser string is 225 characters. Well past the 200 characters in the column user_browser.
Any hints on how to solve this one?
What code can be modified as to how to truncate the string or change the column size?
Any assistance or suggestions would be most appreciated.