-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 3.0.9-RC1
-
Fix Version/s: 3.0.9-RC2
-
Component/s: Login
-
Labels:None
-
Environment:PHP 5.3.4, MySQL(i) 5.1.53, LG Optimus 2X Default Browser.
When logging in with a mobile device I receive an SQL error on the new table *_login_attempts. Data too long for column 'attempt_browser'.
Default value is too small at 150 or value needs to be trimmed as in session.php for session_browser.
The browser string is 164 chars,
Mozilla/5.0 (Linux; U; Android 2.2.2; en-gb; LG-P990 Build/FRG83G) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1 MMS/LG-Android-MMS-V1.0/1.2